Re: SQL Server 2005 64-bit Connection oddities
"Hoellig, Peter" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <96CB3E5D78FC95438F9EB283460C868E02DDB3D1@LSEUSMS1230.am.corp.priv> |
I was issuing a couple of select queries on various tables. The first one I messed with when I started was SELECT * FROM TABLE1. TABLE1 was a table with about 13k rows in it so I only ran that one once because printing the results took too long. The next was on a smaller table with about 300 entries. I was running SELECT Contract_Number FROM TABLE2 and that was what I was using for all of my tests. I also ran SELECT Contract_Number FROM TABLE2 WHERE Contract_Number = 'value' and had the same error results. There is an odd couple of lines in the freetds.log I took where the statement SELECT 1 where 0=1 shows up. Even though the only query run during the logging is SELECT Contract_Number FROM TABLE2 WHERE Contract_Number = 'value'. I've attached the log of the queries with the DB login hacked out as well as the sql.log of the entire thing. In case you want to take a look. Thanks again. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio Sent: Wednesday, September 23, 2009 11:20 AM To: FreeTDS Development Group Subject: Re: [freetds] SQL Server 2005 64-bit Connection oddities 2009/9/23 Hoellig, Peter <[email protected]>: > " it's ok. Personally I always use TDS_Version explicitly but this is > not a problem (I imagine you used configure option)." > > Wow, now I feel like an idiot. Setting TDS_Version in the odbc.ini file to 8.0 is now giving me proper results. The original install must've used the configure option and thus didn't need the line. Inheriting systems is a wonderful thing. > > Thanks very much for all of your help. > Mmm... this however means that code for 4.2 protocol probably doesn't work as it should. What kind of queries did you issue (some particular select I suppose) ? freddy77 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please immediately notify the sender, and delete the original message and attachment.. _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
freetds.log
(application/octet-stream, 10.4 KB)
util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() net.c:673:Sending packet 0000 01 01 00 4b 00 00 00 00-53 45 4c 45 43 54 20 43 |...K.... SELECT C| 0010 6f 6e 74 72 61 63 74 5f-4e 75 6d 62 65 72 20 46 |ontract_ Number F| 0020 52 4f 4d 20 53 56 30 30-35 30 30 20 57 48 45 52 |ROM SV00 500 WHER| 0030 45 20 43 6f 6e 74 72 61-63 74 5f 4e 75 6d 62 65 |E Contra ct_Numbe| 0040 72 20 3d 20 27 30 34 34-2d 44 27 |r = '044 -D'| util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 01 01 00 08 00 00 00 00- |........| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 00 3a 03 1f 01 00- |...:....| net.c:542:Received packet 0000 a0 10 00 0f 43 6f 6e 74-72 61 63 74 5f 4e 75 6d |....Cont ract_Num| 0010 62 65 72 a1 06 00 01 00-08 00 2f 0b d1 0b 30 34 |ber..... ../...04| 0020 34 2d 44 20 20 20 20 20-20 fd 10 00 c1 00 01 00 |4-D .......| 0030 00 00 - |..| token.c:526:processing result tokens. marker is a0(COLNAME) read.c:179:tds_get_string: reading 15 from wire to give 15 to client. mem.c:519:tds_free_all_results() token.c:526:processing result tokens. marker is a1(COLFMT) token.c:1036:processing result. type = 47(char), varint_size 1 util.c:119:Changing query state from READING to PENDING util.c:119:Changing query state from PENDING to READING token.c:526:processing result tokens. marker is d1(ROW) util.c:119:Changing query state from READING to PENDING odbc.c:1524:odbc:SQLColAttribute: fDescType is 6 odbc.c:1524:odbc:SQLColAttribute: fDescType is 18 odbc.c:1524:odbc:SQLColAttribute: fDescType is 18 util.c:119:Changing query state from PENDING to READING token.c:526:processing result tokens. marker is d1(ROW) token.c:1863:tds_get_data: column 0, type 47, varint size 1 token.c:1920:processing row. column size is 11 util.c:119:Changing query state from READING to PENDING odbc.c:1524:odbc:SQLColAttribute: fDescType is 6 odbc.c:1524:odbc:SQLColAttribute: fDescType is 18 convert_tds2sql.c:62:convert_tds2sql: src is 47 dest = 1 convert_tds2sql.c:113:convert_tds2sql: outputting character data destlen = 5001 util.c:119:Changing query state from PENDING to READING token.c:526:processing result tokens. marker is fd(DONE) token.c:2143:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE token.c:2175: rows_affected = 1 util.c:119:Changing query state from IDLE to PENDING odbc.c:2892:SQLFetch: NO_DATA_FOUND token.c:514:tds_process_tokens() state is COMPLETED mem.c:519:tds_free_all_results() odbc.c:3066:SQLFreeHandle(3, 0x0x9f3b5d0) query.c:1709:tds_submit_unprepare() cnyjt36000 util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 01 01 00 1a 00 00 00 00-73 65 6c 65 63 74 20 31 |........ select 1| 0010 20 77 68 65 72 65 20 30-3d 31 | where 0 =1| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 00 11 03 1f 01 00- |........| net.c:542:Received packet 0000 fd 00 00 fd 00 00 00 00-00 |........ .| token.c:526:processing result tokens. marker is fd(DONE) token.c:2143:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE util.c:119:Changing query state from IDLE to PENDING token.c:514:tds_process_tokens() state is COMPLETED odbc.c:3538:Creating prepared statement token.c:514:tds_process_tokens() state is COMPLETED odbc.c:2527:End prepare, execute query.c:1573:tds_submit_execute() util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() net.c:673:Sending packet 0000 01 01 00 4b 00 00 00 00-53 45 4c 45 43 54 20 43 |...K.... SELECT C| 0010 6f 6e 74 72 61 63 74 5f-4e 75 6d 62 65 72 20 46 |ontract_ Number F| 0020 52 4f 4d 20 53 56 30 30-35 30 30 20 57 48 45 52 |ROM SV00 500 WHER| 0030 45 20 43 6f 6e 74 72 61-63 74 5f 4e 75 6d 62 65 |E Contra ct_Numbe| 0040 72 20 3d 20 27 30 34 34-2d 44 27 |r = '044 -D'| util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 01 01 00 08 00 00 00 00- |........| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 00 1d 03 1f 01 00- |........| net.c:542:Received packet 0000 a0 01 00 00 a1 05 00 07-00 20 00 38 fd 10 00 c1 |........ . .8....| 0010 00 00 00 00 00 - |.....| token.c:526:processing result tokens. marker is a0(COLNAME) mem.c:519:tds_free_all_results() token.c:526:processing result tokens. marker is a1(COLFMT) token.c:1036:processing result. type = 56(int), varint_size 0 util.c:119:Changing query state from READING to PENDING util.c:119:Changing query state from PENDING to READING token.c:526:processing result tokens. marker is fd(DONE) token.c:2143:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE token.c:2175: rows_affected = 0 util.c:119:Changing query state from IDLE to PENDING odbc.c:1524:odbc:SQLColAttribute: fDescType is 6 odbc.c:1524:odbc:SQLColAttribute: fDescType is 18 odbc.c:1524:odbc:SQLColAttribute: fDescType is 18 token.c:514:tds_process_tokens() state is COMPLETED odbc.c:2892:SQLFetch: NO_DATA_FOUND token.c:514:tds_process_tokens() state is COMPLETED mem.c:519:tds_free_all_results() odbc.c:3066:SQLFreeHandle(3, 0x0x9f3b5d0) query.c:1709:tds_submit_unprepare() cnyjt39000 util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 01 01 00 1a 00 00 00 00-73 65 6c 65 63 74 20 31 |........ select 1| 0010 20 77 68 65 72 65 20 30-3d 31 | where 0 =1| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 00 3a 03 1f 01 00- |...:....| net.c:542:Received packet 0000 a0 10 00 0f 43 6f 6e 74-72 61 63 74 5f 4e 75 6d |....Cont ract_Num| 0010 62 65 72 a1 06 00 01 00-08 00 2f 0b d1 0b 30 34 |ber..... ../...04| 0020 34 2d 44 20 20 20 20 20-20 fd 10 00 c1 00 01 00 |4-D .......| 0030 00 00 - |..| token.c:526:processing result tokens. marker is a0(COLNAME) read.c:179:tds_get_string: reading 15 from wire to give 15 to client. mem.c:519:tds_free_all_results() token.c:526:processing result tokens. marker is a1(COLFMT) token.c:1036:processing result. type = 47(char), varint_size 1 token.c:526:processing result tokens. marker is d1(ROW) token.c:1863:tds_get_data: column 0, type 47, varint size 1 token.c:1920:processing row. column size is 11 token.c:526:processing result tokens. marker is fd(DONE) token.c:2143:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE token.c:2175: rows_affected = 1 util.c:119:Changing query state from IDLE to PENDING token.c:514:tds_process_tokens() state is COMPLETED odbc.c:3538:Creating prepared statement token.c:514:tds_process_tokens() state is COMPLETED odbc.c:2527:End prepare, execute query.c:1573:tds_submit_execute() util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() net.c:673:Sending packet 0000 01 01 00 4b 00 00 00 00-53 45 4c 45 43 54 20 43 |...K.... SELECT C| 0010 6f 6e 74 72 61 63 74 5f-4e 75 6d 62 65 72 20 46 |ontract_ Number F| 0020 52 4f 4d 20 53 56 30 30-35 30 30 20 57 48 45 52 |ROM SV00 500 WHER| 0030 45 20 43 6f 6e 74 72 61-63 74 5f 4e 75 6d 62 65 |E Contra ct_Numbe| 0040 72 20 3d 20 27 30 34 34-2d 44 27 |r = '044 -D'| util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 01 01 00 08 00 00 00 00- |........| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 00 11 03 1f 01 00- |........| net.c:542:Received packet 0000 fd 00 00 fd 00 00 00 00-00 |........ .| token.c:526:processing result tokens. marker is fd(DONE) token.c:2143:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE util.c:119:Changing query state from IDLE to PENDING token.c:514:tds_process_tokens() state is COMPLETED odbc.c:3066:SQLFreeHandle(3, 0x0x9f3b5d0) query.c:1709:tds_submit_unprepare() cnyjt3c000 util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 01 01 00 1a 00 00 00 00-73 65 6c 65 63 74 20 31 |........ select 1| 0010 20 77 68 65 72 65 20 30-3d 31 | where 0 =1| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 00 1d 03 1f 01 00- |........| net.c:542:Received packet 0000 a0 01 00 00 a1 05 00 07-00 20 00 38 fd 10 00 c1 |........ . .8....| 0010 00 00 00 00 00 - |.....| token.c:526:processing result tokens. marker is a0(COLNAME) mem.c:519:tds_free_all_results() token.c:526:processing result tokens. marker is a1(COLFMT) token.c:1036:processing result. type = 56(int), varint_size 0 token.c:526:processing result tokens. marker is fd(DONE) token.c:2143:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE token.c:2175: rows_affected = 0 util.c:119:Changing query state from IDLE to PENDING token.c:514:tds_process_tokens() state is COMPLETED mem.c:519:tds_free_all_results() util.c:119:Changing query state from IDLE to DEAD
sql.log
(application/octet-stream, 11.6 KB)
[ODBC][5081][1253711621.578383][__handles.c][450] Exit:[SQL_SUCCESS] Environment = 0x9f0bf10 [ODBC][5081][1253711621.578466][SQLAllocHandle.c][364] Entry: Handle Type = 2 Input Handle = 0x9f0bf10 [ODBC][5081][1253711621.578506][SQLAllocHandle.c][482] Exit:[SQL_SUCCESS] Output Handle = 0x9f0c690 [ODBC][5081][1253711621.578553][SQLConnect.c][3614] Entry: Connection = 0x9f0c690 Server Name = [Gerster][length = 7 (SQL_NTS)] User Name = [sa][length = 2 (SQL_NTS)] Authentication = [**********][length = 10 (SQL_NTS)] UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE' [ODBC][5081][1253711621.586630][SQLConnect.c][4188] Exit:[SQL_SUCCESS] [ODBC][5081][1253711621.586696][SQLGetFunctions.c][147] Entry: Connection = 0x9f0c690 Id = SQLMoreResults Supported = 0x804e2d8 [ODBC][5081][1253711621.586735][SQLGetFunctions.c][182] Exit:[SQL_SUCCESS] Supported = 0x804e2d8 -> 1 [ODBC][5081][1253711639.973223][SQLAllocHandle.c][529] Entry: Handle Type = 3 Input Handle = 0x9f0c690 [ODBC][5081][1253711639.973420][SQLAllocHandle.c][1064] Exit:[SQL_SUCCESS] Output Handle = 0x9f48920 [ODBC][5081][1253711639.973503][SQLPrepare.c][192] Entry: Statement = 0x9f48920 SQL = [SELECT Contract_Number FROM SV00500 WHERE Contract_Number = '044-D'][length = 67 (SQL_NTS)] [ODBC][5081][1253711639.973587][SQLPrepare.c][367] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.973627][SQLExecute.c][183] Entry: Statement = 0x9f48920 [ODBC][5081][1253711639.974470][SQLExecute.c][344] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.974530][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f1da [ODBC][5081][1253711639.974567][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f1da -> 1 [ODBC][5081][1253711639.974644][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f19a [ODBC][5081][1253711639.974688][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f19a -> 1 [ODBC][5081][1253711639.974736][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_DISPLAY_SIZE Character Attr = (nil) Buffer Length = 0 String Length = (nil) Numeric Attribute = 0xbfb4ca28 [ODBC][5081][1253711639.974781][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.974817][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_LABEL Character Attr = 0xbfb4b69f Buffer Length = 5001 String Length = (nil) Numeric Attribute = (nil) [ODBC][5081][1253711639.974860][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.974900][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_LABEL Character Attr = 0xbfb4de11 Buffer Length = 5001 String Length = (nil) Numeric Attribute = (nil) [ODBC][5081][1253711639.974942][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.975016][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f19a [ODBC][5081][1253711639.975051][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f19a -> 1 [ODBC][5081][1253711639.975088][SQLFetch.c][158] Entry: Statement = 0x9f48920 [ODBC][5081][1253711639.975168][SQLFetch.c][340] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.975204][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_DISPLAY_SIZE Character Attr = (nil) Buffer Length = 0 String Length = (nil) Numeric Attribute = 0xbfb4ca28 [ODBC][5081][1253711639.975277][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.975313][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_LABEL Character Attr = 0xbfb4b69f Buffer Length = 5001 String Length = (nil) Numeric Attribute = (nil) [ODBC][5081][1253711639.975355][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711639.975397][SQLGetData.c][233] Entry: Statement = 0x9f48920 Column Number = 1 Target Type = 1 SQL_CHAR Buffer Length = 5001 Target Value = 0xbfb4de0b StrLen Or Ind = 0xbfb4f194 [ODBC][5081][1253711639.975466][SQLGetData.c][497] Exit:[SQL_SUCCESS] Buffer = [044-D ] Strlen Or Ind = 0xbfb4f194 -> 11 [ODBC][5081][1253711639.975518][SQLFetch.c][158] Entry: Statement = 0x9f48920 [ODBC][5081][1253711639.975620][SQLFetch.c][340] Exit:[SQL_NO_DATA] [ODBC][5081][1253711639.975681][SQLRowCount.c][169] Entry: Statement = 0x9f48920 Row Count = 0xbfb4f19c [ODBC][5081][1253711639.975717][SQLRowCount.c][240] Exit:[SQL_SUCCESS] Row Count = 0xbfb4f19c -> 1 [ODBC][5081][1253711639.975767][SQLMoreResults.c][158] Entry: Statement = 0x9f48920 [ODBC][5081][1253711639.975823][SQLMoreResults.c][313] Exit:[SQL_NO_DATA] [ODBC][5081][1253711639.975860][SQLFreeStmt.c][140] Entry: Statement = 0x9f48920 Option = 1 [ODBC][5081][1253711639.975897][SQLFreeHandle.c][378] Entry: Handle Type = 3 Input Handle = 0x9f48920 [ODBC][5081][1253711639.976184][SQLFreeHandle.c][480] Exit:[SQL_SUCCESS] [ODBC][5081][1253711641.235166][SQLAllocHandle.c][529] Entry: Handle Type = 3 Input Handle = 0x9f0c690 [ODBC][5081][1253711641.235271][SQLAllocHandle.c][1064] Exit:[SQL_SUCCESS] Output Handle = 0x9f48920 [ODBC][5081][1253711641.235320][SQLPrepare.c][192] Entry: Statement = 0x9f48920 SQL = [SELECT Contract_Number FROM SV00500 WHERE Contract_Number = '044-D'][length = 67 (SQL_NTS)] [ODBC][5081][1253711641.235391][SQLPrepare.c][367] Exit:[SQL_SUCCESS] [ODBC][5081][1253711641.235425][SQLExecute.c][183] Entry: Statement = 0x9f48920 [ODBC][5081][1253711641.235907][SQLExecute.c][344] Exit:[SQL_SUCCESS] [ODBC][5081][1253711641.235991][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f1da [ODBC][5081][1253711641.236039][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f1da -> 1 [ODBC][5081][1253711641.236090][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f19a [ODBC][5081][1253711641.236126][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f19a -> 1 [ODBC][5081][1253711641.236167][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_DISPLAY_SIZE Character Attr = (nil) Buffer Length = 0 String Length = (nil) Numeric Attribute = 0xbfb4ca28 [ODBC][5081][1253711641.236211][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711641.236247][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_LABEL Character Attr = 0xbfb4b69f Buffer Length = 5001 String Length = (nil) Numeric Attribute = (nil) [ODBC][5081][1253711641.236290][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711641.236325][SQLColAttribute.c][286] Entry: Statement = 0x9f48920 Column Number = 1 Field Identifier = SQL_DESC_LABEL Character Attr = 0xbfb4de11 Buffer Length = 5001 String Length = (nil) Numeric Attribute = (nil) [ODBC][5081][1253711641.236386][SQLColAttribute.c][657] Exit:[SQL_SUCCESS] [ODBC][5081][1253711641.236458][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f19a [ODBC][5081][1253711641.236493][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f19a -> 1 [ODBC][5081][1253711641.236526][SQLFetch.c][158] Entry: Statement = 0x9f48920 [ODBC][5081][1253711641.236577][SQLFetch.c][340] Exit:[SQL_NO_DATA] [ODBC][5081][1253711641.236623][SQLRowCount.c][169] Entry: Statement = 0x9f48920 Row Count = 0xbfb4f19c [ODBC][5081][1253711641.236659][SQLRowCount.c][240] Exit:[SQL_SUCCESS] Row Count = 0xbfb4f19c -> 0 [ODBC][5081][1253711641.236703][SQLMoreResults.c][158] Entry: Statement = 0x9f48920 [ODBC][5081][1253711641.236756][SQLMoreResults.c][313] Exit:[SQL_NO_DATA] [ODBC][5081][1253711641.236790][SQLFreeStmt.c][140] Entry: Statement = 0x9f48920 Option = 1 [ODBC][5081][1253711641.236824][SQLFreeHandle.c][378] Entry: Handle Type = 3 Input Handle = 0x9f48920 [ODBC][5081][1253711641.237201][SQLFreeHandle.c][480] Exit:[SQL_SUCCESS] [ODBC][5081][1253711642.177545][SQLAllocHandle.c][529] Entry: Handle Type = 3 Input Handle = 0x9f0c690 [ODBC][5081][1253711642.177655][SQLAllocHandle.c][1064] Exit:[SQL_SUCCESS] Output Handle = 0x9f48920 [ODBC][5081][1253711642.177705][SQLPrepare.c][192] Entry: Statement = 0x9f48920 SQL = [SELECT Contract_Number FROM SV00500 WHERE Contract_Number = '044-D'][length = 67 (SQL_NTS)] [ODBC][5081][1253711642.177776][SQLPrepare.c][367] Exit:[SQL_SUCCESS] [ODBC][5081][1253711642.177810][SQLExecute.c][183] Entry: Statement = 0x9f48920 [ODBC][5081][1253711642.178225][SQLExecute.c][344] Exit:[SQL_SUCCESS] [ODBC][5081][1253711642.178318][SQLNumResultCols.c][152] Entry: Statement = 0x9f48920 Column Count = 0xbfb4f1da [ODBC][5081][1253711642.178365][SQLNumResultCols.c][244] Exit:[SQL_SUCCESS] Count = 0xbfb4f1da -> 0 [ODBC][5081][1253711642.178401][SQLRowCount.c][169] Entry: Statement = 0x9f48920 Row Count = 0xbfb4f19c [ODBC][5081][1253711642.178436][SQLRowCount.c][240] Exit:[SQL_SUCCESS] Row Count = 0xbfb4f19c -> -1 [ODBC][5081][1253711642.178484][SQLMoreResults.c][158] Entry: Statement = 0x9f48920 [ODBC][5081][1253711642.178518][SQLMoreResults.c][313] Exit:[SQL_NO_DATA] [ODBC][5081][1253711642.178552][SQLFreeStmt.c][140] Entry: Statement = 0x9f48920 Option = 1 [ODBC][5081][1253711642.178585][SQLFreeHandle.c][378] Entry: Handle Type = 3 Input Handle = 0x9f48920 [ODBC][5081][1253711642.178906][SQLFreeHandle.c][480] Exit:[SQL_SUCCESS] [ODBC][5081][1253711644.990555][SQLDisconnect.c][204] Entry: Connection = 0x9f0c690 [ODBC][5081][1253711644.990784][SQLDisconnect.c][341] Exit:[SQL_SUCCESS] [ODBC][5081][1253711644.990837][SQLFreeHandle.c][279] Entry: Handle Type = 2 Input Handle = 0x9f0c690 [ODBC][5081][1253711644.990877][SQLFreeHandle.c][330] Exit:[SQL_SUCCESS] [ODBC][5081][1253711644.990921][SQLFreeHandle.c][212] Entry: Handle Type = 1 Input Handle = 0x9f0bf10