freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

RE: [freetds] freebcp failing

From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Subject: RE: [freetds] freebcp failing
Date: Wed, 26 Jan 2005 10:24:29 -0000

Josh,

yep, a bug was reported.
I'm not sure if it's been applied to the latest RC yet.
do you want the fix ? I'll hunt it out for you if you do....

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Paparo, Joshua
Sent: 26 January 2005 10:20
To: freetds AT lists.ibiblio.org
Subject: [freetds] freebcp failing

Hi,

I've noticed that between 0.63 RC5 and RC8 that freebcp seems to start
failing.

If I run either an out or in command I get a message "Error in
dbnumcols".

I can't see any diffs in the bcp source itself.

Dump file is below.

Cheers,

Josh Paparo

10:08:38.652699 Starting log file for FreeTDS 0.63RC8

on 2005-01-26 10:08:38 with debug level 99.

10:08:38.653088 names for ISO-8859-1: ISO-8859-1

10:08:38.653104 names for UTF-8: UTF-8

10:08:38.653112 names for UCS-2LE: UCS-2LE

10:08:38.653118 names for UCS-2BE: UCS-2BE

10:08:38.653125 iconv to convert client-side data to the "ISO-8859-1"
character set

10:08:38.653161 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

10:08:38.653185 Connecting to 165.47.200.14 port 1433, TDS 4.2.

10:08:38.653521 Sending packet

0000 02 00 02 00 00 00 00 00-6c 6f 6e 6c 73 64 30 34 |........ lonlsd04|

0010 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0020 00 00 00 00 00 00 08 70-64 74 5f 64 62 6f 00 00 |.......p dt_dbo..|

0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0040 00 00 00 00 00 07 6c 6f-63 6b 65 64 6f 75 74 00 |......lo ckedout.|

0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

0060 00 00 00 00 09 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 46 72 65 65-42 43 50 00 00 00 00 00 |....Free BCP.....|

00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

00b0 00 00 07 45 4d 41 4c 4f-4e 4d 53 51 31 32 00 00 |...EMALO NMSQ12..|

00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00 |........ ........|

00d0 00 0b 6c 6f 63 6b 65 64-6f 75 74 00 00 00 00 00 |..locked out.....|

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 09 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...... ........|

10:08:38.653769 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 |........ ....|

10:08:38.653816 tds_process_login_tokens()

10:08:38.659798 Received header

0000 04 01 00 97 00 00 00 00- |........|

10:08:38.659833 Received packet

0000 e3 13 00 01 0a 50 44 54-5f 43 4f 4e 46 49 47 06 |.....PDT _CONFIG.|

0010 6d 61 73 74 65 72 ab 40-00 45 16 00 00 02 00 29 |master.@ .E.....)|

0020 00 43 68 61 6e 67 65 64-20 64 61 74 61 62 61 73 |.Changed databas|

0030 65 20 63 6f 6e 74 65 78-74 20 74 6f 20 27 50 44 |e contex t to 'PD|

0040 54 5f 43 4f 4e 46 49 47-27 2e 0b 45 4d 41 4c 4f |T_CONFIG '..EMALO|

0050 4e 4d 53 51 31 32 00 00-00 ad 1e 00 01 04 02 00 |NMSQ12.. ........|

0060 00 14 4d 69 63 72 6f 73-6f 66 74 20 53 51 4c 20 |..Micros oft SQL |

0070 53 65 72 76 65 72 5f 06-32 ff e3 09 00 04 03 35 |Server_. 2......5|

0080 31 32 03 35 31 32 fd 00-00 00 00 00 00 00 00 |12.512.. .......|

10:08:38.659944 looking for login token, got e3(ENVCHANGE)

10:08:38.659965 tds_process_default_tokens() marker is e3(ENVCHANGE)

10:08:38.659992 tds_get_string: reading 10 from wire to give 10 to
client.

10:08:38.660012 tds_get_string: reading 6 from wire to give 6 to client.

10:08:38.660028 looking for login token, got ab(INFO)

10:08:38.660040 tds_process_default_tokens() marker is ab(INFO)

10:08:38.660050 tds_get_string: reading 41 from wire to give 41 to
client.

10:08:38.660058 tds_get_string: reading 11 from wire to give 11 to
client.

10:08:38.660073 looking for login token, got ad(LOGINACK)

10:08:38.660082 tds_get_string: reading 20 from wire to give 20 to
client.

10:08:38.660093 looking for login token, got e3(ENVCHANGE)

10:08:38.660101 tds_process_default_tokens() marker is e3(ENVCHANGE)

10:08:38.660108 tds_get_string: reading 3 from wire to give 3 to client.

10:08:38.660114 tds_get_string: reading 3 from wire to give 3 to client.

10:08:38.660123 looking for login token, got fd(DONE)

10:08:38.660131 tds_process_default_tokens() marker is fd(DONE)

10:08:38.660138 tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

10:08:38.660145 tds_process_end() state set to TDS_IDLE

10:08:38.660152 leaving tds_process_login_tokens() returning 1

10:08:38.660170 tds_free_all_results()

10:08:38.660184 Sending packet

0000 01 01 00 1e 00 00 00 00-73 65 74 20 74 65 78 74 |........ set text|

0010 73 69 7a 65 20 31 30 30-30 30 30 30 30 20 |size 100 00000 |

10:08:38.662203 Received header

0000 04 01 00 11 00 00 00 00- |........|

10:08:38.662220 Received packet

0000 fd 00 00 be 00 00 00 00-00 |........ .|

10:08:38.662229 processing result tokens. marker is fd(DONE)

10:08:38.662238 tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

10:08:38.662246 tds_process_end() state set to TDS_IDLE

10:08:38.662252 tds_process_result_tokens() state is COMPLETED

10:08:38.662273 dbcmd() bufsz = 0

10:08:38.662285 in dbsqlexec()

10:08:38.662297 in dbsqlsend()

10:08:38.662304 tds_free_all_results()

10:08:38.662313 Sending packet

0000 01 01 00 19 00 00 00 00-73 65 74 20 74 65 78 74 |........ set text|

0010 73 69 7a 65 20 34 30 39-36 |size 409 6|

10:08:38.662340 in dbsqlok()

10:08:38.664560 Received header

0000 04 01 00 11 00 00 00 00- |........|

10:08:38.664576 Received packet

0000 fd 00 00 be 00 00 00 00-00 |........ .|

10:08:38.664585 dbsqlok() marker is fd

10:08:38.664594 processing result tokens. marker is fd(DONE)

10:08:38.664601 tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

10:08:38.664608 tds_process_end() state set to TDS_IDLE

10:08:38.664614 dbsqlok() end status was success

10:08:38.664622 dbresults()

10:08:38.664630 dbresults()

10:08:38.664636 tds_free_all_results()

10:08:38.664642 tds_process_result_tokens() state is COMPLETED

10:08:38.664648 dbresults() process_result_tokens returned result_type =
4052 retcode = 2

10:08:38.664658 dbcmd() bufsz = 18

10:08:38.664665 in dbfreebuf()

10:08:38.664672 in dbsqlexec()

10:08:38.664679 in dbsqlsend()

10:08:38.664685 tds_free_all_results()

10:08:38.664693 Sending packet

0000 01 01 00 4e 00 00 00 00-53 45 54 20 46 4d 54 4f |...N.... SET FMTO|

0010 4e 4c 59 20 4f 4e 20 73-65 6c 65 63 74 20 2a 20 |NLY ON s elect * |

0020 66 72 6f 6d 20 50 44 54-5f 43 4f 4e 46 49 47 2e |from PDT _CONFIG.|

0030 2e 68 79 64 72 61 5f 73-65 72 76 65 72 73 20 53 |.hydra_s ervers S|

0040 45 54 20 46 4d 54 4f 4e-4c 59 20 4f 46 46 |ET FMTON LY OFF|

10:08:38.664732 in dbsqlok()

10:08:38.667592 Received header

0000 04 01 00 c2 00 00 00 00- |........|

10:08:38.667610 Received packet

0000 fd 01 00 b9 00 00 00 00-00 a0 5b 00 02 69 64 04 |........ ..[..id.|

0010 74 79 70 65 04 6e 61 6d-65 0a 73 74 61 72 74 5f |type.nam e.start_|

0020 74 69 6d 65 08 65 6e 64-5f 74 69 6d 65 04 68 6f |time.end _time.ho|

0030 73 74 03 70 69 64 0e 70-72 6f 63 65 73 73 6f 72 |st.pid.p rocessor|

0040 5f 73 70 65 63 09 77 65-69 67 68 74 69 6e 67 0a |_spec.we ighting.|

0050 6c 61 75 6e 63 68 5f 63-6d 64 0c 75 73 65 5f 69 |launch_c md.use_i|

0060 6e 5f 62 61 74 63 68 a1-3e 00 07 00 00 00 38 02 |n_batch. >.....8.|

0070 00 00 00 27 1e 02 00 00-00 27 1e 07 00 00 00 38 |...'.... .'.....8|

0080 07 00 00 00 38 02 00 00-00 27 1e 07 00 00 00 26 |....8... .'.....&|

0090 04 07 00 00 00 26 04 08-00 00 00 6d 08 02 00 00 |.....&.. ...m....|

00a0 00 27 ff 10 00 00 00 32-fd 11 00 c1 00 00 00 00 |.'.....2 ........|

00b0 00 fd 00 00 ba 00 00 00-00 00 |........ ..|

10:08:38.667755 dbsqlok() marker is fd

10:08:38.667766 processing result tokens. marker is fd(DONE)

10:08:38.667774 tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 0

10:08:38.667781 dbsqlok() end status was success

10:08:38.667788 dbresults()

10:08:38.667795 dbresults()

10:08:38.667802 tds_free_all_results()

10:08:38.667809 processing result tokens. marker is a0(COLNAME)

10:08:38.667817 tds_get_string: reading 2 from wire to give 2 to client.

10:08:38.667826 tds_get_string: reading 4 from wire to give 4 to client.

10:08:38.667833 tds_get_string: reading 4 from wire to give 4 to client.

10:08:38.667840 tds_get_string: reading 10 from wire to give 10 to
client.

10:08:38.667847 tds_get_string: reading 8 from wire to give 8 to client.

10:08:38.667854 tds_get_string: reading 4 from wire to give 4 to client.

10:08:38.667861 tds_get_string: reading 3 from wire to give 3 to client.

10:08:38.667868 tds_get_string: reading 14 from wire to give 14 to
client.

10:08:38.667878 tds_get_string: reading 9 from wire to give 9 to client.

10:08:38.667887 tds_get_string: reading 10 from wire to give 10 to
client.

10:08:38.667894 tds_get_string: reading 12 from wire to give 12 to
client.

10:08:38.667901 tds_free_all_results()

10:08:38.667943 processing result tokens. marker is a1(COLFMT)

10:08:38.667958 processing result. type = 56(int), varint_size 0

10:08:38.667968 processing result. type = 39(varchar), varint_size 1

10:08:38.667975 processing result. type = 39(varchar), varint_size 1

10:08:38.667982 processing result. type = 56(int), varint_size 0

10:08:38.667989 processing result. type = 56(int), varint_size 0

10:08:38.667996 processing result. type = 39(varchar), varint_size 1

10:08:38.668002 processing result. type = 38(integer-null), varint_size
1

10:08:38.668009 processing result. type = 38(integer-null), varint_size
1

10:08:38.668016 processing result. type = 109(float-null), varint_size 1

10:08:38.668024 processing result. type = 39(varchar), varint_size 1

10:08:38.668032 processing result. type = 50(bit), varint_size 0

10:08:38.668040 dbresults() process_result_tokens returned result_type =
4049 retcode = 1

10:08:38.668054 processing result tokens. marker is fd(DONE)

10:08:38.668063 tds_process_end: more_results = 1

was_cancelled = 0

error = 0

done_count_valid = 1

10:08:38.668071 rows_affected = 0

10:08:38.668077 dbresults() process_result_tokens returned result_type =
4052 retcode = 1

10:08:38.668084 dbresults()

10:08:38.668090 tds_free_all_results()

10:08:38.668098 processing result tokens. marker is fd(DONE)

10:08:38.668106 tds_process_end: more_results = 0

was_cancelled = 0

error = 0

done_count_valid = 0

10:08:38.668113 tds_process_end() state set to TDS_IDLE

10:08:38.668119 dbresults() process_result_tokens returned result_type =
4052 retcode = 1

10:08:38.668127 dbresults()

10:08:38.668134 tds_free_all_results()

10:08:38.668140 tds_process_result_tokens() state is COMPLETED

10:08:38.668146 dbresults() process_result_tokens returned result_type =
4052 retcode = 2

Notice to recipient:
The information in this internet e-mail and any attachments is
confidential and may be privileged. It is intended solely for the
addressee. If you are not the intended addressee please notify the
sender immediately by telephone. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted to
be taken in reliance on it, is prohibited and may be unlawful.

When addressed to external clients any opinions or advice contained in
this internet e-mail are subject to the terms and conditions expressed
in any applicable governing terms of business or client engagement
letter issued by the pertinent Bank of America group entity.

If this email originates from the U.K. please note that Bank of America,
N.A., London Branch, Banc of America Securities Limited and Banc of
America Futures Incorporated are authorised and regulated by the
Financial Services Authority.

_______________________________________________
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] freebcp failing, Paparo, Joshua, 01/26/2005
- <Possible follow-up(s)>
- RE: [freetds] freebcp failing, Thompson, Bill D (London), 01/26/2005
- RE: [freetds] freebcp failing, Paparo, Joshua, 01/26/2005