FreeTDS Development Group

["Mark Bird" <mark.bird AT gmail.com>]

Hi James,

 

Thanks for looking into this. Looks like you're right about dbsetopt  being
called with 14 as the first argument, I've pasted the first part of the log
entry below. The call to dbsetopt is toward the bottom, I included a bit
more so you could see how it rolls along.

 

It looks like it's getting called after freetds has connected to the
database server but just before it changes to the requested database.

 

Thanks again, let me know if there's anything I can do. Here's the log:

 

 

log.c:190:Starting log file for FreeTDS 0.82

                on 2008-09-14 05:28:00 with debug flags 0x4fff.

iconv.c:197:names for ISO-8859-1: ISO-8859-1

iconv.c:197:names for UTF-8: UTF-8

iconv.c:197:names for UCS-2LE: UCS-2LE

iconv.c:197:names for UCS-2BE: UCS-2BE

iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character
set

iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

net.c:210:Connecting to 67.153.101.7 port 1433 (TDS version 8.0)

net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"

net.c:303:tds_open_socket() succeeded

util.c:162:Changed query state from DEAD to IDLE

login.c:735:quietly sending TDS 7+ login packet

token.c:312:tds_process_login_tokens()

net.c:592:Received header

0000 04 01 01 75 00 35 01 00-                        |...u.5..|

 

net.c:671:Received packet

0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|

0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 64 |..m.a.s. t.e.r..d|

0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|

0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|

0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|

0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |

0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|

0070 00 2e 00 07 48 00 45 00-4e 00 44 00 52 00 49 00 |....H.E. N.D.R.I.|

0080 58 00 00 00 00 e3 08 00-07 05 09 04 d0 00 34 00 |X....... ......4.|

0090 e3 17 00 02 0a 75 00 73-00 5f 00 65 00 6e 00 67 |.....u.s ._.e.n.g|

00a0 00 6c 00 69 00 73 00 68-00 00 ab 68 00 47 16 00 |.l.i.s.h ...h.G..|

00b0 00 01 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e|

00c0 00 64 00 20 00 6c 00 61-00 6e 00 67 00 75 00 61 |.d. .l.a .n.g.u.a|

00d0 00 67 00 65 00 20 00 73-00 65 00 74 00 74 00 69 |.g.e. .s .e.t.t.i|

00e0 00 6e 00 67 00 20 00 74-00 6f 00 20 00 75 00 73 |.n.g. .t .o. .u.s|

00f0 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|

0100 00 2e 00 07 48 00 45 00-4e 00 44 00 52 00 49 00 |....H.E. N.D.R.I.|

0110 58 00 00 00 00 ad 36 00-01 71 00 00 01 16 4d 00 |X.....6. .q....M.|

0120 69 00 63 00 72 00 6f 00-73 00 6f 00 66 00 74 00 |i.c.r.o. s.o.f.t.|

0130 20 00 53 00 51 00 4c 00-20 00 53 00 65 00 72 00 | .S.Q.L.  .S.e.r.|

0140 76 00 65 00 72 00 00 00-00 00 08 00 02 f8 e3 13 |v.e.r... ........|

0150 00 04 04 34 00 30 00 39-00 36 00 04 34 00 30 00 |...4.0.9 .6..4.0.|

0160 39 00 36 00 fd 00 00 00-00 00 00 00 00          |9.6..... .....|

 

token.c:316:looking for login token, got  e3(ENVCHANGE)

token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)

dblib.c:325:db_env_chg(0x55555a49fbb0, 1, master, master)

token.c:316:looking for login token, got  ab(INFO)

token.c:108:tds_process_default_tokens() marker is ab(INFO)

token.c:2451:tds_process_msg() reading message from server

token.c:2516:tds_process_msg() calling client msg handler

dbutil.c:86:_dblib_handle_info_message(0x55555a360760, 0x55555a49fbb0,
0x7fffec732ee0)

dbutil.c:87:msgno 5701: "Changed database context to 'master'."

token.c:2529:tds_process_msg() returning TDS_SUCCEED

token.c:316:looking for login token, got  e3(ENVCHANGE)

token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)

token.c:2281:tds_process_env_chg(): 5 bytes of collation data received

token.c:2282:tds->collation was

0000 00 00 00 00 00         -                        |.....|

 

iconv.c:985:setting server single-byte charset to "CP1252"

iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"

token.c:2292:tds->collation now

0000 09 04 d0 00 34         -                        |....4|

 

token.c:316:looking for login token, got  e3(ENVCHANGE)

token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)

dblib.c:325:db_env_chg(0x55555a49fbb0, 2, , us_english)

token.c:316:looking for login token, got  ab(INFO)

token.c:108:tds_process_default_tokens() marker is ab(INFO)

token.c:2451:tds_process_msg() reading message from server

token.c:2516:tds_process_msg() calling client msg handler

dbutil.c:86:_dblib_handle_info_message(0x55555a360760, 0x55555a49fbb0,
0x7fffec732ee0)

dbutil.c:87:msgno 5703: "Changed language setting to us_english."

token.c:2529:tds_process_msg() returning TDS_SUCCEED

token.c:316:looking for login token, got  ad(LOGINACK)

token.c:316:looking for login token, got  e3(ENVCHANGE)

token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)

dblib.c:325:db_env_chg(0x55555a49fbb0, 4, 4096, 4096)

token.c:316:looking for login token, got  fd(DONE)

token.c:108:tds_process_default_tokens() marker is fd(DONE)

token.c:2201:tds_process_end: more_results = 0

                                was_cancelled = 0

                                error = 0

                                done_count_valid = 0

token.c:2217:tds_process_end() state set to TDS_IDLE

token.c:2232:                rows_affected = 0

token.c:393:leaving tds_process_login_tokens() returning 1

dblib.c:237:dblib_add_connection(0x2aaab5b9b100, 0x55555a49fbb0)

dblib.c:4208:dbsetopt(0x55555a49f170, 14, 2, -1)

dblib.c:1327:dbuse(0x55555a49f170, pubs)

dblib.c:1243:dbcmd(0x55555a49f170, use pubs)

dblib.c:1250:dbcmd() bufsz = 0

dblib.c:1298:dbsqlexec(0x55555a49f170)

dblib.c:6722:dbsqlsend(0x55555a49f170)

mem.c:563:tds_free_all_results()

util.c:162:Changed query state from IDLE to QUERYING

write.c:136:tds_put_string converting 8 bytes of "use pubs"

write.c:164:tds_put_string wrote 16 bytes

util.c:162:Changed query state from QUERYING to PENDING

net.c:779:Sending packet

0000 01 01 00 18 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .|

0010 70 00 75 00 62 00 73 00-                        |p.u.b.s.|

 

dblib.c:4532:dbsqlok(0x55555a49f170)

net.c:592:Received header

0000 04 01 00 99 00 35 01 00-                        |.....5..|