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 20:21:15 -0500 (EST)



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')
>





Archive powered by MHonArc 2.6.24.

Top of Page