FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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,
> 
>