freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE
- 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
-
[freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Ocke Janssen, 12/03/2003
-
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Martin Spott, 12/03/2003
-
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Ocke Janssen, 12/04/2003
- Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, Martin Spott, 12/04/2003
-
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Ocke Janssen, 12/04/2003
- <Possible follow-up(s)>
-
RE: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
ZIGLIO Frediano, 12/03/2003
- Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, Ocke Janssen, 12/04/2003
- Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, Martin Spott, 12/04/2003
-
RE: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
ZIGLIO Frediano, 12/04/2003
- Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, Martin Spott, 12/04/2003
- RE: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, Lowden, James K, 12/04/2003
- RE: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, ZIGLIO Frediano, 12/04/2003
-
RE: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
ZIGLIO Frediano, 12/04/2003
-
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Martin Spott, 12/04/2003
- Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE, Ocke Janssen, 12/05/2003
-
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Martin Spott, 12/04/2003
-
Re: [freetds] Error in SQLGetInfo for SQL_FILE_USAGE,
Martin Spott, 12/03/2003
Archive powered by MHonArc 2.6.24.