on 06-18-2014 4:00 PM
Hi out there,
I Installed unixODBC and the maxDB Driver on a Client machine and try to get Data from my server.
I followed this Howto: http://wiki.scn.sap.com/wiki/display/MaxDB/HowTo+-+MaxDB+ODBC+and+unixODBC
I get a connection and It looks like I get the Information about Tables and Colums and even the count of rows but no Data Content.
Example using isql:
SQL> select * from ZF_TYP
+-------+-----------------------------------------------------------------+---------------------------+------------+------+
| ZFTMTD| NAME | WANN | WER | STATE|
+-------+-----------------------------------------------------------------+---------------------------+------------+------+
| | | | | |
| | | | | |
+-------+-----------------------------------------------------------------+---------------------------+------------+------+
SQLRowCount returns 2
2 rows fetched
SQL> select now() from dual
+---------------------------+
| EXPRESSION1 |
+---------------------------+
| |
+---------------------------+
SQLRowCount returns 1
1 rows fetched
SQL> select TIMESTAMP FROM DUAL
+---------------------------+
| EXPRESSION1 |
+---------------------------+
| |
+---------------------------+
SQLRowCount returns 1
1 rows fetched
my .odbc.ini content:
cat ~/.odbc.ini
[db01dcw]
ServerDB=MAXDB
ServerNode=db01.team.etb
SQLMode=ORACLE
IsolationLevel=Committed
TraceFileName=/home/jph/odbctrace.log
Driver=/opt/sdb/JPH/lib/libsdbodbc.so
anyone any Idea ??
regards
jph
P.S.
Client:
openSUSE 12.3 "Dartmouth" ( x86_64 GNU/Linux )
/opt/sdb/globalprograms/bin/sdbregview -l
Installation: Global /opt/sdb/globalprograms
Global Listener 7.9.08.21 valid 64 bit
Installation Compatibility 7.9.08.21 valid 64 bit
Installer 7.9.08.21 valid
Installation: JPH /opt/sdb/JPH
Base 7.9.08.21 valid 64 bit
JDBC 7.6.09.00 valid
Messages MSG 0.10302 valid
ODBC 7.9.08.21 valid 64 bit
SQLDBC 7.9.08.21 valid 64 bit
SQLDBC 77 7.9.08.21 valid 64 bit
Server :
MaxDB 7.8.02.28
Hi,
please activate the odbc trace log with the odbc_cons tool and post the reuslts.
Use the trace switches sql and api.
>odbc_cons trace sql on
>odbc_cons trace api on
run isql and post the result of the log file. The trace log loaction shown with the odbc_cons command 'show all'.
Kind regards,
Burkhard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
H,
I have checked the log file and I am being at los. There are no errors in and the data is returned
The data is only copied internally but I could not find a call where isql retrives the data fetched.
SQLFetch 2014-06-19 10:20:05.168182
--> SQLExtendedFetch
::GET RESULT SET [0x0xfe49b0]
CURSOR NAME: 'SQLCURS_2' [0x0xfe1d40]
SQLExtendedFetch 2014-06-19 10:20:05.168251
StatementHandle [in] : 0xfe1310
FetchOrientation [in] : SQL_FETCH_NEXT
FetchOffset [in] : 0
::SET ROWSET SIZE 'SQLCURS_2' [0x0xfe1d40]
SIZE: 1
::SET BINDING TYPE 'SQLCURS_2' [0x0xfe1d40]
BINDING TYPE: 0
::FETCH NEXT 'SQLCURS_2' 2014-06-19 10:20:05.168397
DATA:
APPLICATION
I T AT L I DATA
ROW: 1
::GET ROWS AFFECTED [0x0xfe1d40]
ROWS: 1
::GET ROWS AFFECTED [0x0xfe1d40]
ROWS: 1
RowCountPtr [out] : (null)
RowStatusArray [out] : (null)
SQLRETURN : SQL_SUCCESS
<-- SQLExtendedFetch
SQLColAttribute 2014-06-19 10:20:05.168551
StatementHandle [in] : 0xfe1310
ColumnNumber [in] : 1
FieldIdentifier [in] : SQL_COLUMN_DISPLAY_SIZE
BufferLength [in] : 0
NumericAttrPtr [out] : 26
NumericAttrPtr [out] : 0x7fff81d03d7c
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLColAttribute 2014-06-19 10:20:05.168664
StatementHandle [in] : 0xfe1310
ColumnNumber [in] : 1
FieldIdentifier [in] : SQL_COLUMN_LABEL
BufferLength [in] : 301
CharacterAttrPtr [out] : 0x7fff81d03d80
StringLengthPtr [out] : (null)
SQLRETURN : SQL_SUCCESS
SQLGetData 2014-06-19 10:20:05.168754
StatementHandle [in] : 0xfe1310
ColumnNumber [in] : 1
TargetType [in] : SQL_C_CHAR
TargetValuePtr [out] : 0x7fff81d03f10
BufferLength [in] : 301
ValuePtr [out] : SQL_UB_OFF
::GETOBJECT 'SQLCURS_2' 2014-06-19 10:20:05.168851 [0x0x1015dc0]
COLUMN
I T AT L I D P
1 ASCII T 301 0x00007FFF81D03B20 0x00007FFF81D03F10 0x0000000000000000
DATA
I T AT L I DATA
1 ASCII T 301 26 '2014-06-19 10:19:33.218298'
StrLen_or_IndPtr [out] : 26
SQLRETURN : SQL_SUCCESS
I am not familar with isql. Did you hav tried to ask the question in a isql forum? It might be that someone can check why no data is retireved from isql.
Kind regards,
Burkhard
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.