Bug #996 | MyODBC MS SQL Server DTS fails export data | ||
---|---|---|---|
Submitted: | 5 Aug 2003 0:40 | Modified: | 8 Dec 2005 17:09 |
Reporter: | Leroy Cyril | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / ODBC | Severity: | S1 (Critical) |
Version: | 3.51.06 | OS: | Windows (win xp) |
Assigned to: | Peter Harvey | CPU Architecture: | Any |
[5 Aug 2003 0:40]
Leroy Cyril
[5 Aug 2003 21:57]
Venu Anuganti
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ This has been addressed long back and fixed it, and some how the patch got reverted in 3.51.06, but it is suppose to work with 3.51.04 or 3.51.05. Any means, you can also grab the 3.51.06-02 version for Windows (dlls only) from here: ftp://support.mysql.com/pub/odbc/MyODBC-3.51.06-02-dll.zip Thanks Venu
[6 Aug 2003 5:16]
Leroy Cyril
Hi, Thanks a lot to your quick answer ! 3.51.06_02 dll's still does not work 3.51.04 does not work Table creation goes rigth but data copy fails "Error at destination for row Number 1: Error encouteder so far for this task: 1"
[6 Aug 2003 10:31]
Venu Anuganti
I tried with schema as (a int, b text, c tinytext) and 0 rows and also filled with 2-3 rows, and it just went through fine. Can you be more specifica about what kind of error you are getting from ODBC DM trace ? And or any schema to reproduce myself using 3.51.06-02 version ? Thanks
[7 Aug 2003 2:00]
Leroy Cyril
Hi ! Here is the complete test and odbc trace. I choose 3.51.04 because it's a clean install but if you prefer I can redo with 06_02 dll. * in Mysql database = test CREATE TABLE test ( id int(11) NOT NULL default '0', test longtext, PRIMARY KEY (id)) TYPE=MyISAM; * in MSSql database = testcyril CREATE TABLE [dbo].[test] ([id] [int] NOT NULL,[texte] [text] NULL ) * in enterprise manager: Tools>d.t.s>export data> source=local.... destination=Mysql Odbc 3.51 driver dsn = mysql3.51.04 win2003 (version=3.51.04 option checked=Don't optimize column width+return matching row) Next> copy table Next> source = [testcyril].[dbo].[test] destination = `test`.`test` tranformation = append data (note: type of column texte = long varchar) Next>Run immediately Just Before clicking Finish I start ODBC TRACE: Error DTS = Error at destination for row 1... file sql.log= SQL Server Ente 144-b94 ENTER SQLAllocConnect HENV 01553B90 HDBC * 0364F380 SQL Server Ente 144-b94 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 01553B90 HDBC * 0x0364F380 ( 0x01552b48) SQL Server Ente 144-b94 ENTER SQLDriverConnectW HDBC 01552B48 HWND 00000000 WCHAR * 0x014D1E9C [ -3] "******\ 0" SWORD -3 WCHAR * 0x014D1E9C SWORD 2 SWORD * 0x00000000 UWORD 0 <SQL_DRIVER_NOPROMPT> SQL Server Ente 144-b94 EXIT SQLDriverConnectW with return code 0 (SQL_SUCCESS) HDBC 01552B48 HWND 00000000 WCHAR * 0x014D1E9C [ -3] "******\ 0" SWORD -3 WCHAR * 0x014D1E9C SWORD 2 SWORD * 0x00000000 UWORD 0 <SQL_DRIVER_NOPROMPT> SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 77 <SQL_DRIVER_ODBC_VER> PTR 0x0364F33C SWORD 24 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 77 <SQL_DRIVER_ODBC_VER> PTR 0x0364F33C SWORD 24 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 79 <SQL_POS_OPERATIONS> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 79 <SQL_POS_OPERATIONS> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 83 <SQL_STATIC_SENSITIVITY> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 83 <SQL_STATIC_SENSITIVITY> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 78 <SQL_LOCK_TYPES> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 78 <SQL_LOCK_TYPES> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 81 <SQL_GETDATA_EXTENSIONS> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 81 <SQL_GETDATA_EXTENSIONS> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 72 <SQL_TXN_ISOLATION_OPTION> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 72 <SQL_TXN_ISOLATION_OPTION> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 82 <SQL_BOOKMARK_PERSISTENCE> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 82 <SQL_BOOKMARK_PERSISTENCE> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 44 <SQL_SCROLL_OPTIONS> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 44 <SQL_SCROLL_OPTIONS> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 43 <SQL_SCROLL_CONCURRENCY> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 43 <SQL_SCROLL_CONCURRENCY> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 144 <SQL_DYNAMIC_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 150 <SQL_KEYSET_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 167 <SQL_STATIC_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 146 <SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 151 <SQL_KEYSET_CURSOR_ATTRIBUTES2> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 168 <SQL_STATIC_CURSOR_ATTRIBUTES2> PTR 0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 111 <SQL_NEED_LONG_DATA_LEN> PTR 0x0364F108 SWORD 512 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 111 <SQL_NEED_LONG_DATA_LEN> PTR 0x0364F108 SWORD 512 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 16 <SQL_DATABASE_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F100 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 16 <SQL_DATABASE_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F100 (8) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x0364F104 (2) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x0364F104 (2) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x0364F104 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 46 <SQL_TXN_CAPABLE> PTR 0x0364F104 (3) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLSetConnectAttrW SQLHDBC 01552B48 SQLINTEGER 1 <SQL_ATTR_MAX_ROWS> SQLPOINTER 0x00000000 SQLINTEGER -6 SQL Server Ente 144-b94 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 01552B48 SQLINTEGER 1 <SQL_ATTR_MAX_ROWS> SQLPOINTER 0x00000000 SQLINTEGER -6 SQL Server Ente 144-b94 ENTER SQLSetConnectAttrW SQLHDBC 01552B48 SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT> SQLPOINTER 0x00000000 SQLINTEGER -6 SQL Server Ente 144-b94 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 01552B48 SQLINTEGER 0 <SQL_ATTR_QUERY_TIMEOUT> SQLPOINTER 0x00000000 SQLINTEGER -6 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B0 SWORD 52 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B0 SWORD 52 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B0 SWORD 52 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B0 SWORD 52 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B0 SWORD 52 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B0 SWORD 52 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B4 SWORD 48 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x0364F0B4 SWORD 48 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetFunctions HDBC 01552B48 UWORD 999 UWORD * 0x02D4DF88 SQL Server Ente 144-b94 EXIT SQLGetFunctions with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 999 UWORD * 0x02D4DF88 (4294967294) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0364F32C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x0364F32C (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetConnectAttrW SQLHDBC 01552B48 SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG> SQLPOINTER 0x0364F140 SQLINTEGER 514 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 01552B48 SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG> SQLPOINTER 0x0364F140 SQLINTEGER 514 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 26 <SQL_DEFAULT_TXN_ISOLATION> PTR 0x0364F330 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 26 <SQL_DEFAULT_TXN_ISOLATION> PTR 0x0364F330 (2) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x03BE723C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 0 <SQL_ACTIVE_CONNECTIONS> PTR 0x03BE723C (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 114 <SQL_CATALOG_LOCATION> PTR 0x03BE72A4 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 114 <SQL_CATALOG_LOCATION> PTR 0x03BE72A4 (1) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 42 <SQL_CATALOG_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 42 <SQL_CATALOG_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (16) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 42 <SQL_CATALOG_TERM> PTR 0x02B93690 SWORD 18 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 42 <SQL_CATALOG_TERM> PTR 0x02B93690 SWORD 18 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 92 <SQL_CATALOG_USAGE> PTR 03BE730C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 92 <SQL_CATALOG_USAGE> PTR 03BE730C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 75 <SQL_NON_NULLABLE_COLUMNS> PTR 0x0364F0C8 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 75 <SQL_NON_NULLABLE_COLUMNS> PTR 0x0364F0C8 (1) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 22 <SQL_CONCAT_NULL_BEHAVIOR> PTR 0x03BE7374 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 22 <SQL_CONCAT_NULL_BEHAVIOR> PTR 0x03BE7374 (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (40) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x02B9B8E8 SWORD 42 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 2 <SQL_DATA_SOURCE_NAME> PTR 0x02B9B8E8 SWORD 42 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 25 <SQL_DATA_SOURCE_READ_ONLY> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 17 <SQL_DBMS_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 17 <SQL_DBMS_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (10) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 17 <SQL_DBMS_NAME> PTR 0x02B93A70 SWORD 12 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 17 <SQL_DBMS_NAME> PTR 0x02B93A70 SWORD 12 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 18 <SQL_DBMS_VER> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 18 <SQL_DBMS_VER> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (18) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 18 <SQL_DBMS_VER> PTR 0x02B93690 SWORD 20 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 18 <SQL_DBMS_VER> PTR 0x02B93690 SWORD 20 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 88 <SQL_GROUP_BY> PTR 0x03BE7478 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 88 <SQL_GROUP_BY> PTR 0x03BE7478 (3) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 28 <SQL_IDENTIFIER_CASE> PTR 0x03BE74E0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 28 <SQL_IDENTIFIER_CASE> PTR 0x03BE74E0 (4) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 102 <SQL_MAX_INDEX_SIZE> PTR 0x03BE7514 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 102 <SQL_MAX_INDEX_SIZE> PTR 0x03BE7514 (500) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 104 <SQL_MAX_ROW_SIZE> PTR 0x03BE7548 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 104 <SQL_MAX_ROW_SIZE> PTR 0x03BE7548 (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 103 <SQL_MAX_ROW_SIZE_INCLUDES_LONG> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 103 <SQL_MAX_ROW_SIZE_INCLUDES_LONG> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 106 <SQL_MAX_TABLES_IN_SELECT> PTR 0x03BE75B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 106 <SQL_MAX_TABLES_IN_SELECT> PTR 0x03BE75B0 (31) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 85 <SQL_NULL_COLLATION> PTR 0x03BE764C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 85 <SQL_NULL_COLLATION> PTR 0x03BE764C (2) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 90 <SQL_ORDER_BY_COLUMNS_IN_SELECT> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 90 <SQL_ORDER_BY_COLUMNS_IN_SELECT> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x03BE76E8 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR> PTR 0x03BE76E8 (2) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x03BE771C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR> PTR 0x03BE771C (2) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 40 <SQL_PROCEDURE_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 40 <SQL_PROCEDURE_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (0) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 40 <SQL_PROCEDURE_TERM> PTR 0x02B9EE10 SWORD 2 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 40 <SQL_PROCEDURE_TERM> PTR 0x02B9EE10 SWORD 2 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 93 <SQL_QUOTED_IDENTIFIER_CASE> PTR 0x03BE7820 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 93 <SQL_QUOTED_IDENTIFIER_CASE> PTR 0x03BE7820 (3) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 39 <SQL_OWNER_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 39 <SQL_OWNER_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (0) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 39 <SQL_OWNER_TERM> PTR 0x02B9EE10 SWORD 2 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 39 <SQL_OWNER_TERM> PTR 0x02B9EE10 SWORD 2 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 91 <SQL_OWNER_USAGE> PTR 03BE7888 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 91 <SQL_OWNER_USAGE> PTR 03BE7888 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 15 <SQL_ODBC_SQL_CONFORMANCE> PTR 0x0364F0C8 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 15 <SQL_ODBC_SQL_CONFORMANCE> PTR 0x0364F0C8 (1) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 73 <SQL_INTEGRITY> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 73 <SQL_INTEGRITY> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 95 <SQL_SUBQUERIES> PTR 03BE7924 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 95 <SQL_SUBQUERIES> PTR 03BE7924 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 45 <SQL_TABLE_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 45 <SQL_TABLE_TERM> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (10) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 45 <SQL_TABLE_TERM> PTR 0x02B93A70 SWORD 12 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 45 <SQL_TABLE_TERM> PTR 0x02B93A70 SWORD 12 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 47 <SQL_USER_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 47 <SQL_USER_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (8) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 47 <SQL_USER_NAME> PTR 0x02B93A70 SWORD 10 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 47 <SQL_USER_NAME> PTR 0x02B93A70 SWORD 10 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 36 <SQL_MULT_RESULT_SETS> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 36 <SQL_MULT_RESULT_SETS> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetConnectAttrW SQLHDBC 01552B48 SQLINTEGER 1209 <unknown> SQLPOINTER 0x0364F2F0 SQLINTEGER 4 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 01552B48 SQLINTEGER 1209 <unknown> SQLPOINTER 0x0364F2F0 SQLINTEGER 4 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 13 <SQL_SERVER_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 13 <SQL_SERVER_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (58) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 13 <SQL_SERVER_NAME> PTR 0x02B9A358 SWORD 60 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 13 <SQL_SERVER_NAME> PTR 0x02B9A358 SWORD 60 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetConnectAttrW SQLHDBC 01552B48 SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG> SQLPOINTER 0x0364F0D4 SQLINTEGER 514 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 01552B48 SQLINTEGER 109 <SQL_ATTR_CURRENT_CATALOG> SQLPOINTER 0x0364F0D4 SQLINTEGER 514 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 20 <SQL_ACCESSIBLE_PROCEDURES> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 20 <SQL_ACCESSIBLE_PROCEDURES> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 19 <SQL_ACCESSIBLE_TABLES> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 19 <SQL_ACCESSIBLE_TABLES> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 73 <SQL_INTEGRITY> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 73 <SQL_INTEGRITY> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 115 <SQL_OJ_CAPABILITIES> PTR 03295990 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 115 <SQL_OJ_CAPABILITIES> PTR 03295990 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 21 <SQL_PROCEDURES> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 21 <SQL_PROCEDURES> PTR 0x0364F0B0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (22) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x02B93690 SWORD 24 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 6 <SQL_DRIVER_NAME> PTR 0x02B93690 SWORD 24 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 7 <SQL_DRIVER_VER> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 7 <SQL_DRIVER_VER> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (16) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 7 <SQL_DRIVER_VER> PTR 0x02B93690 SWORD 18 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 7 <SQL_DRIVER_VER> PTR 0x02B93690 SWORD 18 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 77 <SQL_DRIVER_ODBC_VER> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 77 <SQL_DRIVER_ODBC_VER> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (10) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 77 <SQL_DRIVER_ODBC_VER> PTR 0x02B93A70 SWORD 12 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 77 <SQL_DRIVER_ODBC_VER> PTR 0x02B93A70 SWORD 12 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 113 <SQL_LIKE_ESCAPE_CLAUSE> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 113 <SQL_LIKE_ESCAPE_CLAUSE> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (2) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 113 <SQL_LIKE_ESCAPE_CLAUSE> PTR 0x02B9EE10 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 113 <SQL_LIKE_ESCAPE_CLAUSE> PTR 0x02B9EE10 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 94 <SQL_SPECIAL_CHARACTERS> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 94 <SQL_SPECIAL_CHARACTERS> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (66) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 94 <SQL_SPECIAL_CHARACTERS> PTR 0x02B8DE10 SWORD 68 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 94 <SQL_SPECIAL_CHARACTERS> PTR 0x02B8DE10 SWORD 68 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 97 <SQL_MAX_COLUMNS_IN_GROUP_BY> PTR 0x03295AFC SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 97 <SQL_MAX_COLUMNS_IN_GROUP_BY> PTR 0x03295AFC (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 98 <SQL_MAX_COLUMNS_IN_INDEX> PTR 0x03295B30 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 98 <SQL_MAX_COLUMNS_IN_INDEX> PTR 0x03295B30 (32) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 99 <SQL_MAX_COLUMNS_IN_ORDER_BY> PTR 0x03295B64 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 99 <SQL_MAX_COLUMNS_IN_ORDER_BY> PTR 0x03295B64 (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 100 <SQL_MAX_COLUMNS_IN_SELECT> PTR 0x03295B98 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 100 <SQL_MAX_COLUMNS_IN_SELECT> PTR 0x03295B98 (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 101 <SQL_MAX_COLUMNS_IN_TABLE> PTR 0x03295BCC SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 101 <SQL_MAX_COLUMNS_IN_TABLE> PTR 0x03295BCC (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 49 <SQL_NUMERIC_FUNCTIONS> PTR 03295C00 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 49 <SQL_NUMERIC_FUNCTIONS> PTR 03295C00 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 15 <SQL_ODBC_SQL_CONFORMANCE> PTR 0x03295C34 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 15 <SQL_ODBC_SQL_CONFORMANCE> PTR 0x03295C34 (1) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 38 <SQL_OUTER_JOINS> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 38 <SQL_OUTER_JOINS> PTR 0x00000000 SWORD 0 SWORD * 0x0364F0AC (2) SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 38 <SQL_OUTER_JOINS> PTR 0x02B9EE10 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 38 <SQL_OUTER_JOINS> PTR 0x02B9EE10 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 50 <SQL_STRING_FUNCTIONS> PTR 03295C9C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 50 <SQL_STRING_FUNCTIONS> PTR 03295C9C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 51 <SQL_SYSTEM_FUNCTIONS> PTR 03295CD0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 51 <SQL_SYSTEM_FUNCTIONS> PTR 03295CD0 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 52 <SQL_TIMEDATE_FUNCTIONS> PTR 03295D04 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 52 <SQL_TIMEDATE_FUNCTIONS> PTR 03295D04 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 84 <SQL_FILE_USAGE> PTR 0x03295D38 SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 84 <SQL_FILE_USAGE> PTR 0x03295D38 (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetInfoW HDBC 01552B48 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x03295D6C SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS) HDBC 01552B48 UWORD 1 <SQL_ACTIVE_STATEMENTS> PTR 0x03295D6C (0) SWORD 4 SWORD * 0x00000000 SQL Server Ente 144-b94 ENTER SQLAllocStmt HDBC 01552B48 HSTMT * 0364F35C SQL Server Ente 144-b94 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS) HDBC 01552B48 HSTMT * 0x0364F35C ( 0x015549e0) SQL Server Ente 144-b94 ENTER SQLSetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE> SQLPOINTER 0x0000000A SQLINTEGER 0 SQL Server Ente 144-b94 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE> SQLPOINTER 0x0000000A (BADMEM) SQLINTEGER 0 SQL Server Ente 144-b94 ENTER SQLSetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE> SQLPOINTER 0x00000000 SQLINTEGER 0 SQL Server Ente 144-b94 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 18 <SQL_ATTR_PARAM_BIND_TYPE> SQLPOINTER 0x00000000 SQLINTEGER 0 SQL Server Ente 144-b94 ENTER SQLSetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 17 <SQL_ATTR_PARAM_BIND_OFFSET_PTR> SQLPOINTER 0364F36C SQLINTEGER 0 SQL Server Ente 144-b94 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 17 <SQL_ATTR_PARAM_BIND_OFFSET_PTR> SQLPOINTER 0364F36C SQLINTEGER 0 SQL Server Ente 144-b94 ENTER SQLSetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 17 <SQL_ATTR_PARAM_BIND_OFFSET_PTR> SQLPOINTER 00000000 SQLINTEGER 0 SQL Server Ente 144-b94 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 17 <SQL_ATTR_PARAM_BIND_OFFSET_PTR> SQLPOINTER 00000000 SQLINTEGER 0 SQL Server Ente 144-b94 ENTER SQLGetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 10013 <unknown> SQLPOINTER [Unknown attribute 10013] SQLINTEGER 0 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 10013 <unknown> SQLPOINTER [Unknown attribute 10013] SQLINTEGER 0 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 10011 <unknown> SQLPOINTER [Unknown attribute 10011] SQLINTEGER 0 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 10011 <unknown> SQLPOINTER [Unknown attribute 10011] SQLINTEGER 0 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLSetDescFieldW SQLHDESC 01554B44 SQLSMALLINT 1 SQLSMALLINT 1004 <SQL_DESC_OCTET_LENGTH_PTR> SQLPOINTER 0364F36C SQLINTEGER 0 SQL Server Ente 144-b94 ENTER SQLSetDescField SQLHDESC 01554B44 SQLSMALLINT 1 SQLSMALLINT 1004 <SQL_DESC_OCTET_LENGTH_PTR> SQLPOINTER 0364F36C SQLINTEGER 0 SQL Server Ente 144-b94 EXIT SQLSetDescField with return code -1 (SQL_ERROR) SQLHDESC 01554B44 SQLSMALLINT 1 SQLSMALLINT 1004 <SQL_DESC_OCTET_LENGTH_PTR> SQLPOINTER 0364F36C SQLINTEGER 0 DIAG [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function (0) SQL Server Ente 144-b94 EXIT SQLSetDescFieldW with return code -1 (SQL_ERROR) SQLHDESC 01554B44 SQLSMALLINT 1 SQLSMALLINT 1004 <SQL_DESC_OCTET_LENGTH_PTR> SQLPOINTER 0364F36C SQLINTEGER 0 DIAG [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function (0) SQL Server Ente 144-b94 ENTER SQLGetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 6 <SQL_CURSOR_TYPE> SQLPOINTER 0x0364F2C8 SQLINTEGER -5 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 6 <SQL_CURSOR_TYPE> SQLPOINTER 0x0364F2C8 (0) SQLINTEGER -5 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 7 <SQL_CONCURRENCY> SQLPOINTER 0x0364F2C4 SQLINTEGER -5 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 7 <SQL_CONCURRENCY> SQLPOINTER 0x0364F2C4 (3) SQLINTEGER -5 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLGetConnectAttrW SQLHDBC 01552B48 SQLINTEGER 108 <SQL_ATTR_TXN_ISOLATION> SQLPOINTER 0x0364F2C0 SQLINTEGER 4 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 01552B48 SQLINTEGER 108 <SQL_ATTR_TXN_ISOLATION> SQLPOINTER 0x0364F2C0 SQLINTEGER 4 SQLINTEGER * 0x00000000 SQL Server Ente 144-b94 ENTER SQLSetStmtAttrW SQLHSTMT 015549E0 SQLINTEGER 7 <SQL_ATTR_CONCURRENCY> SQLPOINTER 0x00000001 SQLINTEGER -6 SQL Server Ente 144-b94 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS) SQLHSTMT 015549E0 SQLINTEGER 7 <SQL_ATTR_CONCURRENCY> SQLPOINTER 0x00000001 (BADMEM) SQLINTEGER -6 SQL Server Ente 144-b94 ENTER SQLParamOptions HSTMT 015549E0 SQLULEN 1 SQLULEN * 0x00000000 SQL Server Ente 144-b94 EXIT SQLParamOptions with return code 0 (SQL_SUCCESS) HSTMT 015549E0 SQLULEN 1 SQLULEN * 0x00000000 SQL Server Ente 144-b94 ENTER SQLExecDirectW HSTMT 015549E0 WCHAR * 0x02B93020 [ 27] "select * from `test`.`test`" SDWORD 27 SQL Server Ente 144-b94 EXIT SQLExecDirectW with return code 0 (SQL_SUCCESS) HSTMT 015549E0 WCHAR * 0x02B93020 [ 27] "select * from `test`.`test`" SDWORD 27 SQL Server Ente 144-b94 ENTER SQLGetDiagFieldW SQLSMALLINT 3 SQLHANDLE 015549E0 SQLSMALLINT 0 SQLSMALLINT -1249 SQLPOINTER 0x0364F2B0 SQLSMALLINT 4 SQLSMALLINT * 0x00000000 SQL Server Ente 144-b94 EXIT SQLGetDiagFieldW with return code 0 (SQL_SUCCESS) SQLSMALLINT 3 SQLHANDLE 015549E0 SQLSMALLINT 0 SQLSMALLINT -1249 SQLPOINTER 0x0364F2B0 SQLSMALLINT 4 SQLSMALLINT * 0x00000000 SQL Server Ente 144-b94 ENTER SQLRowCount HSTMT 015549E0 SQLLEN * 0x0364F2B4 SQL Server Ente 144-b94 EXIT SQLRowCount with return code 0 (SQL_SUCCESS) HSTMT 015549E0 SQLLEN * 0x0364F2B4 (0) SQL Server Ente 144-b94 ENTER SQLNumResultCols HSTMT 015549E0 SWORD * 0x0364F2F8 SQL Server Ente 144-b94 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS) HSTMT 015549E0 SWORD * 0x0364F2F8 (2) SQL Server Ente 144-b94 ENTER SQLNumResultCols HSTMT 015549E0 SWORD * 0x0364EE48 SQL Server Ente 144-b94 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS) HSTMT 015549E0 SWORD * 0x0364EE48 (2) SQL Server Ente 144-b94 ENTER SQLDescribeColW HSTMT 015549E0 UWORD 1 WCHAR * 0x00000000 SWORD 0 SWORD * 0x00000000 SWORD * 0x0364EE68 SQLULEN * 0x0364EE74 SWORD * 0x0364F28A SWORD * 0x0364EE5C SQL Server Ente 144-b94 EXIT SQLDescribeColW with return code 1 (SQL_SUCCESS_WITH_INFO) HSTMT 015549E0 UWORD 1 WCHAR * 0x00000000 SWORD 0 SWORD * 0x00000000 SWORD * 0x0364EE68 (4) SQLULEN * 0x0364EE74 (11) SWORD * 0x0364F28A (0) SWORD * 0x0364EE5C (0) SQL Server Ente 144-b94 ENTER SQLColAttributesW HSTMT 015549E0 UWORD 1 UWORD 18 <SQL_DESC_LABEL> PTR 0x0364EE78 SWORD 1024 SWORD * 0x0364EE50 SQLLEN * 0x00000000 SQL Server Ente 144-b94 EXIT SQLColAttributesW with return code 0 (SQL_SUCCESS) HSTMT 015549E0 UWORD 1 UWORD 18 <SQL_DESC_LABEL> PTR 0x0364EE78 SWORD 1024 SWORD * 0x0364EE50 (4) SQLLEN * 0x00000000 SQL Server Ente 144-b94 ENTER SQLColAttributesW HSTMT 015549E0 UWORD 1 UWORD 8 <SQL_DESC_UNSIGNED> PTR 0x00000000 SWORD 0 SWORD * 0x00000000 SQLLEN * 0x0364EE70 SQL Server Ente 144-b94 EXIT SQLColAttributesW with return code 0 (SQL_SUCCESS) HSTMT 015549E0 UWORD 1 UWORD 8 <SQL_DESC_UNSIGNED> PTR 0x00000000 SWORD 0 SWORD * 0x00000000 SQLLEN * 0x0364EE70 (0) SQL Server Ente 144-b94 ENTER SQLColAttributesW HSTMT 015549E0 UWORD 1 UWORD 10 <SQL_DESC_UPDATABLE> PTR 0x00000000 SWORD 0 SWORD * 0x0364EE58 SQLLEN * 0x0364EE70 SQL Server Ente 144-b94 EXIT SQLColAttributesW with return code 0 (SQL_SUCCESS) HSTMT 015549E0 UWORD 1 UWORD 10 <SQL_DESC_UPDATABLE> PTR 0x00000000 SWORD 0 SWORD * 0x0364EE58 (1) SQLLEN * 0x0364EE70 (1) SQL Server Ente 144-b94 ENTER SQLDescribeColW HSTMT 015549E0 UWORD 2 WCHAR * 0x00000000 SWORD 0 SWORD * 0x00000000 SWORD * 0x0364EE68 SQLULEN * 0x0364EE74 SWORD * 0x0364F28A SWORD * 0x0364EE5C SQL Server Ente 144-b94 EXIT SQLDescribeColW with return code 1 (SQL_SUCCESS_WITH_INFO) HSTMT 015549E0 UWORD 2 WCHAR * 0x00000000 SWORD 0 SWORD * 0x00000000 SWORD * 0x0364EE68 (-1) SQLULEN * 0x0364EE74 (65535) SWORD * 0x0364F28A (0) SWORD * 0x0364EE5C (1) SQL Server Ente 144-b94 ENTER SQLColAttributesW HSTMT 015549E0 UWORD 2 UWORD 18 <SQL_DESC_LABEL> PTR
[6 Oct 2003 1:18]
Venu Anuganti
Atlast, am able to reproduce this behaviour now. Will fix this in 3.51.07 Thanks
[22 Jun 2004 18:02]
Peter Harvey
I have just tested with MyODBC v3.51.8, MySQL v4.0.18 and SQL Server v7.0 using the Northwind database with particular focus upon the Customers table (as a working example) and the Employees table (as a problem table). The only problem I noticed was that a few tables could not be exported due to having 'image' and/or 'ntext' columns. This 'could' work as MyODBC escapes blob data to allow them to be used in SQL statements. Some searching the web with the error message revealed that people were having this problem with MySQL and other databases such as Sybase. The only solution found was to export to MS Access and then export from there to MySQL. I spent considerable time browsing megs of ODBC trace output without coming to a conclusion as to why the export in MS SQL Enterprise Manager (MSE) fails to export blob data. It appears to be some logic hidden from view or otherwise not easily extracted from the ODBC trace. My suggestion is to revisit this bug once MyODBC 3.53 arrives and goes 'stable' as it includes support for more ODBC features. In the meantime people should consider trying to use MS Access as a conduit for tables with image/text/blob data.
[21 Jul 2004 19:13]
Timothy Smith
This bug seems to result from complex interactions between Enterprise Manager and the incomplete feature set of MyODBC 3.51. A workaround of using MS Access to pass data between MySQL and MS SQL is possible. MyODBC 3.53, which is in development now, will support the full ODBC spec, and will address this problem inherently. So I am marking this bug as "Deferred" until 3.53 comes out.
[2 Aug 2004 15:15]
Kerr Schere
I finally found this bug after searching for hours on a way to use DTS for a MySQL import using text/blob images. Many thanks for the Access linked tables tip. It's been so many years since I've used Access that I didn't even think of that as an option.
[15 Oct 2004 12:58]
[ name withheld ]
I made the dts to work changing the source to an sql statement converting the data to long varchar: select column_a, column_b, convert(long varchar, column_c) as column_c from troublesome_table Hope this helps somebody
[8 Dec 2005 17:09]
Bogdan Degtyariov
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ Additional info: This bug has been fixed in v.3.51.12
[18 Jan 2006 15:03]
Stefano Giammarino
Hi, I've just got a requierment to automate data transfert from MS Access to MySql (v. 4.0.18, upgrade not allowed/possible) and I also wanted to use DTS package to do the transfert. I'm using myodbc 3.51.12.00 and I get the same error message that I can't transfert to blob. Any idea would be welcome. Thanks Stefano