freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] FreeTDS Digest, Vol 197, Issue 4

From: Bruce Seely <bseely AT stsci.edu>
To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] FreeTDS Digest, Vol 197, Issue 4
Date: Fri, 31 Jul 2020 12:35:10 +0000

After sending log files, I realized that when the ODBC driver terminated,
FreeTDS had not finished wriing the log file. Below are the log files with
the error in the driver commented-out.

_____________________________________________________________________
sql.log:
** iODBC Trace file
** Trace started on Fri Jul 31 08:27:44 2020
** Driver Manager: 03.52.0607.1008

[000000.000141]
alisp 11A32C5C0 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x7ffee0bbf180

[000000.000159]
alisp 11A32C5C0 EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x7ffee0bbf180 (0x7fad37000490)

[000000.000959]
alisp 11A32C5C0 ENTER SQLSetEnvAttr
SQLHENV 0x7fad37000490
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x2
SQLINTEGER * 0

[000000.001008]
alisp 11A32C5C0 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x7fad37000490
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x2
SQLINTEGER * 0

[000000.001525]
alisp 11A32C5C0 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x7fad37000490
SQLHANDLE * 0x7ffee0bbf290

[000000.001549]
alisp 11A32C5C0 EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x7fad37000490
SQLHANDLE * 0x7ffee0bbf290 (0x7fad37000820)

[000000.001688]
alisp 11A32C5C0 ENTER SQLDriverConnect
SQLHDBC 0x7fad37000820
SQLPOINTER 0x0
SQLCHAR * 0x7ffee0bc0180
| DSN=R2D2;UID=bseely;PWD=************ |
SQLSMALLINT -3 (SQL_NTS)
SQLCHAR * 0x7ffee0bbf950
SQLSMALLINT 1024
SQLSMALLINT * 0x7ffee0bc0160
SQLUSMALLINT 0 (SQL_DRIVER_NOPROMPT)

[000000.153406]
alisp 11A32C5C0 EXIT SQLDriverConnect with return code 0
(SQL_SUCCESS)
SQLHDBC 0x7fad37000820
SQLPOINTER 0x0
SQLCHAR * 0x7ffee0bc0180
SQLSMALLINT -3 (SQL_NTS)
SQLCHAR * 0x7ffee0bbf950
| DSN=R2D2;UID=bseely;PWD=************ |
SQLSMALLINT 1024
SQLSMALLINT * 0x7ffee0bc0160 (36)
SQLUSMALLINT 0 (SQL_DRIVER_NOPROMPT)

[000000.153852]
alisp 11A32C5C0 ENTER SQLAllocHandle
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x7fad37000820
SQLHANDLE * 0x7ffee0bbf270

[000000.153907]
alisp 11A32C5C0 EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x7fad37000820
SQLHANDLE * 0x7ffee0bbf270 (0x7fad35415820)

[000000.155280]
alisp 11A32C5C0 ENTER SQLExecDirect
SQLHSTMT 0x7fad35415820
SQLCHAR * 0x7ffee0bbfe40
| use pps_lrp_alpha |
SQLINTEGER -3 (SQL_NTS)

[000000.169904]
alisp 11A32C5C0 EXIT SQLExecDirect with return code 1
(SQL_SUCCESS_WITH_INFO)
SQLHSTMT 0x7fad35415820
SQLCHAR * 0x7ffee0bbfe40
SQLINTEGER -3 (SQL_NTS)

[000000.170035]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf230
SQLINTEGER * 0x7ffee0bbf260
SQLCHAR * 0x7ffee0bbf280
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf690

[000000.170088]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf230
| 01000 |
SQLINTEGER * 0x7ffee0bbf260 (5701)
SQLCHAR * 0x7ffee0bbf280
| [FreeTDS][SQL Server]Changed database co |
| ntext to 'pps_lrp_alpha'. |
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf690 (65)

[000000.174750]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 2
SQLCHAR * 0x7ffee0bbf230
SQLINTEGER * 0x7ffee0bbf260
SQLCHAR * 0x7ffee0bbf280
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf690

[000000.174807]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 2
SQLCHAR * 0x7ffee0bbf230
SQLINTEGER * 0x7ffee0bbf260
SQLCHAR * 0x7ffee0bbf280
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf690 (65)

[000000.175115]
alisp 11A32C5C0 ENTER SQLNumResultCols
SQLHSTMT 0x7fad35415820
SQLSMALLINT * 0x7ffee0bc0730

[000000.175140]
alisp 11A32C5C0 EXIT SQLNumResultCols with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLSMALLINT * 0x7ffee0bc0730 (0)

[000000.175222]
alisp 11A32C5C0 ENTER SQLMoreResults
SQLHSTMT 0x7fad35415820

[000000.175248]
alisp 11A32C5C0 EXIT SQLMoreResults with return code 100
(SQL_NO_DATA_FOUND)
SQLHSTMT 0x7fad35415820

[000000.175335]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbfb40
SQLINTEGER * 0x7ffee0bbfb70
SQLCHAR * 0x7ffee0bbfb90
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbffa0

[000000.175371]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbfb40
SQLINTEGER * 0x7ffee0bbfb70
SQLCHAR * 0x7ffee0bbfb90
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbffa0 (4041)

[000000.175657]
alisp 11A32C5C0 ENTER SQLExecDirect
SQLHSTMT 0x7fad35415820
SQLCHAR * 0x7ffee0bbfec0
| select * from ppsdb_version |
SQLINTEGER -3 (SQL_NTS)

[000000.189580]
alisp 11A32C5C0 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLCHAR * 0x7ffee0bbfec0
SQLINTEGER -3 (SQL_NTS)

[000000.189904]
alisp 11A32C5C0 ENTER SQLNumResultCols
SQLHSTMT 0x7fad35415820
SQLSMALLINT * 0x7ffee0bc07b0

[000000.189958]
alisp 11A32C5C0 EXIT SQLNumResultCols with return code 0
(SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLSMALLINT * 0x7ffee0bc07b0 (4)

[000000.190767]
alisp 11A32C5C0 ENTER SQLColAttribute
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 1
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.191430]
alisp 11A32C5C0 EXIT SQLColAttribute with return code -1
(SQL_ERROR)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 1
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.191683]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810

[000000.191750]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810 (4041)

[000000.192396]
alisp 11A32C5C0 ENTER SQLColAttribute
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 2
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.192430]
alisp 11A32C5C0 EXIT SQLColAttribute with return code -1
(SQL_ERROR)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 2
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.192647]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810

[000000.192720]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810 (4041)

[000000.193344]
alisp 11A32C5C0 ENTER SQLColAttribute
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 3
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.193390]
alisp 11A32C5C0 EXIT SQLColAttribute with return code -1
(SQL_ERROR)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 3
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.193596]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810

[000000.193658]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810 (4041)

[000000.194073]
alisp 11A32C5C0 ENTER SQLColAttribute
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 4
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.194105]
alisp 11A32C5C0 EXIT SQLColAttribute with return code -1
(SQL_ERROR)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 4
SQLUSMALLINT 1011 (SQL_DESC_NAME)
SQLPOINTER 0x7ffee0bbffb0
SQLINTEGER * 256
SQLSMALLINT * 0x7ffee0bc01c0
SQLLEN * 0x0

[000000.194242]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810

[000000.194279]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbf3b0
SQLINTEGER * 0x7ffee0bbf3e0
SQLCHAR * 0x7ffee0bbf400
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bbf810 (4041)

[000000.194450]
alisp 11A32C5C0 ENTER SQLFetch
SQLHSTMT 0x7fad35415820

[000000.194531]
alisp 11A32C5C0 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820

[000000.194620]
alisp 11A32C5C0 ENTER SQLGetData
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 1
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x8000008e030
SQLLEN 1024
SQLLEN * 0x80000010db0

[000000.194670]
alisp 11A32C5C0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 1
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x8000008e030
| 1 |
SQLLEN 1024
SQLLEN * 0x80000010db0 (1)

[000000.194771]
alisp 11A32C5C0 ENTER SQLGetData
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 2
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x8000008f030
SQLLEN 1024
SQLLEN * 0x80000010a30

[000000.194806]
alisp 11A32C5C0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 2
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x8000008f030
| PPSDB86 |
SQLLEN 1024
SQLLEN * 0x80000010a30 (7)

[000000.194890]
alisp 11A32C5C0 ENTER SQLGetData
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 3
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x80000090030
SQLLEN 1024
SQLLEN * 0x80000010b30

[000000.194927]
alisp 11A32C5C0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 3
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x80000090030
| 2020-02-11 18:26:38 -05:00 |
SQLLEN 1024
SQLLEN * 0x80000010b30 (26)

[000000.195013]
alisp 11A32C5C0 ENTER SQLGetData
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 4
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x80000091030
SQLLEN 1024
SQLLEN * 0x80000010e30

[000000.195047]
alisp 11A32C5C0 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 4
SQLSMALLINT 1 (SQL_C_CHAR)
SQLPOINTER 0x80000091030
SQLLEN 1024
SQLLEN * 0x80000010e30 (0)

[000000.195109]
alisp 11A32C5C0 ENTER SQLFetch
SQLHSTMT 0x7fad35415820

[000000.195167]
alisp 11A32C5C0 EXIT SQLFetch with return code 100
(SQL_NO_DATA_FOUND)
SQLHSTMT 0x7fad35415820

[000000.195257]
alisp 11A32C5C0 ENTER SQLGetDiagRec
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbfcb0
SQLINTEGER * 0x7ffee0bbfce0
SQLCHAR * 0x7ffee0bbfd00
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bc0110

[000000.195294]
alisp 11A32C5C0 EXIT SQLGetDiagRec with return code 100
(SQL_NO_DATA_FOUND)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHSTMT 0x7fad35415820
SQLSMALLINT 1
SQLCHAR * 0x7ffee0bbfcb0
SQLINTEGER * 0x7ffee0bbfce0
SQLCHAR * 0x7ffee0bbfd00
SQLSMALLINT 512
SQLSMALLINT * 0x7ffee0bc0110 (4041)

[000000.195365]
alisp 11A32C5C0 ENTER SQLFreeStmt
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 2 (SQL_UNBIND)

[000000.195393]
alisp 11A32C5C0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 2 (SQL_UNBIND)

[000000.195407]
alisp 11A32C5C0 ENTER SQLFreeStmt
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 0 (SQL_CLOSE)

[000000.195427]
alisp 11A32C5C0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x7fad35415820
SQLUSMALLINT 0 (SQL_CLOSE)

_____________________________________________________________________
freetds.log:
log.c:168:Starting log file for FreeTDS 1.2rc3
on 2020-07-31 08:27:44 with debug flags 0x4fff.
iconv.c:365:tds_iconv_open(0x7fad35600e80, UTF-8)
iconv.c:196:local name for ISO-8859-1 is ISO-8859-1
iconv.c:196:local name for UTF-8 is UTF-8
iconv.c:196:local name for UCS-2LE is UCS-2LE
iconv.c:196:local name for UCS-2BE is UCS-2BE
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 a8 69 00-00 00 |rver.¨i. ..|

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 e1 65 50 35 07-5c 1f 10 f7 15 2e 3c c7 |:..áeP5. \..÷..<Ç|
0020 ba 30 86 20 8e 36 6b 18-b9 04 6f 34 36 9a 2a 5f |º0. .6k. ¹.o46.*_|
0030 60 67 e6 20 d2 b5 e0 e1-bb b8 1c c3 c1 b3 5f a8 |`gæ Òµàá »¸.ÃÁ³_¨|
0040 0f b3 b3 a5 8f bd fc da-49 6f d1 88 49 7b 49 c8 |.³³¥.½üÚ IoÑ.I{IÈ|
0050 1e 83 cc d7 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 10 97 d0 35 39 |..3.&.$. .. ..Ð59|
0130 95 34 51 7d c2 57 cf 08-ba 93 4c 3d b6 f6 76 62 |.4Q}ÂWÏ. º.L=¶övb|
0140 92 9c 5e 45 28 14 e8 cd-6e b9 7f |..^E(.èÍ n¹.|

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 24 0e 41 8b-68 68 5b 8a e6 70 75 5a |Q.._$.A. hh[.æpuZ|
0020 f1 fd e3 37 80 82 ec 78-03 c9 ec a3 15 ce 60 01 |ñýã7..ìx .Éì£.Î`.|
0030 2c 3e a1 20 18 0b 00 00-f5 9c 99 43 83 9c ee bb |,>¡ .... õ..C..î»|
0040 2c b0 88 3c 72 0d 97 fe-d6 4b 34 24 bc 1e 1b 28 |,°.<r..þ ÖK4$¼..(|
0050 d0 a3 7f 2d 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 57 0b bb 16 88 |0..è ... ...W.»..|
0080 95 df a7 4a 36 bd d8 cf-3f cd 3f 30 0d 06 09 2a |.ß§J6½ØÏ ?Í?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 37 32 |b.a.c.k0 ..20072|
00e0 31 30 39 35 37 33 31 5a-18 0f 32 30 35 30 30 37 |1095731Z ..205007|
00f0 32 31 30 39 35 37 33 31-5a 30 3b 31 39 30 37 06 |21095731 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 c5-b7 36 4f 20 27 9e 88 60 |.......Å ·6O '..`|
0160 25 cb 2a 51 71 c6 3a 36-72 52 07 bb 96 35 d4 34 |%Ë*QqÆ:6 rR.».5Ô4|
0170 ab ee 93 87 56 a4 8f 32-32 b0 db 53 a7 13 da 4a |«î..V¤.2 2°ÛS§.ÚJ|
0180 e3 33 11 b2 0a 51 0d 4a-08 60 2b 27 ad 38 c5 c1 |ã3.².Q.J .`+'8ÅÁ|
0190 52 5b 3f 76 aa b9 88 f8-fa 25 56 4b d4 9c 54 8e |R[?vª¹.ø ú%VKÔ.T.|
01a0 17 7e ee 35 61 c2 6a 80-6a e3 f9 f1 be 30 ed 8a |.~î5aÂj. jãùñ¾0í.|
01b0 e6 fb 95 52 bb 1f 71 7c-71 20 e5 6f 04 93 37 12 |æû.R».q| q åo..7.|
01c0 cc 71 50 0c 92 83 5d a1-d5 d8 b3 a9 ed 0d 74 9b |ÌqP...]¡ ÕØ³©í.t.|
01d0 7b 13 4f 62 8b fc 51 b4-90 ef 1d 68 64 11 41 55 |{.Ob.üQ´ .ï.hd.AU|
01e0 5b 8c 1b 78 4a fe 6c cc-22 e9 c6 2d ab c8 a5 a8 |[..xJþlÌ "éÆ-«È¥¨|
01f0 df 12 5f f1 53 de 56 a5-40 d5 4f 41 8f 72 97 b5 |ß._ñSÞV¥ @ÕOA.r.µ|
0200 d9 e8 69 84 df ae d8 07-48 a3 b4 25 6b 85 b1 49 |Ùèi.ß®Ø. H£´%k.±I|
0210 e0 e7 d1 31 66 06 97 ee-f7 18 75 fd 42 36 9b b9 |àçÑ1f..î ÷.uýB6.¹|
0220 5d cc 12 ef 44 71 8b 9b-de 5f 7b b4 bb 4c 69 18 |]Ì.ïDq.. Þ_{´»Li.|
0230 f6 4c 70 cb 1e f5 bb f3-76 96 00 d1 75 68 ac 88 |öLpË.õ»ó v..Ñuh¬.|
0240 cb f2 2d 64 73 87 c3 05-d9 e8 9d 20 b8 59 b3 a6 |Ëò-ds.Ã. Ùè. ¸Y³¦|
0250 a1 a5 90 a5 fd 6e 17 02-03 01 00 01 30 0d 06 09 |¡¥.¥ýn.. ....0...|
0260 2a 86 48 86 f7 0d 01 01-05 05 00 03 82 01 01 00 |*.H.÷... ........|
0270 7e 1b 94 2e 80 88 64 db-20 94 9c f4 9d 83 54 b0 |~.....dÛ ..ô..T°|
0280 a1 7c a9 42 3c 20 8f 3c-90 6b 91 33 2c 67 a5 1c |¡|©B< .< .k.3,g¥.|
0290 07 4f 7e a8 e4 4c 4c e8-3a 04 f8 70 dd 92 f8 ee |.O~¨äLLè :.øpÝ.øî|
02a0 98 2d 16 ec 35 30 91 de-67 8c 91 55 c6 8f 05 9b |.-.ì50.Þ g..UÆ...|
02b0 18 a5 ba 86 4c 17 8d a8-5c 35 73 82 38 ed 49 0f |.¥º.L..¨ \5s.8íI.|
02c0 8f 91 a6 c4 cd 38 fb a4-fd 0e f5 1f 6c 1b 7c 41 |..¦ÄÍ8û¤ ý.õ.l.|A|
02d0 ec c9 00 bf d8 3a b8 8c-b5 68 67 75 69 7d e5 00 |ìÉ.¿Ø:¸. µhgui}å.|
02e0 37 ba e0 2e 38 8e 23 e2-b5 35 80 e3 b5 77 c0 9c |7ºà.8.#â µ5.ãµwÀ.|
02f0 30 e7 48 8c 33 b8 37 32-35 ef d4 15 84 82 87 50 |0çH.3¸72 5ïÔ....P|
0300 a3 ca 28 fa 37 f3 c7 81-fe a9 31 01 bf 55 9e f5 |£Ê(ú7óÇ. þ©1.¿U.õ|
0310 1e f8 df dd a0 78 1b 23-a7 1a 90 99 56 55 c0 c5 |.øßÝ x.# §...VUÀÅ|
0320 5c 76 ff 79 f5 14 03 4a-1e 47 6c 60 8f 03 09 34 |\vÿyõ..J .Gl`...4|
0330 b3 44 60 2e 16 ae 4a f0-34 cf 42 b3 ed 2c 69 a2 |³D`..®Jð 4ÏB³í,i¢|
0340 cc ad 61 54 86 96 a1 12-76 2c 62 1c c1 42 86 f7 |ÌaT..¡. v,b.ÁB.÷|
0350 26 9d 6e be 31 83 44 66-ad 2a 2b d9 61 cd 60 a2 |&.n¾1.Df *+ÙaÍ`¢|
0360 40 30 80 8f 32 b2 aa 1b-32 cc d4 99 a6 6a b9 94 |@0..2²ª. 2ÌÔ.¦j¹.|
0370 0c 00 01 28 03 00 1d 20-55 4b 72 70 c7 a0 80 0f |...(... UKrpÇ ..|
0380 83 d6 be e6 48 ca 20 c8-86 30 f5 a5 a5 63 39 4f |.Ö¾æHÊ È .0õ¥¥c9O|
0390 14 22 b8 5f c5 fe 2c 6f-04 01 01 00 14 e7 b3 0c |."¸_Åþ,o .....ç³.|
03a0 20 5f ed 65 dc b2 6b 32-00 bb eb 82 07 21 c3 8c | _íeÜ²k2 .»ë..!Ã.|
03b0 81 f6 b6 f3 93 43 38 a5-98 8d 8b 23 65 22 6d 05 |.ö¶ó.C8¥ ...#e"m.|
03c0 96 bd bf 68 74 b3 5e 59-f8 64 30 c7 e9 f4 82 58 |.½¿ht³^Y ød0Çéô.X|
03d0 dd 4e 6d 2c 56 90 f5 35-45 dc cc ae 73 44 38 b6 |ÝNm,V.õ5 EÜÌ®sD8¶|
03e0 cc 91 fb 18 21 48 e0 8f-dc f4 a8 f2 e7 a3 c6 03 |Ì.û.!Hà. Üô¨òç£Æ.|
03f0 ec 97 77 0e 08 b1 28 ad-7d fc 32 6c 09 7f 9c d1 |ì.w..±( }ü2l...Ñ|
0400 1a 0c 66 d1 89 8c e8 94-73 26 ba 33 65 05 a9 84 |..fÑ..è. s&º3e.©.|
0410 2c 52 7e b0 26 37 2e 61-6b 0a 0c 73 ab 3d 9c 05 |,R~°&7.a k..s«=..|
0420 fc 97 18 2d cf 3d 22 8b-04 48 e2 e5 2d 26 98 c7 |ü..-Ï=". .Hâå-&.Ç|
0430 a0 7d fe 88 81 8d 68 a0-a2 44 be 1e e3 a4 fe 4d | }þ...h ¢D¾.ã¤þM|
0440 e8 22 68 c0 bc 5f a3 12-ea cb 89 11 37 de 18 e8 |è"hÀ¼_£. êË..7Þ.è|
0450 01 2d a6 2f e6 6e 5d 93-51 1e c9 a3 b3 4f 22 43 |.-¦/æn]. Q.É£³O"C|
0460 5e f6 79 de c9 7f 19 cd-5f 2b 86 21 b5 7f 38 23 |^öyÞÉ..Í _+.!µ.8#|
0470 48 57 08 dc 69 19 e4 32-e1 31 73 04 c3 76 62 ed |HW.Üi.ä2 á1s.Ãvbí|
0480 33 2f 43 21 bf b6 13 d0-01 4c fc 1d a6 61 12 6f |3/C!¿¶.Ð .Lü.¦a.o|
0490 c2 bd 2e 36 34 62 bc 8b-f7 fa b9 16 0e 00 00 00 |Â½.64b¼. ÷ú¹.....|

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 23 ab 0a da 3b 02-0f 83 b1 69 c1 5f 4a 50 |! #«.Ú;. ..±iÁ_JP|
0020 af ca 3d 0b 1f 6e 9a 11-c7 cb 8c 49 c9 69 71 38 |¯Ê=..n.. ÇË.IÉiq8|
0030 c3 1a 14 03 03 00 01 01-16 03 03 00 28 e4 7c 6a |Ã....... ....(ä|j|
0040 c2 05 7d c3 b9 2a 1a b1-2b b8 fe e8 ad 98 4d 6f |Â.}Ã¹*.± +¸þè.Mo|
0050 31 72 ac ee 09 f2 14 38-f7 1a 6c 17 e5 f3 fb b6 |1r¬î.ò.8 ÷.l.åóû¶|
0060 98 81 af 83 e2 - |..¯.â|

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 b3 c2 39 52 41 |..(..... ...³Â9RA|
0020 8b 13 ec f2 42 85 72 ab-a6 57 54 64 4a 23 eb 24 |..ìòB.r« ¦WTdJ#ë$|
0030 fb be b4 0d b4 92 76 64-cd 77 9a |û¾´.´.vd Íw.|

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 4f 01 00-e3 1b 00 01 06 6d 00 61 |.....O.. ã....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(0x7fad356011d0, 0x7ffee0bb7ea0,
0x7ffee0bb7ea4, 0x100)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 15 00 4f 01 00-fd 00 00 be 00 00 00 00 |.....O.. ý..¾....|
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(0x7fad356011d0, 0x7ffee0bb7ea0,
0x7ffee0bb7ea4, 0x100)
token.c:557:tds_process_tokens() state is COMPLETED
odbc.c:5941:SQLGetInfoW(0x7fad36005200, 23, 0x7fad370008f8, 2, 0x0)
odbc.c:5173:_SQLGetInfo(0x7fad36005200, 23, 0x7fad370008f8, 2, 0x0)
odbc.c:5941:SQLGetInfoW(0x7fad36005200, 24, 0x7fad370008fa, 2, 0x0)
odbc.c:5173:_SQLGetInfo(0x7fad36005200, 24, 0x7fad370008fa, 2, 0x0)
odbc.c:1812:SQLAllocStmt(0x7fad36005200, 0x7fad35415848)
odbc.c:1706:_SQLAllocStmt(0x7fad36005200, 0x7fad35415848)
odbc.c:4508:SQLGetStmtAttr(0x7fad35416630, 10010, 0x7fad35415ae8, 0, 0x0)
odbc.c:4508:SQLGetStmtAttr(0x7fad35416630, 10011, 0x7fad35416168, 0, 0x0)
odbc.c:4508:SQLGetStmtAttr(0x7fad35416630, 10012, 0x7fad35416928, 0, 0x0)
odbc.c:4508:SQLGetStmtAttr(0x7fad35416630, 10013, 0x7fad35416968, 0, 0x0)
odbc_export.h:801:SQLExecDirectW(0x7fad35416630, use pps_lrp_alpha, -3)
prepare_query.c:208:parsing 0 parameters
odbc.c:3275:_SQLExecute(0x7fad35416630)
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 40 00 00 01 00-16 00 00 00 12 00 00 00 |...@.... ........|
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 61 00-6c 00 70 00 68 00 61 00 |r.p._.a. l.p.h.a.|

util.c:179:Changed query state from WRITING to PENDING
token.c:554:tds_process_tokens(0x7fad356011d0, 0x7ffee0bbf704,
0x7ffee0bbf700, 0x6914)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 cf 00 4f 01 00-e3 29 00 01 0d 70 00 70 |...Ï.O.. ã)...p.p|
0010 00 73 00 5f 00 6c 00 72-00 70 00 5f 00 61 00 6c |.s._.l.r .p._.a.l|
0020 00 70 00 68 00 61 00 06-6d 00 61 00 73 00 74 00 |.p.h.a.. m.a.s.t.|
0030 65 00 72 00 ab 80 00 45-16 00 00 01 00 2c 00 43 |e.r.«..E .....,.C|
0040 00 68 00 61 00 6e 00 67-00 65 00 64 00 20 00 64 |.h.a.n.g .e.d. .d|
0050 00 61 00 74 00 61 00 62-00 61 00 73 00 65 00 20 |.a.t.a.b .a.s.e. |
0060 00 63 00 6f 00 6e 00 74-00 65 00 78 00 74 00 20 |.c.o.n.t .e.x.t. |
0070 00 74 00 6f 00 20 00 27-00 70 00 70 00 73 00 5f |.t.o. .' .p.p.s._|
0080 00 6c 00 72 00 70 00 5f-00 61 00 6c 00 70 00 68 |.l.r.p._ .a.l.p.h|
0090 00 61 00 27 00 2e 00 0d-44 00 57 00 50 00 50 00 |.a.'.... D.W.P.P.|
00a0 53 00 52 00 32 00 44 00-32 00 44 00 42 00 56 00 |S.R.2.D. 2.D.B.V.|
00b0 31 00 00 01 00 00 00 e3-08 00 07 05 09 04 c0 00 |1......ã ......À.|
00c0 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(0x7fad356011d0, 0x7ffee0bbf704,
0x7ffee0bbf700, 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
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbe740,
0x7ffee0bbf260, 0x7fad38001000, 512, 0x7ffee0bbf690)
error.c:559:SQLGetDiagRec: "[FreeTDS][SQL Server]Changed database context to
'pps_lrp_alpha'."
odbc.c:4530:SQLNumResultCols(0x7fad35416630, 0x7ffee0bbfc0e)
odbc.c:893:SQLMoreResults(0x7fad35416630)
odbc.c:4530:SQLNumResultCols(0x7fad35416630, 0x7ffee0bc029e)
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbf050,
0x7ffee0bbfb70, 0x7fad3600b600, 512, 0x7ffee0bbffa0)
odbc_export.h:801:SQLExecDirectW(0x7fad35416630, select * from ppsdb_version,
-3)
prepare_query.c:208:parsing 0 parameters
odbc.c:3275:_SQLExecute(0x7fad35416630)
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(0x7fad356011d0, 0x7ffee0bbf784,
0x7ffee0bbf780, 0x6914)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 d0 00 4f 01 00-81 04 00 00 00 00 00 08 |...Ð.O.. ........|
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 32 00 2d 00 31 00 31 |.2.0.-.0 .2.-.1.1|
00a0 00 20 00 31 00 38 00 3a-00 32 00 36 00 3a 00 33 |. .1.8.: .2.6.:.3|
00b0 00 38 00 20 00 2d 00 30-00 35 00 3a 00 30 00 30 |.8. .-.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(0x7fad356011d0, 0x7ffee0bbf784,
0x7ffee0bbf780, 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(0x7fad35416630, 0x7ffee0bbf81e)
odbc.c:4530:SQLNumResultCols(0x7fad35416630, 0x7ffee0bbfc8e)
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbe8c0,
0x7ffee0bbf3e0, 0x7fad3600b600, 512, 0x7ffee0bbf810)
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbe8c0,
0x7ffee0bbf3e0, 0x7fad3600b600, 512, 0x7ffee0bbf810)
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbe8c0,
0x7ffee0bbf3e0, 0x7fad3600b600, 512, 0x7ffee0bbf810)
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbe8c0,
0x7ffee0bbf3e0, 0x7fad3600b600, 512, 0x7ffee0bbf810)
odbc.c:4020:SQLFetch(0x7fad35416630)
odbc.c:3754:_SQLFetch(0x7fad35416630, 1, 0)
token.c:554:tds_process_tokens(0x7fad356011d0, 0x7ffee0bc0374,
0x7ffee0bc0370, 0x6508)
util.c:179:Changed query state from PENDING to READING
token.c:569:processing result tokens. marker is d1(ROW)
token.c:1951:tds_process_row(): reading column 0
data.c:719:tds_get_data: type 48, varint size 0
data.c:763:tds_get_data(): wire column size is 1
token.c:1951:tds_process_row(): reading column 1
data.c:719:tds_get_data: type 39, varint size 2
data.c:763:tds_get_data(): wire column size is 7
token.c:1951:tds_process_row(): reading column 2
data.c:719:tds_get_data: type 39, varint size 2
data.c:763:tds_get_data(): wire column size is 52
token.c:1951:tds_process_row(): reading column 3
data.c:719:tds_get_data: type 39, varint size 2
data.c:763:tds_get_data(): wire column size is 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=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3689:odbc_process_tokens: returning result_type 4040
odbc.c:4914:SQLGetData(0x7fad35416630, 1, 1, 0x8000008e030, 1024,
0x80000010db0)
convert_tds2sql.c:293:odbc_tds2sql: src is 48 dest = 1
convert_tds2sql.c:429:odbc_tds2sql: outputting character data destlen = 1024
odbc.c:4914:SQLGetData(0x7fad35416630, 2, 1, 0x8000008f030, 1024,
0x80000010a30)
convert_tds2sql.c:293:odbc_tds2sql: src is 167 dest = 1
odbc.c:4914:SQLGetData(0x7fad35416630, 3, 1, 0x80000090030, 1024,
0x80000010b30)
convert_tds2sql.c:293:odbc_tds2sql: src is 231 dest = 1
odbc.c:4914:SQLGetData(0x7fad35416630, 4, 1, 0x80000091030, 1024,
0x80000010e30)
convert_tds2sql.c:293:odbc_tds2sql: src is 167 dest = 1
odbc.c:4020:SQLFetch(0x7fad35416630)
odbc.c:3754:_SQLFetch(0x7fad35416630, 1, 0)
token.c:554:tds_process_tokens(0x7fad356011d0, 0x7ffee0bc0374,
0x7ffee0bc0370, 0x6508)
util.c:179:Changed query state from PENDING to READING
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 = 1
token.c:2115: rows_affected = 1
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=10, TDS_DONE_ERROR=0
odbc.c:3659:odbc_process_tokens: row_count=1
odbc.c:3888:SQLFetch: NO_DATA_FOUND
error_export.h:83:SQLErrorW(0x0, 0x0, 0x7fad35416630, 0x7ffee0bbf1c0,
0x7ffee0bbfce0, 0x7fad3600b600, 512, 0x7ffee0bc0110)
odbc.c:4248:SQLFreeStmt(0x7fad35416630, 2)
odbc.c:4165:_SQLFreeStmt(0x7fad35416630, 2, 0)
odbc.c:4248:SQLFreeStmt(0x7fad35416630, 0)
odbc.c:4165:_SQLFreeStmt(0x7fad35416630, 0, 0)

Re: [freetds] FreeTDS Digest, Vol 197, Issue 4, Bruce Seely, 07/28/2020
- <Possible follow-up(s)>
- Re: [freetds] FreeTDS Digest, Vol 197, Issue 4, Bruce Seely, 07/31/2020