Skip to Content.
Sympa Menu

freetds - RE: [freetds] RE: output parameters and "unknown marker"

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] RE: output parameters and "unknown marker"
  • Date: Fri, 7 Jan 2005 10:49:42 -0000

All,

I'm having a good look at our handling of AC (RETURNVALUE) packets.
I'm pretty sure now that MS's version of this packet is different from
Sybase's, and as yet it doesn't appear to make much sense.
I'll keep you posted.

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Thompson, Bill D
(London)
Sent: 07 January 2005 10:21
To: FreeTDS Development Group
Subject: RE: [freetds] RE: output parameters and "unknown marker"


Hi Alan,

I've recently noticed how well jTDS is doing - congratulations on API
cursors!

I'd noticed the length thing too - there seem to be issues with the SQL
server AC (RETURNVALUE) packet.

I've just run a test on a RPC call to Sybase and SQL server where the
RPC returns a NULL in an INT OUTPUT param.

Here's the two AC (RETURNVALUE) Packets...

Sybase:

token packet name name max
actual
length length @nrows) status user type type length
length

ac 000f 06 406e726f7773 01 00000000 26 04
00


Notice several things about this:

1) the packet length is correct
2) the data type is SYBINTN (showing it is a variable length datatype)

SQL Server

token packet name name

length length @nrows) status user type type
??

ac 1300 06 40006e0072006f0077007300 01 38000000 38
00

Notice several things about this:

1) packet length seems to make no sense
2) user type and type are both SYBINT4 (fixed length datatype)
3) The following 00 could be a single byte "length of data" or a NULL
Indicator.
but how are we supposed to know , given that we expect fixed length
data to follow.

Have you fixed this in jTDS ?

Bill





-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Alin Sinpalean
Sent: 07 January 2005 10:02
To: freetds AT lists.ibiblio.org
Subject: [freetds] RE: output parameters and "unknown marker"


Has anyone else noticed that the packet length is incorrect? According
to the header it's supposed to be 17 bytes but it's 18. This makes me
think it's an SQL Server problem.

Alin Sinpalean,
The jTDS Project.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain or redistribute it. Click here for important additional terms
relating to this e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------





Archive powered by MHonArc 2.6.24.

Top of Page