Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problem with data type conversions and FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Vanns <jimv AT canterbury.ac.uk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Problem with data type conversions and FreeTDS
  • Date: Wed, 30 Jul 2003 15:25:36 -0000

The freetds log shows this:

<snip>
2003-07-30 15:47:05.748766 Connecting addr 5.0.8.210 port 1433 with TDS
version 8.0
</snip>

The value from tds_convert when the srctype is SYBUNIQUE is -4 - any
ideas what this means? Where is the #define associated with -4 !?

Jim

On Wed, 2003-07-30 at 15:43, ZIGLIO Frediano wrote:
> >
> > Yes, like I said I am using FreeTDS.tar.gz 0.61 which was
> > compiled to use 8.0 as the protocol version - and this is
> > what I use when I establish a connection. So is my code (as
> > far as TDS is concerned) correct? This is starting to get a
> > little frustrating! Could I cast the field value to a
> > TDS_UNIQUE structure? Or is this what tds_convert should be doing?
> >
> > Thanks
> >
> > Jim
> >
>
> Your code is correct. You can cast value to TDS_UNIQUE, tds_convert
> should convert it to string for you.
> Try setting TDSDUMP environment variable and check you are really using
> TDS8 or try setting TDSVER to "8.0" (or "7.0"). tsql do conversion in
> the same way...
>
> $ ./src/apps/tsql -SXXXX -Usa
> locale is "en_US"
> using default charset "ISO-8859-1"
> Password:
> Msg 5703, Level 0, State 1, Server OPDN014, Line 0
> Changed language setting to us_english.
> 1> select newid()
> 2> go
>
> 3231E85A-FF29-45F2-9FE9-D544454C32BE
> 1>
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
--
James Vanns BSc (Hons) MCP
Linux Systems Administrator
Software Engineer (Linux / C & C++)
Canterbury Christ Church University College
Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x24045370






Archive powered by MHonArc 2.6.24.

Top of Page