[freetds] 0.63 bug - error messages garbled
Evan Rempel
erempel at uvic.ca
Thu Aug 11 14:26:01 EDT 2005
Thanks for the suggestions. The logs are a little difficult fo me to read.
It appears that ODBC does not get the error message back from the TDS
driver
[ODBC][20729][SQLPrepare.c][364]
Exit:[SQL_ERROR]
[ODBC][20729][SQLError.c][342]
Entry:
Statement = 0x896cb28
SQLState = 0xbfffa870
Native = 0xbfffa848
Message Text = 0xbfffa880
Buffer Length = 511
Text Len Ptr = 0xbfffa84e
[ODBC][20729][SQLError.c][379]
Exit:[SQL_NO_DATA]
I have included both logs for both unixODBC and for freetds when
using freetds 0.62.4 which is successful, and freetds 0.63 which is
unsuccessful.
Evan.
On Mon, 8 Aug 2005, Frediano Ziglio wrote:
> Date: Mon, 08 Aug 2005 21:01:07 +0200
> From: Frediano Ziglio <freddyz77 at tin.it>
> Reply-To: FreeTDS Development Group <freetds at lists.ibiblio.org>
> To: FreeTDS Development Group <freetds at lists.ibiblio.org>
> Subject: Re: [freetds] 0.63 bug - error messages garbled
>
> Il giorno lun, 08/08/2005 alle 10.35 -0700, Evan Rempel ha scritto:
>> When using the 0.63 version, compiled on Redhat AS3.0 with no special
>> options (./configure; make; make install) the driver returns garbled error
>> messages.
>>
>> I tested this with TCL and tclodbc 2.5 which workes perfectly with freetds
>> 0.62.4 but with 0.63 if returns garbled error messages.
>>
>> With 0.62.4
>> % DB "select evan from internal_marks"
>> S0022 207 {[unixODBC][FreeTDS][SQL Server]Invalid column name 'evan'.}
>>
>> With 0.63
>> % DB "select evan from internal_marks"
>> 00000 4 {HKX i}
>>
>
> Note that there is not unixODBC (added later by unixODBC...) so where
> does the bug reside ?? Try enabling ODBC logging and post the log.
>
>>
>> If I make a correct query, both versions return the correct data.
>>
>> Using isql I get slightly different error messages
>>
>> With 0.62.4 I get
>> echo 'select evan from internal_marks' | isql LocalTSM user password
>> +---------------------------------------+
>> | Connected! |
>> | |
>> | sql-statement |
>> | help [tablename] |
>> | quit |
>> | |
>> +---------------------------------------+
>> [ISQL]ERROR: Could not SQLExecute
>>
>> With 0.63 I get
>> echo 'select evan from internal_marks' | isql LocalTSM user password
>> +---------------------------------------+
>> | Connected! |
>> | |
>> | sql-statement |
>> | help [tablename] |
>> | quit |
>> | |
>> +---------------------------------------+
>> [ISQL]ERROR: Could not SQLPrepare
>>
>
> isql usually SQLPrepare first then SQLExecute. Probably 0.63 detect
> error before 0.62.4. Enabling logs (FreeTDS ones here would help too)
> can help. Witch database system and version are you using ?
>
> freddy77
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
--
Evan Rempel erempel at uvic.ca
Senior Programmer Analyst 250.721.7691
Computing Services
University of Victoria
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tds.freetds-0624.log
Type: application/octet-stream
Size: 11398 bytes
Desc:
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050811/4bb81224/tds.freetds-0624-0001.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tds.freetds-063.log
Type: application/octet-stream
Size: 14636 bytes
Desc:
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050811/4bb81224/tds.freetds-063-0001.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: odbc.freetds-0624.log
Type: application/octet-stream
Size: 3315 bytes
Desc:
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050811/4bb81224/odbc.freetds-0624-0001.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: odbc.freetds-063.log
Type: application/octet-stream
Size: 2325 bytes
Desc:
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050811/4bb81224/odbc.freetds-063-0001.obj
More information about the FreeTDS
mailing list