FreeTDS Development Group

[Evan Rempel <erempel AT uvic.ca>]

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

Attachment: tds.freetds-0624.log
Description: Binary data

Attachment: tds.freetds-063.log
Description: Binary data

Attachment: odbc.freetds-0624.log
Description: Binary data

Attachment: odbc.freetds-063.log
Description: Binary data