freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] No tables displayed in StarOffice usinf FreeTDS/ODBC
- From: Martin Spott <mas AT plesnik.de>
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] No tables displayed in StarOffice usinf FreeTDS/ODBC
- Date: Wed, 18 Dec 2002 16:22:23 +0100
Hello,
some days ago I mentioned getting an ODBC connection to a local Sybase
server at least connected. After connection, StarOffice offers the option to
have a look at the tables in my database. I I choos this option, I get told
no tables were present.
I'm logging this stuf into 'freetds.log'. Connecting to the server ends
with:
[...]
2002-12-18 16:11:41.317105 inside tds_process_end() more_results = 0,
was_cancelled = 1
SQLFreeHandle(3, 0x84f7b50)
Whatever this means, this appears to work. Afterwards, when I choose to look
at
the tables, FreeTDS logs the following to 'freetds.log':
odbc:SQLGetInfo: info option 25 not supported
odbc:SQLGetInfo: info option 86 not supported
odbc:SQLGetInfo: info option 86 not supported
Does anyone have a clue how these messages have to be interpreted ?
During gathering table information, the 'unixODBC' driver manager writes to
'sql.log':
[ODBC][1794][SQLGetInfo.c][179]
Entry:
Connection = 0x844ffe0
Info Type = SQL_DATA_SOURCE_READ_ONLY (25)
Info Value = 0xbfffddd0
Buffer Length = 512
StrLen = 0xbfffddce
[ODBC][1794][SQLGetInfo.c][504]
Exit:[SQL_ERROR]
[ODBC][1794][SQLGetDiagRec.c][586]
Entry:
Connection = 0x844ffe0
Rec Number = 1
SQLState = 0xbfffdd7c
Native = 0xbfffdb6c
Message Text = 0xbfffdb7c
Buffer Length = 511
Text Len Ptr = 0xbfffdb72
[ODBC][1794][SQLGetDiagRec.c][623]
Exit:[SQL_NO_DATA]
[ODBC][1794][SQLGetInfo.c][179]
Entry:
Connection = 0x844ffe0
Info Type = SQL_ALTER_TABLE (86)
Info Value = 0xbfffdfa8
Buffer Length = 4
StrLen = 0xbfffdfae
[ODBC][1794][SQLGetInfo.c][504]
Exit:[SQL_ERROR]
[ODBC][1794][SQLGetDiagRec.c][586]
Entry:
Connection = 0x844ffe0
Rec Number = 1
SQLState = 0xbfffdf58
Native = 0xbfffdd48
Message Text = 0xbfffdd58
Buffer Length = 511
Text Len Ptr = 0xbfffdd4e
[ODBC][1794][SQLGetDiagRec.c][623]
Exit:[SQL_NO_DATA]
[ODBC][1794][SQLGetInfo.c][179]
Entry:
Connection = 0x844ffe0
Info Type = SQL_ALTER_TABLE (86)
Info Value = 0xbfffdfa8
Buffer Length = 4
StrLen = 0xbfffdfae
[ODBC][1794][SQLGetInfo.c][504]
Exit:[SQL_ERROR]
[ODBC][1794][SQLGetDiagRec.c][586]
Entry:
Connection = 0x844ffe0
Rec Number = 1
SQLState = 0xbfffdf58
Native = 0xbfffdd48
Message Text = 0xbfffdd58
Buffer Length = 511
Text Len Ptr = 0xbfffdd4e
[ODBC][1794][SQLGetDiagRec.c][623]
Exit:[SQL_NO_DATA]
Thanks for any clue,
Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
-
[freetds] [ListManager-admin AT franklin.metalab.unc.edu: Re: your subscribe request],
Steve Langasek, 12/18/2002
- [freetds] No tables displayed in StarOffice usinf FreeTDS/ODBC, Martin Spott, 12/18/2002
- <Possible follow-up(s)>
- RE: [freetds] [ListManager-admin AT franklin.metalab.unc.edu: Re: your subscribe request], Harrison, Bruce (CXO), 12/18/2002
Archive powered by MHonArc 2.6.24.