Skip to Content.
Sympa Menu

freetds - Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Martin Spott <mas AT plesnik.de>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE
  • Date: Thu, 4 Dec 2003 13:40:57 +0100

Martin Spott <Martin.Spott AT uni-duisburg.de> wrote:

> Exactly. Hoooray .... Unfortunately I can't connect to my Sybase
> database anymore, at least not via ODBC driver. I used to test with
> unixODBC's 'isql' commandline monitor:
>
> isnix: 12:53:46 ~> isql gluehbirne mas dummy4
> [ISQL]ERROR: Could not SQLConnect
>
>
> Something's wrong here - I will reverse my CVS tree to last week and
> see if that changes anything.

Found it - most recent changes toggled the behaviour of the ODBC
driver:

gluehbirne: 13:22:21 ~/CVS/FreeTDS/freetds> cvs -q update -dP -D "2 days ago"
gluehbirne: 13:25:39 ~/CVS/FreeTDS/freetds> cvs -q update -dP -D "1 days ago"
P ChangeLog
P configure.in
P doc/tsql.txt
P doc/userguide.sgml
P src/odbc/Makefile.am
P src/odbc/unittests/raiseerror.c
P src/tds/Makefile.am
P src/tds/character_sets.h
P src/tds/config.c
P src/tds/encodings.h
P src/tds/query.c
P src/tds/sybase_character_sets.h
P src/tds/sybase_character_sets.h.pl

I attached a very short 'sql.log' for this case (1st attachment).

Apart from that there's a funny error with FreeTDS/ODBC and OOo-1.1.0
(using a previous versions that can make a connect).
I can connect to my Sybase database, I can browse the database in the
database view subwindow ('F4') and I can klick on a table icon. This
results in a funny query sent to the databas server:

> SELECT * FROM "Orgdaten"."dbo"."ZEITERF" WHERE 0 = 1

For obvious reasons the server rejects this query:

> Incorrect syntax near 'Orgdaten'

I attached compressed 'freetds.log' and 'sql.log' for whom this might
belong (2nd and 3rd attachment),

Martin.
--
Unix _IS_ user friendly - it's just selective about who its friends are !
--------------------------------------------------------------------------
[ODBC][10616][__handles.c][399]
Exit:[SQL_SUCCESS]
Environment = 0x804cc88
[ODBC][10616][SQLAllocHandle.c][328]
Entry:
Handle Type = 2
Input Handle = 0x804cc88
[ODBC][10616][SQLAllocHandle.c][448]
Exit:[SQL_SUCCESS]
Output Handle = 0x804d380
[ODBC][10616][SQLConnect.c][2914]
Entry:
Connection = 0x804d380
Server Name = [gluehbirne][length = 10 (SQL_NTS)]

User Name = [mas][length = 3 (SQL_NTS)]
Authentication = [******][length = 6 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data
source

[ODBC][10616][SQLConnect.c][3299]
Exit:[SQL_ERROR]
[ODBC][10616][SQLFreeHandle.c][250]
Entry:
Handle Type = 2
Input Handle = 0x804d380
[ODBC][10616][SQLFreeHandle.c][301]
Exit:[SQL_SUCCESS]
[ODBC][10616][SQLFreeHandle.c][184]
Entry:
Handle Type = 1
Input Handle = 0x804cc88



Archive powered by MHonArc 2.6.24.

Top of Page