cancel
Showing results for 
Search instead for 
Did you mean: 

unixODBC connection ok but no Data !

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Please find the trace attaced.

reagrds

jph

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Burkhard,


yes, in the meantime I discovered that I have the same Problem with the Oracle-Driver.


I will follow up this issue with the unixODBC guys.

But if I find some solution will post it here in case somebody else get the same Problem.

regards

jph