Skip to Content.
Sympa Menu

freetds - [freetds] Need help with core dump trace

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Philip" <philip_38 AT hotmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Need help with core dump trace
  • Date: Thu, 13 Oct 2005 12:41:31 -0400

My perl script is blowing up every time it runs, but it runs perfectly. The
problem is that the core files are filling up the hard-drive. Does anybody
knows what is going on? I use freetds to talk to SQL Server.

Reading symbols from /usr/lib/gconv/ISO8859-1.so...done.
Loaded symbols for /usr/lib/gconv/ISO8859-1.so
#0 0x00870b98 in syb_st_destroy (sth=0x0, imp_sth=0x98f02d0) at
dbdimp.c:3990
3990 if (DBIc_DBISTATE(imp_dbh)->debug >= 3)
(gdb) bt
#0 0x00870b98 in syb_st_destroy (sth=0x0, imp_sth=0x98f02d0) at
dbdimp.c:3990
#1 0x00864999 in XS_DBD__Sybase__st_DESTROY (my_perl=0x9719008,
cv=0x98d7c10) at Sybase.xsi:726
#2 0x00e869c3 in XS_DBI_dispatch (my_perl=0x9719008, cv=0x987915c) at
DBI.xs:2656
#3 0x02ddba82 in Perl_pp_entersub () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#4 0x02d69b09 in Perl_get_cv () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#5 0x02d6fea7 in Perl_call_sv () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#6 0x02ddec97 in Perl_sv_clear () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#7 0x02ddf584 in Perl_sv_free () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#8 0x02ddefc4 in Perl_sv_clear () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#9 0x02ddf584 in Perl_sv_free () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#10 0x02dc5b55 in Perl_mg_free () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#11 0x02ddf12e in Perl_sv_clear () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#12 0x02ddf584 in Perl_sv_free () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#13 0x02de4665 in Perl_sv_setpvn_mg () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#14 0x02ddd90c in Perl_sv_add_arena () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#15 0x02ddd9ce in Perl_sv_clean_objs () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#16 0x02d721bb in perl_destruct () from
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
#17 0x0804934c in main ()

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
freetds-request AT lists.ibiblio.org
Sent: Thursday, October 13, 2005 8:54 AM
To: freetds AT lists.ibiblio.org
Subject: FreeTDS Digest, Vol 33, Issue 13

Send FreeTDS mailing list submissions to
freetds AT lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
freetds-request AT lists.ibiblio.org

You can reach the person managing the list at
freetds-owner AT lists.ibiblio.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of FreeTDS digest..."


Today's Topics:

1. Re: Compiling sqsh-2.1.3 against freetds-0.63 on RH9
(Reuben Pearse)
2. Re: Compiling sqsh-2.1.3 against freetds-0.63 on RH9
(Lowden, James K)
3. SELECT @@IDENTITY AS InsertID (Shaun Craig)
4. Re: SELECT @@IDENTITY AS InsertID (Shaun Craig)


----------------------------------------------------------------------

Message: 1
Date: Wed, 12 Oct 2005 17:09:14 +0100
From: Reuben Pearse <reuben AT presence-systems.com>
Subject: Re: [freetds] Compiling sqsh-2.1.3 against freetds-0.63 on
RH9
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <434D352A.2060807 AT presence-systems.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Thanks James and Bill.

I used your "regen" script to setup stuff for the configure script. I
then hacked the makefile with:

SYBASE_LIBS = -lct -ltds -lnsl -ldl -lm

I also had to put the following lines in:

SYBASE_LIBDIR = -Wl,-R/usr/pkg/lib \
-Wl,-R/usr/local/lib \
-L$(SYBASE_OCOS)/lib

.otherwise sqsh couldn't find the libct.so.3 and libtds.so.4 library files
(I found that on the post
https://lists.ibiblio.org/sympa/arc/freetds/2005q2/018442.html)

I can now connect to MSSQL but when I'm querying textual information I get
the error:

Open Client Message
Layer 0, Origin 0, Severity 9, Number 99
WARNING! Some character(s) could not be converted into client's character
set. Unconverted bytes
were changed to question marks ('?').
Open Client Message
Layer 0, Origin 0, Severity 78, Number 52
Unknown marker

I'm guessing it's some sort of charset setting in the freetds configuration
file?

Thanks for your help

--
Reuben Pearse
Principal Technical Consultant
reuben AT presence-systems.com



Lowden, James K wrote:

>>From: Reuben Pearse
>>Sent: Wednesday, October 12, 2005 9:06 AM
>>
>>I am having problems compiling sqsh-2.1.3 against freetds-0.63 on a
>>Redhat9 Linux server. I managed to compile freetds-0.63 OK and I have
>>verified that it works by using tsql utility to query one of our SQL
>>Servers. However, I now want to get Sqsh working. The "configure"
>>
>>
>script
>
>
>>runs OK, but when running "make" I get the errors:
>>
>>cmd_bcp.o(.text+0x3fb): In function `cmd_bcp':
>>/home/psl/sqsh/sqsh-2.1.3/src/cmd_bcp.c:927: undefined reference
>>to `cs_loc_drop'
>>cmd_bcp.o(.text+0x40b):/home/psl/sqsh/sqsh-2.1.3/src/cmd_bcp.c:922:
>>undefined reference to `ct_close'
>>
>>
>...
>
>
>>Has anyone managed to compile Sqsh against freetds-0.63 before?
>>
>>
>
>Yes.
>
>$ ldd `which sqsh`
>/usr/local/bin/sqsh:
> -lc.12 => /usr/lib/libc.so.12
> -lct.3 => /usr/pkg/lib/libct.so.3
> -ltds.5 => /usr/local/lib/libtds.so.5
> -lm.0 => /usr/lib/libm387.so.0
> -lm.0 => /usr/lib/libm.so.0
> -lcrypt.0 => /usr/lib/libcrypt.so.0
> -lreadline.5 => /usr/pkg/lib/libreadline.so.5
> -lcurses.6 => /usr/lib/libcurses.so.6
>
>It looks like your linker is not finding libct. Try pointing your
>LDFLAGS to the installed FreeTDS libraries. I have a little script
>"regen" that sets the environment before building sqsh:
>
>$ head regen
>export LDFLAGS="${LDFLAGS} -L /usr/pkg/lib"
>export CFLAGS="${CFLAGS} -g -I/usr/pkg/include"
>export SYBASE=/usr/local
>./configure --with-readline=/usr/pkg
>
>HTH.
>
>--jkl
>
>-----------------------------------------
>The information contained in this transmission may be privileged and
>confidential and is intended only for the use of the person(s) named
>above. If you are not the intended recipient, or an employee or agent
responsible
>for delivering this message to the intended recipient, any review,
dissemination,
>distribution or duplication of this communication is strictly prohibited.
If you are
>not the intended recipient, please contact the sender immediately by reply
e-mail
>and destroy all copies of the original message. Please note that we do not
accept
>account orders and/or instructions by e-mail, and therefore will not be
responsible
>for carrying out such orders and/or instructions. If you, as the intended
recipient
>of this message, the purpose of which is to inform and update our clients,
prospects
>and consultants of developments relating to our services and products,
would not
>like to receive further e-mail correspondence from the sender, please
"reply" to the
>sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas,
New York,
>NY 10105.
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>




------------------------------

Message: 2
Date: Wed, 12 Oct 2005 13:18:25 -0400
From: "Lowden, James K" <LowdenJK AT bernstein.com>
Subject: Re: [freetds] Compiling sqsh-2.1.3 against freetds-0.63 on
RH9
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID:

<3778FAB3D61A7A40833F1CB3B8C173AA054FCCBE AT AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain; charset="us-ascii"

> From: Reuben Pearse
> Sent: Wednesday, October 12, 2005 12:09 PM
>
> I used your "regen" script to setup stuff for the configure script.
> I then hacked the makefile with:
>
> SYBASE_LIBS = -lct -ltds -lnsl -ldl -lm
>
> I also had to put the following lines in:
>
> SYBASE_LIBDIR = -Wl,-R/usr/pkg/lib \
> -Wl,-R/usr/local/lib \
> -L$(SYBASE_OCOS)/lib

Well, you don't need /usr/pkg/lib unless you have a /usr/pkg directory.
I run NetBSD, where it's normal to have the pkgsrc system
(www.pkgsrc.org) install packages there.

> I can now connect to MSSQL but when I'm querying textual information
> I get the error:
>
> Open Client Message Layer 0, Origin 0, Severity 9, Number 99 WARNING!
> Some character(s) could not be converted into client's character
> set. Unconverted bytes were changed to question marks ('?').
>
> Open Client Message Layer 0, Origin 0, Severity 78, Number 52
> Unknown marker

http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFFORMAT

"Unknown marker" almost always means you're using the wrong TDS protocol
version. For a Microsoft server, use TDS 7.0 or 8.0.

If your data can't be represented with ISO 8859-1, make sure 'client
charset' in freetds.conf is set appropriately.

That should do it.

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly prohibited. If
you are
not the intended recipient, please contact the sender immediately by reply
e-mail
and destroy all copies of the original message. Please note that we do not
accept
account orders and/or instructions by e-mail, and therefore will not be
responsible
for carrying out such orders and/or instructions. If you, as the intended
recipient
of this message, the purpose of which is to inform and update our clients,
prospects
and consultants of developments relating to our services and products, would
not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas,
New York,
NY 10105.


------------------------------

Message: 3
Date: Thu, 13 Oct 2005 10:32:51 +0100
From: Shaun Craig <s.craig AT andronics.com>
Subject: [freetds] SELECT @@IDENTITY AS InsertID
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <434E29C3.5030603 AT andronics.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Just realised my tdsdump file wasn't attached to email yesterday, so
here it is.

util.c:269:Starting log file for FreeTDS 0.64.dev.20050228
on 2005-10-12 09:31:17 with debug flags 0x4fff.
iconv.c:364:iconv to convert client-side data to the "ISO-8859-1"
character set
iconv.c:517:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:150:Connecting to 127.0.0.1 port 5000.
net.c:650:Sending packet
0000 02 00 02 00 00 00 00 00-73 76 72 2d 73 75 73 65 |........ svr-suse|
0010 2d 31 38 00 00 00 00 00-00 00 00 00 00 00 00 00 |-18..... ........|
0020 00 00 00 00 00 00 0b 73-61 00 00 00 00 00 00 00 |.......***.......|
0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 02 72 75-6c 65 72 00 00 00 00 00 |......******.....|
0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 05 33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 02 00 |........ ........|
0090 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00b0 00 00 00 6d 79 70 6f 6f-6c 00 00 00 00 00 00 00 |...mypoo l.......|
00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00d0 00 06 72 75 6c 65 72 00-00 00 00 00 00 00 00 00 |..*****. ........|
00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
01d0 00 05 04 02 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
01e0 0a 00 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|

net.c:650:Sending packet
0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00 |...L.... ........|
0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f |........ .....iso|
0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1...... ........|
0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00-00 00 00 00 |........ ....|

token.c:317:tds_process_login_tokens()
net.c:437:Received header
0000 04 01 00 dc 00 00 00 00- |........|

net.c:531:Received packet
0000 e3 14 00 01 0b 4c 65 6f-63 61 74 65 54 65 73 74 |.....Leo cateTest|
0010 06 6d 61 73 74 65 72 ab-3e 00 45 16 00 00 02 0a |.master. >.E.....|
0020 2a 00 43 68 61 6e 67 65-64 20 64 61 74 61 62 61 |*.Change d databa|
0030 73 65 20 63 6f 6e 74 65-78 74 20 74 6f 20 27 4c |se conte xt to 'L|
0040 65 6f 63 61 74 65 54 65-73 74 27 2e 04 4a 44 42 |eocateTe st'..JDB|
0050 43 05 5a 5a 5a 5a 5a 01-00 e3 0d 00 02 0a 75 73 |C.ZZZZZ. ......us|
0060 5f 65 6e 67 6c 69 73 68-00 ab 3d 00 47 16 00 00 |_english ..=.G...|
0070 01 0a 29 00 43 68 61 6e-67 65 64 20 6c 61 6e 67 |..).Chan ged lang|
0080 75 61 67 65 20 73 65 74-74 69 6e 67 20 74 6f 20 |uage set ting to |
0090 27 75 73 5f 65 6e 67 6c-69 73 68 27 2e 04 4a 44 |'us_engl ish'..JD|
00a0 42 43 05 5a 5a 5a 5a 5a-01 00 e3 07 00 04 04 31 |BC.ZZZZZ .......1|
00b0 30 32 34 00 ad 14 00 05-05 00 00 00 0a 73 71 6c |024..... .....sql|
00c0 20 73 65 72 76 65 72 01-00 00 01 fd 00 00 02 00 | server. ........|
00d0 01 00 00 00 - |....|

token.c:321:looking for login token, got e3(ENVCHANGE)
token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:178:tds_get_string: reading 11 from wire to give 11 to client.
read.c:178:tds_get_string: reading 6 from wire to give 6 to client.
token.c:321:looking for login token, got ab(INFO)
token.c:106:tds_process_default_tokens() marker is ab(INFO)
token.c:2640:tds_process_msg() reading message from server
read.c:178:tds_get_string: reading 42 from wire to give 42 to client.
read.c:178:tds_get_string: reading 4 from wire to give 4 to client.
read.c:178:tds_get_string: reading 5 from wire to give 5 to client.
token.c:2702:tds_process_msg() calling client msg handler
token.c:2715:tds_process_msg() returning TDS_SUCCEED
token.c:321:looking for login token, got e3(ENVCHANGE)
token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:178:tds_get_string: reading 10 from wire to give 10 to client.
token.c:321:looking for login token, got ab(INFO)
token.c:106:tds_process_default_tokens() marker is ab(INFO)
token.c:2640:tds_process_msg() reading message from server
read.c:178:tds_get_string: reading 41 from wire to give 41 to client.
read.c:178:tds_get_string: reading 4 from wire to give 4 to client.
read.c:178:tds_get_string: reading 5 from wire to give 5 to client.
token.c:2702:tds_process_msg() calling client msg handler
token.c:2715:tds_process_msg() returning TDS_SUCCEED
token.c:321:looking for login token, got e3(ENVCHANGE)
token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:178:tds_get_string: reading 4 from wire to give 4 to client.
token.c:2528:increasing block size from to 1024
token.c:321:looking for login token, got ad(LOGINACK)
read.c:178:tds_get_string: reading 10 from wire to give 10 to client.
token.c:321:looking for login token, got fd(DONE)
token.c:106:tds_process_default_tokens() marker is fd(DONE)
token.c:2344:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2360:tds_process_end() state set to TDS_IDLE
util.c:125:Changing query state from TDS_IDLE to TDS_IDLE
token.c:394:leaving tds_process_login_tokens() returning 1
util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
mem.c:453:tds_free_all_results()
util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
net.c:650:Sending packet
0000 01 01 00 1b 00 00 00 00-73 65 74 20 74 65 78 74 |........ set text|
0010 73 69 7a 65 20 36 34 35-31 32 20 |size 645 12 |

util.c:125:Changing query state from TDS_PENDING to TDS_READING
net.c:437:Received header
0000 04 01 00 11 00 00 00 00- |........|

net.c:531:Received packet
0000 fd 00 00 be 00 00 00 00-00 |........ .|

token.c:526:processing result tokens. marker is fd(DONE)
token.c:2344:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2360:tds_process_end() state set to TDS_IDLE
util.c:125:Changing query state from TDS_READING to TDS_IDLE
util.c:125:Changing query state from TDS_IDLE to TDS_PENDING
token.c:514:tds_process_result_tokens() state is COMPLETED
dblib.c:1138:dbuse()
dblib.c:1054:dbcmd() bufsz = 0
dblib.c:1104:in dbsqlexec()
dblib.c:5818:in dbsqlsend()
util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
mem.c:453:tds_free_all_results()
util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
net.c:650:Sending packet
0000 01 01 00 13 00 00 00 00-75 73 65 20 4c 65 6f 63 |........ use Leoc|
0010 61 74 65 - |ate|

dblib.c:4005:in dbsqlok()
net.c:437:Received header
0000 04 01 00 63 00 00 00 00- |...c....|

net.c:531:Received packet
0000 e3 11 00 01 07 4c 65 6f-63 61 74 65 07 4c 65 6f |.....Leo cate.Leo|
0010 63 61 74 65 ab 3b 00 45-16 00 00 01 00 26 00 43 |cate.;.E .....&.C|
0020 68 61 6e 67 65 64 20 64-61 74 61 62 61 73 65 20 |hanged d atabase |
0030 63 6f 6e 74 65 78 74 20-74 6f 20 27 4c 65 6f 63 |context to 'Leoc|
0040 61 74 65 27 2e 09 53 51-4c 53 45 52 56 45 52 00 |ate'..SQ LSERVER.|
0050 01 00 fd 00 00 e2 00 00-00 00 00 |........ ...|

dblib.c:4024:dbsqlok() marker is e3
util.c:125:Changing query state from TDS_PENDING to TDS_READING
token.c:526:processing result tokens. marker is e3(ENVCHANGE)
token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:178:tds_get_string: reading 7 from wire to give 7 to client.
read.c:178:tds_get_string: reading 7 from wire to give 7 to client.
token.c:526:processing result tokens. marker is ab(INFO)
token.c:106:tds_process_default_tokens() marker is ab(INFO)
token.c:2640:tds_process_msg() reading message from server
read.c:178:tds_get_string: reading 38 from wire to give 38 to client.
read.c:178:tds_get_string: reading 9 from wire to give 9 to client.
token.c:2702:tds_process_msg() calling client msg handler
token.c:2715:tds_process_msg() returning TDS_SUCCEED
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2344:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2360:tds_process_end() state set to TDS_IDLE
util.c:125:Changing query state from TDS_READING to TDS_IDLE
util.c:125:Changing query state from TDS_IDLE to TDS_PENDING
dblib.c:4070:dbsqlok() end status was success
dblib.c:1288:dbresults()
token.c:897:tds_process_row_tokens() state is COMPLETED
dblib.c:1054:dbcmd() bufsz = 12
dblib.c:5007:in dbfreebuf()
dblib.c:1104:in dbsqlexec()
dblib.c:5818:in dbsqlsend()
util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
mem.c:453:tds_free_all_results()
util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
net.c:650:Sending packet
0000 01 01 00 ed 00 00 00 00-49 4e 53 45 52 54 20 49 |........ INSERT I|
0010 4e 54 4f 20 4a 6f 75 72-6e 65 79 20 28 4a 6f 75 |NTO Jour ney (Jou|
0020 72 6e 65 79 53 74 61 72-74 54 69 6d 65 2c 53 74 |rneyStar tTime,St|
0030 61 72 74 4c 61 74 69 74-75 64 65 2c 53 74 61 72 |artLatit ude,Star|
0040 74 4c 6f 6e 67 69 74 75-64 65 2c 4f 64 6f 6d 65 |tLongitu de,Odome|
0050 74 65 72 53 74 61 72 74-2c 56 65 68 69 63 6c 65 |terStart ,Vehicle|
0060 49 44 29 20 56 41 4c 55-45 53 20 28 43 4f 4e 56 |ID) VALU ES (CONV|
0070 45 52 54 28 44 61 74 65-54 69 6d 65 2c 27 32 34 |ERT(Date Time,'24|
0080 20 41 75 67 75 73 74 20-32 30 30 35 20 31 37 3a | August 2005 17:|
0090 30 34 3a 34 39 27 29 2c-43 4f 4e 56 45 52 54 28 |04:49'), CONVERT(|
00a0 66 6c 6f 61 74 2c 27 35-33 2e 33 30 39 37 32 30 |float,'5 3.309720|
00b0 27 29 2c 43 4f 4e 56 45-52 54 28 66 6c 6f 61 74 |'),CONVE RT(float|
00c0 2c 27 2d 32 2e 37 30 33-34 33 39 27 29 2c 43 4f |,'-2.703 439'),CO|
00d0 4e 56 45 52 54 28 69 6e-74 2c 27 31 31 36 32 35 |NVERT(in t,'11625|
00e0 35 33 34 27 29 2c 27 31-31 31 30 27 29 |534'),'1 110')|

dblib.c:4005:in dbsqlok()
net.c:437:Received header
0000 04 01 00 11 00 00 00 00- |........|

net.c:531:Received packet
0000 fd 10 00 c3 00 01 00 00-00 |........ .|

dblib.c:4024:dbsqlok() marker is fd
util.c:125:Changing query state from TDS_PENDING to TDS_READING
token.c:526:processing result tokens. marker is fd(DONE)
token.c:2344:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2360:tds_process_end() state set to TDS_IDLE
util.c:125:Changing query state from TDS_READING to TDS_IDLE
token.c:2376: rows_affected = 1
util.c:125:Changing query state from TDS_IDLE to TDS_PENDING
dblib.c:4070:dbsqlok() end status was success
dblib.c:1288:dbresults()
dblib.c:1054:dbcmd() bufsz = 230
dblib.c:5007:in dbfreebuf()
dblib.c:1104:in dbsqlexec()
dblib.c:5818:in dbsqlsend()
util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
mem.c:453:tds_free_all_results()
util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
net.c:650:Sending packet
0000 01 01 00 25 00 00 00 00-53 45 4c 45 43 54 20 40 |...%.... SELECT @|
0010 40 49 44 45 4e 54 49 54-59 20 41 53 20 49 6e 73 |@IDENTIT Y AS Ins|
0020 65 72 74 49 44 - |ertID|

dblib.c:4005:in dbsqlok()
net.c:437:Received header
0000 04 01 00 30 00 00 00 00- |...0....|

net.c:531:Received packet
0000 a0 09 00 08 49 6e 73 65-72 74 49 44 a1 06 00 19 |....Inse rtID....|
0010 00 01 00 6d 08 d1 08 00-00 00 00 00 80 43 40 fd |...m.... .....C@.|
0020 10 00 c1 00 01 00 00 00- |........|

dblib.c:4024:dbsqlok() marker is a0
dblib.c:4030:dbsqlok() found result token
dblib.c:1288:dbresults()
mem.c:453:tds_free_all_results()
util.c:125:Changing query state from TDS_PENDING to TDS_READING
token.c:526:processing result tokens. marker is a0(COLNAME)
read.c:178:tds_get_string: reading 8 from wire to give 8 to client.
mem.c:453:tds_free_all_results()
token.c:526:processing result tokens. marker is a1(COLFMT)
token.c:1256:processing result. type = 109(float-null), varint_size 1
util.c:125:Changing query state from TDS_READING to TDS_PENDING
dblib.c:1326:dbresults() process_result_tokens returned result_type =
4049 retcode = 1
util.c:125:Changing query state from TDS_PENDING to TDS_READING
token.c:526:processing result tokens. marker is d1(ROW)
util.c:125:Changing query state from TDS_READING to TDS_PENDING
dblib.c:1326:dbresults() process_result_tokens returned result_type =
4040 retcode = 1
dblib.c:2091:dbbind() column = 1 8 0
dblib.c:2123:dbbind() srctype = 62 desttype = 56
convert.c:2887:tds_willconvert()
convert.c:2891:tds_willconvert() 62 56 1
dblib.c:1545:dbnextrow()
dblib.c:1560:dbnextrow() dbresults_state = 2
util.c:125:Changing query state from TDS_PENDING to TDS_READING
token.c:907:processing row tokens. marker is d1(ROW)
token.c:2071:processing row. column is 0 varint size = 1
token.c:2128:processing row. column size is 8
util.c:125:Changing query state from TDS_READING to TDS_PENDING
dblib.c:6244:copy_data_to_host_var(62 [SYBFLT8] len 8 => 56 [SYBINT4] len 0)
dblib.c:6387:copy_data_to_host_var() called tds_convert returned 4

HTH


------------------------------

Message: 4
Date: Thu, 13 Oct 2005 13:54:26 +0100
From: Shaun Craig <s.craig AT andronics.com>
Subject: Re: [freetds] SELECT @@IDENTITY AS InsertID
To: s.craig AT andronics.com, FreeTDS Development Group
<freetds AT lists.ibiblio.org>
Message-ID: <434E5902.108 AT andronics.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Finally got the insertid back from my insert, I just tinkered around
with the code I had and eventually got it back.

Thanks to all who helped me on it.

Shaun.

Shaun Craig wrote:

>Just realised my tdsdump file wasn't attached to email yesterday, so
>here it is.
>
>util.c:269:Starting log file for FreeTDS 0.64.dev.20050228
> on 2005-10-12 09:31:17 with debug flags 0x4fff.
>iconv.c:364:iconv to convert client-side data to the "ISO-8859-1"
>character set
>iconv.c:517:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
>net.c:150:Connecting to 127.0.0.1 port 5000.
>net.c:650:Sending packet
>0000 02 00 02 00 00 00 00 00-73 76 72 2d 73 75 73 65 |........ svr-suse|
>0010 2d 31 38 00 00 00 00 00-00 00 00 00 00 00 00 00 |-18..... ........|
>0020 00 00 00 00 00 00 0b 73-61 00 00 00 00 00 00 00 |.......***.......|
>0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0040 00 00 00 00 00 02 72 75-6c 65 72 00 00 00 00 00 |......******.....|
>0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0060 00 00 00 00 05 33 37 38-37 36 00 00 00 00 00 00 |.....378 76......|
>0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 02 00 |........ ........|
>0090 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>00b0 00 00 00 6d 79 70 6f 6f-6c 00 00 00 00 00 00 00 |...mypoo l.......|
>00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>00d0 00 06 72 75 6c 65 72 00-00 00 00 00 00 00 00 00 |..*****. ........|
>00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|
>01d0 00 05 04 02 00 00 44 42-2d 4c 69 62 72 61 72 79 |......DB -Library|
>01e0 0a 00 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69 |........ us_engli|
>01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |sh...... ........|
>
>net.c:650:Sending packet
>0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00 |...L.... ........|
>0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f |........ .....iso|
>0020 5f 31 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |_1...... ........|
>0030 00 00 00 00 00 00 00 00-00 00 00 05 01 35 31 32 |........ .....512|
>0040 00 00 00 03 00 00 00 00-00 00 00 00 |........ ....|
>
>token.c:317:tds_process_login_tokens()
>net.c:437:Received header
>0000 04 01 00 dc 00 00 00 00- |........|
>
>net.c:531:Received packet
>0000 e3 14 00 01 0b 4c 65 6f-63 61 74 65 54 65 73 74 |.....Leo cateTest|
>0010 06 6d 61 73 74 65 72 ab-3e 00 45 16 00 00 02 0a |.master. >.E.....|
>0020 2a 00 43 68 61 6e 67 65-64 20 64 61 74 61 62 61 |*.Change d databa|
>0030 73 65 20 63 6f 6e 74 65-78 74 20 74 6f 20 27 4c |se conte xt to 'L|
>0040 65 6f 63 61 74 65 54 65-73 74 27 2e 04 4a 44 42 |eocateTe st'..JDB|
>0050 43 05 5a 5a 5a 5a 5a 01-00 e3 0d 00 02 0a 75 73 |C.ZZZZZ. ......us|
>0060 5f 65 6e 67 6c 69 73 68-00 ab 3d 00 47 16 00 00 |_english ..=.G...|
>0070 01 0a 29 00 43 68 61 6e-67 65 64 20 6c 61 6e 67 |..).Chan ged lang|
>0080 75 61 67 65 20 73 65 74-74 69 6e 67 20 74 6f 20 |uage set ting to |
>0090 27 75 73 5f 65 6e 67 6c-69 73 68 27 2e 04 4a 44 |'us_engl ish'..JD|
>00a0 42 43 05 5a 5a 5a 5a 5a-01 00 e3 07 00 04 04 31 |BC.ZZZZZ .......1|
>00b0 30 32 34 00 ad 14 00 05-05 00 00 00 0a 73 71 6c |024..... .....sql|
>00c0 20 73 65 72 76 65 72 01-00 00 01 fd 00 00 02 00 | server. ........|
>00d0 01 00 00 00 - |....|
>
>token.c:321:looking for login token, got e3(ENVCHANGE)
>token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
>read.c:178:tds_get_string: reading 11 from wire to give 11 to client.
>read.c:178:tds_get_string: reading 6 from wire to give 6 to client.
>token.c:321:looking for login token, got ab(INFO)
>token.c:106:tds_process_default_tokens() marker is ab(INFO)
>token.c:2640:tds_process_msg() reading message from server
>read.c:178:tds_get_string: reading 42 from wire to give 42 to client.
>read.c:178:tds_get_string: reading 4 from wire to give 4 to client.
>read.c:178:tds_get_string: reading 5 from wire to give 5 to client.
>token.c:2702:tds_process_msg() calling client msg handler
>token.c:2715:tds_process_msg() returning TDS_SUCCEED
>token.c:321:looking for login token, got e3(ENVCHANGE)
>token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
>read.c:178:tds_get_string: reading 10 from wire to give 10 to client.
>token.c:321:looking for login token, got ab(INFO)
>token.c:106:tds_process_default_tokens() marker is ab(INFO)
>token.c:2640:tds_process_msg() reading message from server
>read.c:178:tds_get_string: reading 41 from wire to give 41 to client.
>read.c:178:tds_get_string: reading 4 from wire to give 4 to client.
>read.c:178:tds_get_string: reading 5 from wire to give 5 to client.
>token.c:2702:tds_process_msg() calling client msg handler
>token.c:2715:tds_process_msg() returning TDS_SUCCEED
>token.c:321:looking for login token, got e3(ENVCHANGE)
>token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
>read.c:178:tds_get_string: reading 4 from wire to give 4 to client.
>token.c:2528:increasing block size from to 1024
>token.c:321:looking for login token, got ad(LOGINACK)
>read.c:178:tds_get_string: reading 10 from wire to give 10 to client.
>token.c:321:looking for login token, got fd(DONE)
>token.c:106:tds_process_default_tokens() marker is fd(DONE)
>token.c:2344:tds_process_end: more_results = 0
> was_cancelled = 0
> error = 0
> done_count_valid = 0
>token.c:2360:tds_process_end() state set to TDS_IDLE
>util.c:125:Changing query state from TDS_IDLE to TDS_IDLE
>token.c:394:leaving tds_process_login_tokens() returning 1
>util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
>mem.c:453:tds_free_all_results()
>util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
>net.c:650:Sending packet
>0000 01 01 00 1b 00 00 00 00-73 65 74 20 74 65 78 74 |........ set text|
>0010 73 69 7a 65 20 36 34 35-31 32 20 |size 645 12 |
>
>util.c:125:Changing query state from TDS_PENDING to TDS_READING
>net.c:437:Received header
>0000 04 01 00 11 00 00 00 00- |........|
>
>net.c:531:Received packet
>0000 fd 00 00 be 00 00 00 00-00 |........ .|
>
>token.c:526:processing result tokens. marker is fd(DONE)
>token.c:2344:tds_process_end: more_results = 0
> was_cancelled = 0
> error = 0
> done_count_valid = 0
>token.c:2360:tds_process_end() state set to TDS_IDLE
>util.c:125:Changing query state from TDS_READING to TDS_IDLE
>util.c:125:Changing query state from TDS_IDLE to TDS_PENDING
>token.c:514:tds_process_result_tokens() state is COMPLETED
>dblib.c:1138:dbuse()
>dblib.c:1054:dbcmd() bufsz = 0
>dblib.c:1104:in dbsqlexec()
>dblib.c:5818:in dbsqlsend()
>util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
>mem.c:453:tds_free_all_results()
>util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
>net.c:650:Sending packet
>0000 01 01 00 13 00 00 00 00-75 73 65 20 4c 65 6f 63 |........ use Leoc|
>0010 61 74 65 - |ate|
>
>dblib.c:4005:in dbsqlok()
>net.c:437:Received header
>0000 04 01 00 63 00 00 00 00- |...c....|
>
>net.c:531:Received packet
>0000 e3 11 00 01 07 4c 65 6f-63 61 74 65 07 4c 65 6f |.....Leo cate.Leo|
>0010 63 61 74 65 ab 3b 00 45-16 00 00 01 00 26 00 43 |cate.;.E .....&.C|
>0020 68 61 6e 67 65 64 20 64-61 74 61 62 61 73 65 20 |hanged d atabase |
>0030 63 6f 6e 74 65 78 74 20-74 6f 20 27 4c 65 6f 63 |context to 'Leoc|
>0040 61 74 65 27 2e 09 53 51-4c 53 45 52 56 45 52 00 |ate'..SQ LSERVER.|
>0050 01 00 fd 00 00 e2 00 00-00 00 00 |........ ...|
>
>dblib.c:4024:dbsqlok() marker is e3
>util.c:125:Changing query state from TDS_PENDING to TDS_READING
>token.c:526:processing result tokens. marker is e3(ENVCHANGE)
>token.c:106:tds_process_default_tokens() marker is e3(ENVCHANGE)
>read.c:178:tds_get_string: reading 7 from wire to give 7 to client.
>read.c:178:tds_get_string: reading 7 from wire to give 7 to client.
>token.c:526:processing result tokens. marker is ab(INFO)
>token.c:106:tds_process_default_tokens() marker is ab(INFO)
>token.c:2640:tds_process_msg() reading message from server
>read.c:178:tds_get_string: reading 38 from wire to give 38 to client.
>read.c:178:tds_get_string: reading 9 from wire to give 9 to client.
>token.c:2702:tds_process_msg() calling client msg handler
>token.c:2715:tds_process_msg() returning TDS_SUCCEED
>token.c:526:processing result tokens. marker is fd(DONE)
>token.c:2344:tds_process_end: more_results = 0
> was_cancelled = 0
> error = 0
> done_count_valid = 0
>token.c:2360:tds_process_end() state set to TDS_IDLE
>util.c:125:Changing query state from TDS_READING to TDS_IDLE
>util.c:125:Changing query state from TDS_IDLE to TDS_PENDING
>dblib.c:4070:dbsqlok() end status was success
>dblib.c:1288:dbresults()
>token.c:897:tds_process_row_tokens() state is COMPLETED
>dblib.c:1054:dbcmd() bufsz = 12
>dblib.c:5007:in dbfreebuf()
>dblib.c:1104:in dbsqlexec()
>dblib.c:5818:in dbsqlsend()
>util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
>mem.c:453:tds_free_all_results()
>util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
>net.c:650:Sending packet
>0000 01 01 00 ed 00 00 00 00-49 4e 53 45 52 54 20 49 |........ INSERT I|
>0010 4e 54 4f 20 4a 6f 75 72-6e 65 79 20 28 4a 6f 75 |NTO Jour ney (Jou|
>0020 72 6e 65 79 53 74 61 72-74 54 69 6d 65 2c 53 74 |rneyStar tTime,St|
>0030 61 72 74 4c 61 74 69 74-75 64 65 2c 53 74 61 72 |artLatit ude,Star|
>0040 74 4c 6f 6e 67 69 74 75-64 65 2c 4f 64 6f 6d 65 |tLongitu de,Odome|
>0050 74 65 72 53 74 61 72 74-2c 56 65 68 69 63 6c 65 |terStart ,Vehicle|
>0060 49 44 29 20 56 41 4c 55-45 53 20 28 43 4f 4e 56 |ID) VALU ES (CONV|
>0070 45 52 54 28 44 61 74 65-54 69 6d 65 2c 27 32 34 |ERT(Date Time,'24|
>0080 20 41 75 67 75 73 74 20-32 30 30 35 20 31 37 3a | August 2005 17:|
>0090 30 34 3a 34 39 27 29 2c-43 4f 4e 56 45 52 54 28 |04:49'), CONVERT(|
>00a0 66 6c 6f 61 74 2c 27 35-33 2e 33 30 39 37 32 30 |float,'5 3.309720|
>00b0 27 29 2c 43 4f 4e 56 45-52 54 28 66 6c 6f 61 74 |'),CONVE RT(float|
>00c0 2c 27 2d 32 2e 37 30 33-34 33 39 27 29 2c 43 4f |,'-2.703 439'),CO|
>00d0 4e 56 45 52 54 28 69 6e-74 2c 27 31 31 36 32 35 |NVERT(in t,'11625|
>00e0 35 33 34 27 29 2c 27 31-31 31 30 27 29 |534'),'1 110')|
>
>dblib.c:4005:in dbsqlok()
>net.c:437:Received header
>0000 04 01 00 11 00 00 00 00- |........|
>
>net.c:531:Received packet
>0000 fd 10 00 c3 00 01 00 00-00 |........ .|
>
>dblib.c:4024:dbsqlok() marker is fd
>util.c:125:Changing query state from TDS_PENDING to TDS_READING
>token.c:526:processing result tokens. marker is fd(DONE)
>token.c:2344:tds_process_end: more_results = 0
> was_cancelled = 0
> error = 0
> done_count_valid = 1
>token.c:2360:tds_process_end() state set to TDS_IDLE
>util.c:125:Changing query state from TDS_READING to TDS_IDLE
>token.c:2376: rows_affected = 1
>util.c:125:Changing query state from TDS_IDLE to TDS_PENDING
>dblib.c:4070:dbsqlok() end status was success
>dblib.c:1288:dbresults()
>dblib.c:1054:dbcmd() bufsz = 230
>dblib.c:5007:in dbfreebuf()
>dblib.c:1104:in dbsqlexec()
>dblib.c:5818:in dbsqlsend()
>util.c:125:Changing query state from TDS_IDLE to TDS_QUERYING
>mem.c:453:tds_free_all_results()
>util.c:125:Changing query state from TDS_QUERYING to TDS_PENDING
>net.c:650:Sending packet
>0000 01 01 00 25 00 00 00 00-53 45 4c 45 43 54 20 40 |...%.... SELECT @|
>0010 40 49 44 45 4e 54 49 54-59 20 41 53 20 49 6e 73 |@IDENTIT Y AS Ins|
>0020 65 72 74 49 44 - |ertID|
>
>dblib.c:4005:in dbsqlok()
>net.c:437:Received header
>0000 04 01 00 30 00 00 00 00- |...0....|
>
>net.c:531:Received packet
>0000 a0 09 00 08 49 6e 73 65-72 74 49 44 a1 06 00 19 |....Inse rtID....|
>0010 00 01 00 6d 08 d1 08 00-00 00 00 00 80 43 40 fd |...m.... .....C@.|
>0020 10 00 c1 00 01 00 00 00- |........|
>
>dblib.c:4024:dbsqlok() marker is a0
>dblib.c:4030:dbsqlok() found result token
>dblib.c:1288:dbresults()
>mem.c:453:tds_free_all_results()
>util.c:125:Changing query state from TDS_PENDING to TDS_READING
>token.c:526:processing result tokens. marker is a0(COLNAME)
>read.c:178:tds_get_string: reading 8 from wire to give 8 to client.
>mem.c:453:tds_free_all_results()
>token.c:526:processing result tokens. marker is a1(COLFMT)
>token.c:1256:processing result. type = 109(float-null), varint_size 1
>util.c:125:Changing query state from TDS_READING to TDS_PENDING
>dblib.c:1326:dbresults() process_result_tokens returned result_type =
>4049 retcode = 1
>util.c:125:Changing query state from TDS_PENDING to TDS_READING
>token.c:526:processing result tokens. marker is d1(ROW)
>util.c:125:Changing query state from TDS_READING to TDS_PENDING
>dblib.c:1326:dbresults() process_result_tokens returned result_type =
>4040 retcode = 1
>dblib.c:2091:dbbind() column = 1 8 0
>dblib.c:2123:dbbind() srctype = 62 desttype = 56
>convert.c:2887:tds_willconvert()
>convert.c:2891:tds_willconvert() 62 56 1
>dblib.c:1545:dbnextrow()
>dblib.c:1560:dbnextrow() dbresults_state = 2
>util.c:125:Changing query state from TDS_PENDING to TDS_READING
>token.c:907:processing row tokens. marker is d1(ROW)
>token.c:2071:processing row. column is 0 varint size = 1
>token.c:2128:processing row. column size is 8
>util.c:125:Changing query state from TDS_READING to TDS_PENDING
>dblib.c:6244:copy_data_to_host_var(62 [SYBFLT8] len 8 => 56 [SYBINT4] len
0)
>dblib.c:6387:copy_data_to_host_var() called tds_convert returned 4
>
>HTH
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>



------------------------------

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


End of FreeTDS Digest, Vol 33, Issue 13
***************************************



  • [freetds] Need help with core dump trace, Philip, 10/13/2005

Archive powered by MHonArc 2.6.24.

Top of Page