FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

I found these in spt_datatype_info, the real obvious differences were that 
CREATE_PARMS should be "length" not NULL, case sensitive should be 0, and 
searchable should be 2 (whatever that means).  If you modify your 
tables.sql file accordingly and reload it, it may help (or may not).

Brian

On Tue, 4 Dec 2001, Brian Bruns wrote:

> 
> The select from tds_typeinfo is caused by a call to SQLGetTypeInfo() and 
> type -2 would be binary.  This returns a result set with type name, 
> literal prefix, nullable and some other info and the 'fd' token shows that 
> the result set completed successfully.  The brio server never invokes the 
> ODBC driver again after this, so apparently something in the result set, 
> the application doesn't like and must itself be hanging.
> 
> The real question is, what is it expecting?  The ODBC driver for Windows 
> should be loading a table similar to tds_typeinfo and it could be queried 
> to see what results should be being returned for binary and make FreeTDS 
> match that.  I'll see if my configuration has anything of the sort, you 
> may want to do the same.
> 
> Cheers,
> 
> Brian
> 
> On Mon, 3 Dec 2001, Greg Connaughton wrote:
> 
> > I am trying to get my application to connect to a SQL Server database
> > and it just goes out and hangs. My connection works fine from isql, and
> > from what I can see of the dump file, it looks like it behaving
> > properly. Anybody know what might be making my application hang?  I am
> > trying to use brio server with this on Solaris 2.8.  The TDSDUMP file
> > looks like this for the last stmt executed:
> > 
> > Sending packet @ 2001-12-03 23:34:41
> > 0000  01 01 00 3b 00 00 00 00 53 45 4c 45 43 54 20 2a   |...;....SELECT
> > *|
> > 0010  20 46 52 4f 4d 20 74 64 73 5f 74 79 70 65 69 6e   | FROM
> > tds_typein|
> > 0020  66 6f 20 57 48 45 52 45 20 53 51 4c 5f 44 41 54   |fo WHERE
> > SQL_DAT|
> > 0030  41 5f 54 59 50 45 20 3d 20 2d 32                  |A_TYPE = -2|
> > 
> > 
> > 2001-12-03 23:34:41 processing result tokens.  marker is  a0
> > 2001-12-03 23:34:41 processing result tokens.  marker is  a1
> > 2001-12-03 23:34:41 inside tds_process_default_tokens() marker is a1
> > 2001-12-03 23:34:41 processing result tokens.  marker is  d1
> > 2001-12-03 23:34:41 processing row tokens.  marker is  d1
> > 2001-12-03 23:34:41 setting column 0 to NULL
> > 2001-12-03 23:34:41 setting column 1 to NULL
> > 2001-12-03 23:34:41 setting column 2 to NULL
> > 2001-12-03 23:34:41 setting column 3 to NULL
> > 2001-12-03 23:34:41 setting column 4 to NULL
> > 2001-12-03 23:34:41 setting column 5 to NULL
> > 2001-12-03 23:34:41 setting column 6 to NULL
> > 2001-12-03 23:34:41 setting column 7 to NULL
> > 2001-12-03 23:34:41 setting column 8 to NULL
> > 2001-12-03 23:34:41 setting column 9 to NULL
> > 2001-12-03 23:34:41 setting column 10 to NULL
> > 2001-12-03 23:34:41 setting column 11 to NULL
> > 2001-12-03 23:34:41 setting column 12 to NULL
> > 2001-12-03 23:34:41 setting column 13 to NULL
> > 2001-12-03 23:34:41 setting column 14 to NULL
> > 2001-12-03 23:34:41 setting column 15 to NULL
> > 2001-12-03 23:34:41 setting column 16 to NULL
> > 2001-12-03 23:34:41 setting column 17 to NULL
> > 2001-12-03 23:34:41 setting column 18 to NULL
> > 2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
> > BINARY
> > 2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string = 0x
> > 2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
> > 2001-12-03 23:34:41 converting string dlen = 130 dtype = 47 string =
> > 2001-12-03 23:34:41 processing row tokens.  marker is  fd
> > 
> > I have attached the complete log if it helps.
> > 
> > Thanks,
> > 
> > 
> 
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>