Skip to Content.
Sympa Menu

freetds - Re: Session is hanging

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Session is hanging
  • Date: Tue, 4 Dec 2001 19:36:17 -0500 (EST)



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







Archive powered by MHonArc 2.6.24.

Top of Page