FreeTDS Development Group

[Bruce Seely <bseely AT stsci.edu>]

Howdy,

Our Lisp vendor's ODBC interface stopped working with the FreeTDS 1.0 
release.

I am trying to isolate the problem, and have a test case to show how it 
fails.

The test function performs these operations:

- connect to R2D2 as bseely
- SQLExecDirect  "use pps_lrp_dev_14_11"
- SQLExecDirect  "select * from ppsdb_version"
- SQLNumResultCols
- SQLColAttribute for col #1, SQL_DESC_NAME
- SQLGetDiagRec


SQLExecDirect correctly accesses the database.

The call to SQLColAttribute is returning SQL_ERROR.

The call to SQLGetDiagRec reports that there is nothing to report.

I have attached a combined ODBC log & TDS_DUMP log.


The SQLColAttribute call that returns SQL_ERROR is on line 513

There is an error on line 532 that I don't understand:

error_export.h:83:SQLErrorW(0x0, 0x0, 0x7feee81007e0, 0x7ffee33c70a0, 
0x7ffee33c7bd0, 0x7feeea002e00, 512, 0x7ffee33c8000)

If I can provide anything else that would be useful, let me know.


Any help or ideas would be greatly appreciated.


Thanks,

Bruce


[015992.140304]
alisp           1164B25C0 ENTER SQLAllocHandle
                SQLSMALLINT       2 (SQL_HANDLE_DBC)
                SQLHANDLE         0x7feee5c00260
                SQLHANDLE       * 0x7ffee33c6480

[015992.140322]
alisp           1164B25C0 EXIT  SQLAllocHandle with return code 0 
(SQL_SUCCESS)
                SQLSMALLINT       2 (SQL_HANDLE_DBC)
                SQLHANDLE         0x7feee5c00260
                SQLHANDLE       * 0x7ffee33c6480 (0x7feee5f10bd0)

[015992.140348]
alisp           1164B25C0 ENTER SQLDriverConnect
                SQLHDBC           0x7feee5f10bd0
                SQLPOINTER        0x0
                SQLCHAR         * 0x7ffee33c6da0
                                  | DSN=R2D2;UID=bseely;PWD=************     |
                SQLSMALLINT       -3 (SQL_NTS)
                SQLCHAR         * 0x7ffee33c6570
                SQLSMALLINT       1024
                SQLSMALLINT     * 0x7ffee33c6d80
                SQLUSMALLINT      0 (SQL_DRIVER_NOPROMPT)
odbc.c:1531:SQLAllocHandle(2, 0x7feee5f04d00, 0x7feee5f10bf8)
odbc.c:1567:_SQLAllocConnect(0x7feee5f04d00, 0x7feee5f10bf8)
odbc_export.h:19:SQLDriverConnectW(0x7feee7016600, 0x0, 
DSN=R2D2;UID=bseely;PWD=vfr4xsw2zaq1, -3, 0x7feee700d800, 1024, 
0x7ffee33c6d80, 0)
config.c:598:   port = '1433'
config.c:598:   tds version = '7.2'
config.c:955:Setting tds version to 7.2 (0x702).
config.c:598:   text size = '2000000'
config.c:833:Setting 'dump_file' to 'stderr' from $TDSDUMP.
iconv.c:365:tds_iconv_open(0x7feee5c0c350, UTF-8)
iconv.c:387:setting up conversions for client charset "UTF-8"
iconv.c:389:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:428:tds_iconv_open: done
net.c:391:Connecting with protocol version 7.2
net.c:318:Connecting to 10.128.21.119 port 1433
net.c:340:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:528:tds_open_socket() succeeded
packet.c:852:Sending packet
0000 12 01 00 3a 00 00 00 00-00 00 1a 00 06 01 00 20 |...:.... ....... |
0010 00 01 02 00 21 00 0c 03-00 2d 00 04 04 00 31 00 |....!... .-....1.|
0020 01 ff 09 00 00 00 00 00-00 4d 53 53 51 4c 53 65 |.ÿ...... .MSSQLSe|
0030 72 76 65 72 00 50 45 01-00 00                   |rver.PE. ..|

packet.c:410:Received packet
0000 04 01 00 2b 00 00 01 00-00 00 1a 00 06 01 00 20 |...+.... ....... |
0010 00 01 02 00 21 00 01 03-00 22 00 00 04 00 22 00 |....!... ."....".|
0020 01 ff 0d 00 15 de 00 00-00 00 00                |.ÿ...Þ.. ...|

login.c:1281:detected crypt flag 0
tls.c:1013:setting default openssl cipher to:HIGH:!SSLv2:!aNULL:-DH
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:852:Sending packet
0000 12 01 01 4b 00 00 00 00-16 03 01 01 3e 01 00 01 |...K.... ....>...|
0010 3a 03 03 35 9f 7e 7c 5a-0c ca 0a cb 56 51 25 70 |:..5.~|Z .Ê.ËVQ%p|
0020 d1 d4 b8 5b 19 d7 45 75-bc 50 67 b6 a6 1b 40 92 |ÑÔ¸[.×Eu ¼Pg¶¦.@.|
0030 cf b2 37 20 01 b6 da 22-81 e0 cd 83 87 26 2d b9 |ϲ7 .¶Ú" .àÍ..&-¹|
0040 1c 8a 1c bb 3f 4a c4 84-ce bd 81 73 30 8a c3 1a |...»?JÄ. ν.s0.Ã.|
0050 d8 89 dd 1b 00 5c 13 02-13 03 13 01 c0 2c c0 30 |Ø.Ý..\.. ....À,À0|
0060 cc a9 cc a8 c0 af c0 ad-c0 5d c0 61 c0 2b c0 2f |̨̩À¯À­ À]ÀaÀ+À/|
0070 c0 ae c0 ac c0 5c c0 60-c0 24 c0 28 c0 73 c0 77 |À®À¬À\À` À$À(ÀsÀw|
0080 c0 23 c0 27 c0 72 c0 76-c0 0a c0 14 c0 09 c0 13 |À#À'ÀrÀv À.À.À.À.|
0090 00 9d c0 a1 c0 9d c0 51-00 9c c0 a0 c0 9c c0 50 |..À¡À.ÀQ ..À À.ÀP|
00a0 00 3d 00 c0 00 3c 00 ba-00 35 00 84 00 2f 00 41 |.=.À.<.º .5.../.A|
00b0 00 ff 01 00 00 95 00 0b-00 04 03 00 01 02 00 0a |.ÿ...... ........|
00c0 00 0c 00 0a 00 1d 00 17-00 1e 00 19 00 18 00 23 |........ .......#|
00d0 00 00 00 16 00 00 00 17-00 00 00 0d 00 30 00 2e |........ .....0..|
00e0 04 03 05 03 06 03 08 07-08 08 08 09 08 0a 08 0b |........ ........|
00f0 08 04 08 05 08 06 04 01-05 01 06 01 03 03 02 03 |........ ........|
0100 03 01 02 01 03 02 02 02-04 02 05 02 06 02 00 2b |........ .......+|
0110 00 09 08 03 04 03 03 03-02 03 01 00 2d 00 02 01 |........ ....-...|
0120 01 00 33 00 26 00 24 00-1d 00 20 d5 ba 54 3f de |..3.&.$. .. ÕºT?Þ|
0130 0b 6e 18 0c 57 dc b8 1f-53 80 ee 1a 16 dc 53 6e |.n..Wܸ. S.î..ÜSn|
0140 c4 16 fc ec 38 93 ce 8f-4e e1 59                |Ä.üì8.Î. NáY|

packet.c:410:Received packet
0000 12 01 04 a0 00 00 00 00-16 03 03 04 93 02 00 00 |... .... ........|
0010 51 03 03 5f 7d 11 6d c4-c0 d1 51 1d 30 f0 69 32 |Q.._}.mÄ ÀÑQ.0ði2|
0020 fe 77 35 81 e2 72 b6 fb-55 5e 14 6e 2e 42 b5 c8 |þw5.âr¶û U^.n.BµÈ|
0030 2d 23 51 20 d8 26 00 00-4e 31 61 9a 9b 21 89 c8 |-#Q Ø&.. N1a..!.È|
0040 90 e1 b8 92 27 b1 0b 1b-dc 5d a4 c7 eb 42 41 2f |.á¸.'±.. Ü]¤ÇëBA/|
0050 93 92 eb ab c0 30 00 00-09 00 17 00 00 ff 01 00 |..ë«À0.. .....ÿ..|
0060 01 00 0b 00 03 0a 00 03-07 00 03 04 30 82 03 00 |........ ....0...|
0070 30 82 01 e8 a0 03 02 01-02 02 10 1f 5b d8 0b 9f |0..è ... ....[Ø..|
0080 3f 22 86 46 d9 8a 79 37-c3 4c ac 30 0d 06 09 2a |?".FÙ.y7 ÃL¬0...*|
0090 86 48 86 f7 0d 01 01 05-05 00 30 3b 31 39 30 37 |.H.÷.... ..0;1907|
00a0 06 03 55 04 03 1e 30 00-53 00 53 00 4c 00 5f 00 |..U...0. S.S.L._.|
00b0 53 00 65 00 6c 00 66 00-5f 00 53 00 69 00 67 00 |S.e.l.f. _.S.i.g.|
00c0 6e 00 65 00 64 00 5f 00-46 00 61 00 6c 00 6c 00 |n.e.d._. F.a.l.l.|
00d0 62 00 61 00 63 00 6b 30-20 17 0d 32 30 30 39 31 |b.a.c.k0  ..20091|
00e0 35 31 30 31 31 34 32 5a-18 0f 32 30 35 30 30 39 |5101142Z ..205009|
00f0 31 35 31 30 31 31 34 32-5a 30 3b 31 39 30 37 06 |15101142 Z0;1907.|
0100 03 55 04 03 1e 30 00 53-00 53 00 4c 00 5f 00 53 |.U...0.S .S.L._.S|
0110 00 65 00 6c 00 66 00 5f-00 53 00 69 00 67 00 6e |.e.l.f._ .S.i.g.n|
0120 00 65 00 64 00 5f 00 46-00 61 00 6c 00 6c 00 62 |.e.d._.F .a.l.l.b|
0130 00 61 00 63 00 6b 30 82-01 22 30 0d 06 09 2a 86 |.a.c.k0. ."0...*.|
0140 48 86 f7 0d 01 01 01 05-00 03 82 01 0f 00 30 82 |H.÷..... ......0.|
0150 01 0a 02 82 01 01 00 f3-dd f8 7f 6e 36 44 5d 44 |.......ó Ýø.n6D]D|
0160 05 43 43 ba 2b ec 04 a6-9b 23 4d f6 43 72 34 e2 |.CCº+ì.¦ .#MöCr4â|
0170 ec 01 7e 03 d3 21 39 8e-a4 cf 40 6a 72 c5 52 09 |ì.~.Ó!9. ¤Ï@jrÅR.|
0180 4d e9 9b 07 a0 bf 2f 63-41 62 88 90 a5 a6 49 8d |Mé.. ¿/c Ab..¥¦I.|
0190 fa 72 80 04 fd 8b 65 c9-e6 74 8c 85 49 44 94 24 |úr..ý.eÉ æt..ID.$|
01a0 3c 00 0c 6b be 38 5c a7-4c 4b 5c df 92 24 f6 75 |<..k¾8\§ LK\ß.$öu|
01b0 43 eb 59 91 78 05 53 14-6f 84 16 a1 8a 40 f7 1d |CëY.x.S. o..¡.@÷.|
01c0 b6 32 4c 4a ce ac 2d ee-9e 12 7f 6b 7f c2 df b7 |¶2LJά-î ...k.Âß·|
01d0 0a ad a0 f5 2c 73 c4 60-b9 9d dd f8 d9 4f 85 99 |.­ õ,sÄ` ¹.ÝøÙO..|
01e0 fc 0d 37 32 8f 4d fb 5a-f9 e9 54 de 37 ae e9 5c |ü.72.MûZ ùéTÞ7®é\|
01f0 09 7a ea 8e 29 22 cd 91-1e 99 fb 8b e3 d8 6f 62 |.zê.)"Í. ..û.ãØob|
0200 e0 d1 66 03 ea b8 25 a1-b3 61 7a dd 49 9f 22 b6 |àÑf.ê¸%¡ ³azÝI."¶|
0210 59 f9 c3 39 b9 f8 f7 ed-8c 31 11 71 ef 7c 8f b6 |YùÃ9¹ø÷í .1.qï|.¶|
0220 3a 98 88 1a cb 05 47 90-fe 57 00 24 79 64 d4 84 |:...Ë.G. þW.$ydÔ.|
0230 04 05 42 c7 b0 c0 86 f1-d4 32 75 f9 8d e4 df 66 |..BÇ°À.ñ Ô2uù.äßf|
0240 11 65 4b d6 fa 00 e2 dc-2e f5 42 93 95 80 6d 5a |.eKÖú.âÜ .õB...mZ|
0250 86 d1 76 83 ab 75 2f 02-03 01 00 01 30 0d 06 09 |.Ñv.«u/. ....0...|
0260 2a 86 48 86 f7 0d 01 01-05 05 00 03 82 01 01 00 |*.H.÷... ........|
0270 50 b7 6d 7f f8 02 dd e2-ec 7b 14 3f a5 af 2a 0f |P·m.ø.Ýâ ì{.?¥¯*.|
0280 83 b6 e6 14 cb 3e b7 9a-84 4a 64 2b f2 d5 c7 93 |.¶æ.Ë>·. .Jd+òÕÇ.|
0290 10 4a ba 79 3d ce e2 2a-ef bf 88 e3 69 93 d2 3b |.Jºy=Îâ* ï¿.ãi.Ò;|
02a0 69 8d 44 b8 9f c0 c1 cf-d8 29 fc d7 b8 1c 52 47 |i.D¸.ÀÁÏ Ø)ü׸.RG|
02b0 85 51 cd 20 97 ab c3 07-c6 a4 ff c9 7b 5f ad 0f |.QÍ .«Ã. ƤÿÉ{_­.|
02c0 2c 59 dc bc 08 42 39 4f-a7 94 38 c0 74 50 ca 5c |,Yܼ.B9O §.8ÀtPÊ\|
02d0 8d 89 2f e4 bb e7 6e 1b-35 63 ad 6e b2 01 32 a6 |../ä»çn. 5c­n².2¦|
02e0 be bf b6 7f f0 7c dc d0-15 fb be 54 d8 f9 6b 81 |¾¿¶.ð|ÜÐ .û¾TØùk.|
02f0 44 23 e5 89 2a 56 32 8f-56 77 8c d9 23 06 81 70 |D#å.*V2. Vw.Ù#..p|
0300 6d 42 a2 af 41 8f 24 80-30 3f 50 ae 57 13 06 97 |mB¢¯A.$. 0?P®W...|
0310 6b 12 0e 4d 23 b6 b1 ae-00 f2 83 cd ee ea f9 ff |k..M#¶±® .ò.Íîêùÿ|
0320 f2 60 db 22 68 f4 98 1b-39 57 bd d3 50 81 78 5f |ò`Û"hô.. 9W½ÓP.x_|
0330 e9 7c 63 fe 32 ca 1a 42-91 d5 f3 e1 93 6c a3 73 |é|cþ2Ê.B .Õóá.l£s|
0340 47 ce 89 ab e6 1f 5d b8-f0 7e ba 24 ba 80 bb 00 |GÎ.«æ.]¸ ð~º$º.».|
0350 c8 03 b6 33 f6 94 08 33-45 4a 9b d3 92 30 01 67 |È.¶3ö..3 EJ.Ó.0.g|
0360 3c 04 a6 9c 15 0b a0 37-54 28 44 91 d4 fa 7f c1 |<.¦... 7 T(D.Ôú.Á|
0370 0c 00 01 28 03 00 1d 20-b3 d2 f5 6c 81 ce 13 e3 |...(...  ³Òõl.Î.ã|
0380 0a 9e 3e bd ab 2d c2 a7-b8 eb 92 4e ad 84 3f ea |..>½«-§ ¸ë.N­.?ê|
0390 f8 b2 38 5b 59 cb cc 1d-04 01 01 00 39 cb 39 0a |ø²8[YËÌ. ....9Ë9.|
03a0 cd ef 6e cf a6 99 60 5c-a3 03 e6 5c 33 79 e1 2d |ÍïnϦ.`\ £.æ\3yá-|
03b0 26 88 a6 87 c7 25 ed 04-c3 9a 5a 34 ed 65 65 e3 |&.¦.Ç%í. Ã.Z4íeeã|
03c0 56 44 ea 10 92 81 36 83-38 20 be e8 21 f8 8c ef |VDê...6. 8 ¾è!ø.ï|
03d0 b7 ef 97 9c b7 0a db c9-8e 9f 94 71 0e 11 4f 90 |·ï..·.ÛÉ ...q..O.|
03e0 29 2f c8 f6 16 09 d3 52-3a 63 48 c2 28 aa 12 4a |)/Èö..ÓR :cHÂ(ª.J|
03f0 fb 6e f3 4e 9e 42 f1 89-f4 fd c2 b6 f4 7d db 62 |ûnóN.Bñ. ôý¶ô}Ûb|
0400 4b 56 84 0b e3 6f c3 0b-31 5a 42 c4 b2 3d 18 bb |KV..ãoÃ. 1ZBIJ=.»|
0410 72 7c 51 86 a4 18 7f ad-0a a1 f6 d8 fa 42 df 4c |r|Q.¤..­ .¡öØúBßL|
0420 d9 2d 91 a0 cc bd a3 60-3b b9 63 81 4c 01 90 9b |Ù-. ̽£` ;¹c.L...|
0430 4b 05 ab d1 d1 53 c5 d5-12 7d 21 a6 d7 19 16 dd |K.«ÑÑSÅÕ .}!¦×..Ý|
0440 05 db 14 8a 91 45 56 18-19 ef 81 9f d5 97 6c 52 |.Û...EV. .ï..Õ.lR|
0450 dd 50 80 79 90 3a 8c 43-a1 77 08 d7 98 fe 39 94 |ÝP.y.:.C ¡w.×.þ9.|
0460 be 1a 19 07 ba 06 d5 9a-08 28 cc 6f cd 47 31 a5 |¾...º.Õ. .(ÌoÍG1¥|
0470 75 93 4e 33 7c d7 e7 53-6d b1 1f 73 d2 d3 bc cc |u.N3|×çS m±.sÒÓ¼Ì|
0480 f5 c0 f0 2e 6b 49 d5 64-77 12 4b ac 67 53 53 ae |õÀð.kIÕd w.K¬gSS®|
0490 71 a8 59 d4 f8 1a ee 17-13 34 bf 22 0e 00 00 00 |q¨YÔø.î. .4¿"....|

tls.c:117:in tds_pull_func_login
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:852:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 03 00 25 10 00 00 |...e.... ....%...|
0010 21 20 bf ac 1b 60 90 65-22 98 67 78 46 f3 df a9 |! ¿¬.`.e ".gxFóß©|
0020 21 e2 81 21 22 04 c9 c2-bb 37 cc 0b e5 fe a1 d7 |!â.!".ÉÂ »7Ì.åþ¡×|
0030 66 7f 14 03 03 00 01 01-16 03 03 00 28 bc 4e 0f |f....... ....(¼N.|
0040 64 30 a2 83 1c d8 1a 96-38 80 5a a6 ba 18 02 32 |d0¢..Ø.. 8.Z¦º..2|
0050 b1 44 5e 5f 92 70 de 70-d7 df 97 cd 26 f8 f8 c6 |±D^_.pÞp ×ß.Í&øøÆ|
0060 cd 8a 0f b7 f5         -                        |Í..·õ|

packet.c:410:Received packet
0000 12 01 00 3b 00 00 00 00-14 03 03 00 01 01 16 03 |...;.... ........|
0010 03 00 28 00 00 00 00 00-00 00 00 52 e7 87 bb ce |..(..... ...Rç.»Î|
0020 07 df f1 8f 1b 4c 89 b0-f4 a4 85 5c 8b c6 01 80 |.ßñ..L.° ô¤.\.Æ..|
0030 f6 da 2b 6f 43 dd 95 67-31 d4 e8                |öÚ+oCÝ.g 1Ôè|

tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:1049:handshake succeeded!!
login.c:1005:quietly sending TDS 7+ login packet
token.c:417:tds_process_login_tokens()
packet.c:410:Received packet
0000 04 01 01 95 00 72 01 00-e3 1b 00 01 06 6d 00 61 |.....r.. ã....m.a|
0010 00 73 00 74 00 65 00 72-00 06 6d 00 61 00 73 00 |.s.t.e.r ..m.a.s.|
0020 74 00 65 00 72 00 ab 72-00 45 16 00 00 02 00 25 |t.e.r.«r .E.....%|
0030 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
0040 00 64 00 61 00 74 00 61-00 62 00 61 00 73 00 65 |.d.a.t.a .b.a.s.e|
0050 00 20 00 63 00 6f 00 6e-00 74 00 65 00 78 00 74 |. .c.o.n .t.e.x.t|
0060 00 20 00 74 00 6f 00 20-00 27 00 6d 00 61 00 73 |. .t.o.  .'.m.a.s|
0070 00 74 00 65 00 72 00 27-00 2e 00 0d 44 00 57 00 |.t.e.r.' ....D.W.|
0080 50 00 50 00 53 00 52 00-32 00 44 00 32 00 44 00 |P.P.S.R. 2.D.2.D.|
0090 42 00 56 00 31 00 00 01-00 00 00 e3 08 00 07 05 |B.V.1... ...ã....|
00a0 09 04 d0 00 34 00 e3 17-00 02 0a 75 00 73 00 5f |..Ð.4.ã. ...u.s._|
00b0 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 00 |.e.n.g.l .i.s.h..|
00c0 ab 76 00 47 16 00 00 01-00 27 00 43 00 68 00 61 |«v.G.... .'.C.h.a|
00d0 00 6e 00 67 00 65 00 64-00 20 00 6c 00 61 00 6e |.n.g.e.d . .l.a.n|
00e0 00 67 00 75 00 61 00 67-00 65 00 20 00 73 00 65 |.g.u.a.g .e. .s.e|
00f0 00 74 00 74 00 69 00 6e-00 67 00 20 00 74 00 6f |.t.t.i.n .g. .t.o|
0100 00 20 00 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |. .u.s._ .e.n.g.l|
0110 00 69 00 73 00 68 00 2e-00 0d 44 00 57 00 50 00 |.i.s.h.. ..D.W.P.|
0120 50 00 53 00 52 00 32 00-44 00 32 00 44 00 42 00 |P.S.R.2. D.2.D.B.|
0130 56 00 31 00 00 01 00 00-00 ad 36 00 01 72 09 00 |V.1..... .­6..r..|
0140 02 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.|
0150 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.|
0160 65 00 72 00 76 00 65 00-72 00 00 00 00 00 0d 00 |e.r.v.e. r.......|
0170 15 de e3 13 00 04 04 34-00 30 00 39 00 36 00 04 |.Þã....4 .0.9.6..|
0180 34 00 30 00 39 00 36 00-fd 00 00 00 00 00 00 00 |4.0.9.6. ý.......|
0190 00 00 00 00 00         -                        |.....|

token.c:421:looking for login token, got  e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:421:looking for login token, got  ab(INFO)
token.c:130:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5701 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2369:msgno 5701 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:421:looking for login token, got  e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2226:tds_process_env_chg(): 5 bytes of collation data received
token.c:2227:tds->conn->collation was
0000 00 00 00 00 00         -                        |.....|

iconv.c:825:setting server single-byte charset to "CP1252"
token.c:2236:tds->conn->collation now
0000 09 04 d0 00 34         -                        |..Ð.4|

token.c:421:looking for login token, got  e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:421:looking for login token, got  ab(INFO)
token.c:130:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5703 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2369:msgno 5703 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:421:looking for login token, got  ad(LOGINACK)
token.c:347:server reports TDS version 72.9.0.2
token.c:349:Product name for 0x72090002 is 2005
token.c:383:Product version 8D0015DE
token.c:421:looking for login token, got  e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2285:changing block size from 4096 to 4096
token.c:421:looking for login token, got  fd(DONE)
token.c:130:tds_process_default_tokens() marker is fd(DONE)
token.c:2096:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2115:                rows_affected = 0
token.c:2118:tds_process_end() state set to TDS_IDLE
token.c:444:tds_process_login_tokens() returning TDS_SUCCESS
mem.c:656:tds_free_all_results()
util.c:179:Changed query state from IDLE to WRITING
packet.c:852:Sending packet
0000 01 01 00 48 00 00 00 00-16 00 00 00 12 00 00 00 |...H.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 73 00 |........ ......s.|
0020 65 00 74 00 20 00 74 00-65 00 78 00 74 00 73 00 |e.t. .t. e.x.t.s.|
0030 69 00 7a 00 65 00 20 00-32 00 30 00 30 00 30 00 |i.z.e. . 2.0.0.0.|
0040 30 00 30 00 30 00 20 00-                        |0.0.0. .|

util.c:179:Changed query state from WRITING to PENDING
token.c:554:tds_process_tokens(0x7feee5c0c710, 0x7ffee33beac0, 
0x7ffee33beac4, 0x100)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 15 00 72 01 00-fd 00 00 be 00 00 00 00 |.....r.. ý..¾....|
0010 00 00 00 00 00         -                        |.....|

token.c:569:processing result tokens.  marker is  fd(DONE)
token.c:2096:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2115:                rows_affected = 0
token.c:2118:tds_process_end() state set to TDS_IDLE
util.c:179:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:179:Changed query state from IDLE to IDLE
token.c:554:tds_process_tokens(0x7feee5c0c710, 0x7ffee33beac0, 
0x7ffee33beac4, 0x100)
token.c:557:tds_process_tokens() state is COMPLETED
odbc.c:5937:SQLGetInfoW(0x7feee7016600, 23, 0x7feee5f10ca8, 2, 0x0)
odbc.c:5169:_SQLGetInfo(0x7feee7016600, 23, 0x7feee5f10ca8, 2, 0x0)
odbc.c:5937:SQLGetInfoW(0x7feee7016600, 24, 0x7feee5f10caa, 2, 0x0)
odbc.c:5169:_SQLGetInfo(0x7feee7016600, 24, 0x7feee5f10caa, 2, 0x0)

[015992.240910]
alisp           1164B25C0 EXIT  SQLDriverConnect with return code 0 
(SQL_SUCCESS)
                SQLHDBC           0x7feee5f10bd0
                SQLPOINTER        0x0
                SQLCHAR         * 0x7ffee33c6da0
                SQLSMALLINT       -3 (SQL_NTS)
                SQLCHAR         * 0x7ffee33c6570
                                  | DSN=R2D2;UID=bseely;PWD=************     |
                SQLSMALLINT       1024
                SQLSMALLINT     * 0x7ffee33c6d80 (36)
                SQLUSMALLINT      0 (SQL_DRIVER_NOPROMPT)

[015992.240996]
alisp           1164B25C0 ENTER SQLAllocHandle
                SQLSMALLINT       3 (SQL_HANDLE_STMT)
                SQLHANDLE         0x7feee5f10bd0
                SQLHANDLE       * 0x7ffee33c6470
odbc.c:1812:SQLAllocStmt(0x7feee7016600, 0x7feee81006a8)
odbc.c:1706:_SQLAllocStmt(0x7feee7016600, 0x7feee81006a8)
odbc.c:4508:SQLGetStmtAttr(0x7feee81007e0, 10010, 0x7feee8100c38, 0, 0x0)
odbc.c:4508:SQLGetStmtAttr(0x7feee81007e0, 10011, 0x7feee8100c78, 0, 0x0)
odbc.c:4508:SQLGetStmtAttr(0x7feee81007e0, 10012, 0x7feee8100cb8, 0, 0x0)
odbc.c:4508:SQLGetStmtAttr(0x7feee81007e0, 10013, 0x7feee8100cf8, 0, 0x0)

[015992.241025]
alisp           1164B25C0 EXIT  SQLAllocHandle with return code 0 
(SQL_SUCCESS)
                SQLSMALLINT       3 (SQL_HANDLE_STMT)
                SQLHANDLE         0x7feee5f10bd0
                SQLHANDLE       * 0x7ffee33c6470 (0x7feee8100680)

[015992.241053]
alisp           1164B25C0 ENTER SQLExecDirect
                SQLHSTMT          0x7feee8100680
                SQLCHAR         * 0x7ffee33c7ba0
                                  | use pps_lrp_dev_14_11                    |
                SQLINTEGER        -3 (SQL_NTS)
odbc_export.h:801:SQLExecDirectW(0x7feee81007e0, use pps_lrp_dev_14_11, -3)
prepare_query.c:208:parsing 0 parameters
odbc.c:3275:_SQLExecute(0x7feee81007e0)
odbc.c:3292:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:179:Changed query state from IDLE to WRITING
packet.c:852:Sending packet
0000 01 01 00 48 00 00 01 00-16 00 00 00 12 00 00 00 |...H.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 75 00 |........ ......u.|
0020 73 00 65 00 20 00 70 00-70 00 73 00 5f 00 6c 00 |s.e. .p. p.s._.l.|
0030 72 00 70 00 5f 00 64 00-65 00 76 00 5f 00 31 00 |r.p._.d. e.v._.1.|
0040 34 00 5f 00 31 00 31 00-                        |4._.1.1.|

util.c:179:Changed query state from WRITING to PENDING
token.c:554:tds_process_tokens(0x7feee5c0c710, 0x7ffee33c7464, 
0x7ffee33c7460, 0x6914)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 df 00 72 01 00-e3 31 00 01 11 70 00 70 |...ß.r.. ã1...p.p|
0010 00 73 00 5f 00 6c 00 72-00 70 00 5f 00 64 00 65 |.s._.l.r .p._.d.e|
0020 00 76 00 5f 00 31 00 34-00 5f 00 31 00 31 00 06 |.v._.1.4 ._.1.1..|
0030 6d 00 61 00 73 00 74 00-65 00 72 00 ab 88 00 45 |m.a.s.t. e.r.«..E|
0040 16 00 00 01 00 30 00 43-00 68 00 61 00 6e 00 67 |.....0.C .h.a.n.g|
0050 00 65 00 64 00 20 00 64-00 61 00 74 00 61 00 62 |.e.d. .d .a.t.a.b|
0060 00 61 00 73 00 65 00 20-00 63 00 6f 00 6e 00 74 |.a.s.e.  .c.o.n.t|
0070 00 65 00 78 00 74 00 20-00 74 00 6f 00 20 00 27 |.e.x.t.  .t.o. .'|
0080 00 70 00 70 00 73 00 5f-00 6c 00 72 00 70 00 5f |.p.p.s._ .l.r.p._|
0090 00 64 00 65 00 76 00 5f-00 31 00 34 00 5f 00 31 |.d.e.v._ .1.4._.1|
00a0 00 31 00 27 00 2e 00 0d-44 00 57 00 50 00 50 00 |.1.'.... D.W.P.P.|
00b0 53 00 52 00 32 00 44 00-32 00 44 00 42 00 56 00 |S.R.2.D. 2.D.B.V.|
00c0 31 00 00 01 00 00 00 e3-08 00 07 05 09 04 c0 00 |1......ã ......À.|
00d0 33 00 fd 00 00 e2 00 00-00 00 00 00 00 00 00    |3.ý..â.. .......|

token.c:569:processing result tokens.  marker is  e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:569:processing result tokens.  marker is  ab(INFO)
token.c:130:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5701 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2369:msgno 5701 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:569:processing result tokens.  marker is  e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2226:tds_process_env_chg(): 5 bytes of collation data received
token.c:2227:tds->conn->collation was
0000 09 04 d0 00 34         -                        |..Ð.4|

iconv.c:825:setting server single-byte charset to "CP1252"
token.c:2236:tds->conn->collation now
0000 09 04 c0 00 33         -                        |..À.3|

token.c:569:processing result tokens.  marker is  fd(DONE)
token.c:2096:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2115:                rows_affected = 0
token.c:2118:tds_process_end() state set to TDS_IDLE
util.c:179:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:179:Changed query state from IDLE to IDLE
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3617:    result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3662:odbc_process_tokens: processed TDS_DONE_RESULT
token.c:554:tds_process_tokens(0x7feee5c0c710, 0x7ffee33c7464, 
0x7ffee33c7460, 0x6914)
token.c:557:tds_process_tokens() state is COMPLETED
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3617:    result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3438:_SQLExecute: odbc_process_tokens returned result_type 4046

[015992.253211]
alisp           1164B25C0 EXIT  SQLExecDirect with return code 1 
(SQL_SUCCESS_WITH_INFO)
                SQLHSTMT          0x7feee8100680
                SQLCHAR         * 0x7ffee33c7ba0
                SQLINTEGER        -3 (SQL_NTS)

[015992.253330]
alisp           1164B25C0 ENTER SQLExecDirect
                SQLHSTMT          0x7feee8100680
                SQLCHAR         * 0x7ffee33c7ba0
                                  | select * from ppsdb_version              |
                SQLINTEGER        -3 (SQL_NTS)
odbc_export.h:801:SQLExecDirectW(0x7feee81007e0, select * from ppsdb_version, 
-3)
prepare_query.c:208:parsing 0 parameters
odbc.c:3275:_SQLExecute(0x7feee81007e0)
odbc.c:3292:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:179:Changed query state from IDLE to WRITING
packet.c:852:Sending packet
0000 01 01 00 54 00 00 01 00-16 00 00 00 12 00 00 00 |...T.... ........|
0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 73 00 |........ ......s.|
0020 65 00 6c 00 65 00 63 00-74 00 20 00 2a 00 20 00 |e.l.e.c. t. .*. .|
0030 66 00 72 00 6f 00 6d 00-20 00 70 00 70 00 73 00 |f.r.o.m.  .p.p.s.|
0040 64 00 62 00 5f 00 76 00-65 00 72 00 73 00 69 00 |d.b._.v. e.r.s.i.|
0050 6f 00 6e 00            -                        |o.n.|

util.c:179:Changed query state from WRITING to PENDING
token.c:554:tds_process_tokens(0x7feee5c0c710, 0x7ffee33c7464, 
0x7ffee33c7460, 0x6914)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 d0 00 72 01 00-81 04 00 00 00 00 00 08 |...Ð.r.. ........|
0010 00 30 02 69 00 64 00 00-00 00 00 0a 00 a7 0a 00 |.0.i.d.. .....§..|
0020 09 04 c0 00 33 0d 70 00-70 00 73 00 64 00 62 00 |..À.3.p. p.s.d.b.|
0030 5f 00 76 00 65 00 72 00-73 00 69 00 6f 00 6e 00 |_.v.e.r. s.i.o.n.|
0040 00 00 00 00 08 00 e7 34-00 09 04 c0 00 33 0a 62 |......ç4 ...À.3.b|
0050 00 75 00 69 00 6c 00 64-00 5f 00 74 00 69 00 6d |.u.i.l.d ._.t.i.m|
0060 00 65 00 00 00 00 00 0a-00 a7 40 1f 09 04 c0 00 |.e...... .§@...À.|
0070 33 07 63 00 6f 00 6d 00-6d 00 65 00 6e 00 74 00 |3.c.o.m. m.e.n.t.|
0080 d1 01 07 00 50 50 53 44-42 38 36 34 00 32 00 30 |Ñ...PPSD B864.2.0|
0090 00 32 00 30 00 2d 00 30-00 31 00 2d 00 32 00 39 |.2.0.-.0 .1.-.2.9|
00a0 00 20 00 31 00 36 00 3a-00 33 00 35 00 3a 00 33 |. .1.6.: .3.5.:.3|
00b0 00 39 00 20 00 2d 00 30-00 35 00 3a 00 30 00 30 |.9. .-.0 .5.:.0.0|
00c0 00 00 00 fd 10 00 c1 00-01 00 00 00 00 00 00 00 |...ý..Á. ........|

token.c:569:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1574:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1599:set current_results (4 columns) to tds->res_info
token.c:1606:setting up 4 columns
token.c:1543:tds7_get_data_info:
        colname = id
        type = 48 (tinyint)
        server's type = 48 (tinyint)
        column_varint_size = 0
        column_size = 1 (1 on server)
token.c:1543:tds7_get_data_info:
        colname = ppsdb_version
        type = 39 (varchar)
        server's type = 167 (xvarchar)
        column_varint_size = 2
        column_size = 10 (10 on server)
token.c:1543:tds7_get_data_info:
        colname = build_time
        type = 39 (varchar)
        server's type = 231 (x UCS-2 varchar)
        column_varint_size = 2
        column_size = 52 (52 on server)
token.c:1543:tds7_get_data_info:
        colname = comment
        type = 39 (varchar)
        server's type = 167 (xvarchar)
        column_varint_size = 2
        column_size = 8000 (8000 on server)
token.c:1615: name                 size/wsize      type/wtype      utype
token.c:1616: -------------------- --------------- --------------- -------
token.c:1621: id                         1/1            48/48            0
token.c:1621: ppsdb_version             10/10           39/167           0
token.c:1621: build_time                52/52           39/231           0
token.c:1621: comment                 8000/8000         39/167           0
util.c:179:Changed query state from READING to PENDING
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3617:    result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3689:odbc_process_tokens: returning result_type 4049
odbc.c:3438:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:554:tds_process_tokens(0x7feee5c0c710, 0x7ffee33c7464, 
0x7ffee33c7460, 0x6914)
util.c:179:Changed query state from PENDING to READING
token.c:569:processing result tokens.  marker is  d1(ROW)
token.c:675:tds_process_tokens::SET_RETURN stopping on current token
util.c:179:Changed query state from READING to PENDING
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3617:    result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3689:odbc_process_tokens: returning result_type 4040
odbc.c:3438:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:4530:SQLNumResultCols(0x7feee81007e0, 0x7ffee33c74fe)

[015992.265419]
alisp           1164B25C0 EXIT  SQLExecDirect with return code 0 (SQL_SUCCESS)
                SQLHSTMT          0x7feee8100680
                SQLCHAR         * 0x7ffee33c7ba0
                SQLINTEGER        -3 (SQL_NTS)

[015992.265527]
alisp           1164B25C0 ENTER SQLNumResultCols
                SQLHSTMT          0x7feee8100680
                SQLSMALLINT     * 0x7ffee33c7ba0
odbc.c:4530:SQLNumResultCols(0x7feee81007e0, 0x7ffee33c763e)

[015992.265539]
alisp           1164B25C0 EXIT  SQLNumResultCols with return code 0 
(SQL_SUCCESS)
                SQLHSTMT          0x7feee8100680
                SQLSMALLINT     * 0x7ffee33c7ba0 (4)

[015992.265627]
alisp           1164B25C0 ENTER SQLColAttribute
                SQLHSTMT          0x7feee8100680
                SQLUSMALLINT      1
                SQLUSMALLINT      1 (unknown option)
                SQLPOINTER        0x0
                SQLINTEGER      * 0
                SQLSMALLINT     * 0x0
                SQLLEN          * 0x7ffee33c7ba0

[015992.265645]
alisp           1164B25C0 EXIT  SQLColAttribute with return code -1 
(SQL_ERROR)
                SQLHSTMT          0x7feee8100680
                SQLUSMALLINT      1
                SQLUSMALLINT      1 (unknown option)
                SQLPOINTER        0x0
                SQLINTEGER      * 0
                SQLSMALLINT     * 0x0
                SQLLEN          * 0x7ffee33c7ba0

[015992.266007]
alisp           1164B25C0 ENTER SQLGetDiagRec
                SQLSMALLINT       3 (SQL_HANDLE_STMT)
                SQLHSTMT          0x7feee8100680
                SQLSMALLINT       1
                SQLCHAR         * 0x7ffee33c7ba0
                SQLINTEGER      * 0x7ffee33c7bd0
                SQLCHAR         * 0x7ffee33c7bf0
                SQLSMALLINT       512
                SQLSMALLINT     * 0x7ffee33c8000
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7feee81007e0, 0x7ffee33c70a0, 
0x7ffee33c7bd0, 0x7feeea002e00, 512, 0x7ffee33c8000)

[015992.266031]
alisp           1164B25C0 EXIT  SQLGetDiagRec with return code 100 
(SQL_NO_DATA_FOUND)
                SQLSMALLINT       3 (SQL_HANDLE_STMT)
                SQLHSTMT          0x7feee8100680
                SQLSMALLINT       1
                SQLCHAR         * 0x7ffee33c7ba0
                SQLINTEGER      * 0x7ffee33c7bd0
                SQLCHAR         * 0x7ffee33c7bf0
                SQLSMALLINT       512
                SQLSMALLINT     * 0x7ffee33c8000 (-30462)