Re: [Iodbc-applications] iodbctest -- Failed to query mysql database

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Wang,

Why does your MySQL driver report its version as 3.52, should it not  
be 5.1:

root@sms-frr # /usr/local/bin/iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0607.1008
Enter ODBC connect string (? shows list): ?
DSN                              | Driver
------------------------------------------------------------------------ 
------
test                             | Mysql ODBC 5.1 Driver DSN
Enter ODBC connect string (? shows list): test
Driver: 03.52 (03.52)

I downloaded the myodbc driver for Mac OS X from the same location  
and it installed a 5.1 version of the ODBC driver as you would  
expect, which I could query our MySQL 5 test database with. I also  
had an old  3.51 version of the driver on my machine which also  
worked, see:

./odbctest "DSN=myodbc"
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
Driver: 05.01.0005 (libmyodbc5.so)

SQL>show tables;

Tables_in_mysql
----------------------------------------------------------------
aaa
account
billing
bindoffset
bindoffsetparamtest
boomark_test_table
branch
.
.
.

  result set 1 returned 122 rows.

SQL>select * from branch;

BRANCH     |FILLERINT  |BALANCE  |FILLER
-----------+-----------+--------- 
+----------------------------------------------------------------------- 
-------------
1          |1          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
2          |2          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
3          |3          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
4          |4          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
5          |5          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
6          |6          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
7          |7          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
8          |8          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
9          |9          |1000     | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff
10         |10         |955      | 
ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff 
ffffffffffff

  result set 1 returned 10 rows.

SQL>

Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support

On 28 Aug 2008, at 14:38, WangFei wrote:

> Hi Tim,
>
> The Mysql ODBC connector is download from mysql website
> http://dev.mysql.com/downloads/connector/odbc/5.1.html#solaris-pgadd
>
> Below is the content of the trace log (also attached). Thanks!
>
> ** iODBC Trace file
> ** Trace started on Thu Aug 28 16:16:10 2008
> ** Driver Manager: 03.52.0607.1008
>
> [000000.000683]
> Application     00000001 ENTER SQLAllocHandle
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHANDLE         0x0 (SQL_NULL_HANDLE)
>   SQLHANDLE       * 67d50
> [000000.000750]
> Application     00000001 EXIT  SQLAllocHandle with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHANDLE         0x0 (SQL_NULL_HANDLE)
>   SQLHANDLE       * 67d50 (68f28)
> [000000.000798]
> Application     00000001 ENTER SQLSetEnvAttr
>   SQLHENV           68f28
>   SQLINTEGER        200 (SQL_ATTR_ODBC_VERSION)
>   SQLPOINTER        3
>   SQLINTEGER      * -5 (SQL_IS_UINTEGER)
> [000000.000859]
> Application     00000001 EXIT  SQLSetEnvAttr with return code 0  
> (SQL_SUCCESS)
>   SQLHENV           68f28
>   SQLINTEGER        200 (SQL_ATTR_ODBC_VERSION)
>   SQLPOINTER        3
>   SQLINTEGER      * -5 (SQL_IS_UINTEGER)
> [000000.000914]
> Application     00000001 ENTER SQLAllocHandle
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHANDLE         68f28
>   SQLHANDLE       * 67d4c
> [000000.001089]
> Application     00000001 EXIT  SQLAllocHandle with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHANDLE         68f28
>   SQLHANDLE       * 67d4c (6c7b8)
> [000000.001139]
> Application     00000001 ENTER SQLSetConnectOption
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      1051 (unknown connection attribute)
>   SQLLEN            305160
> [000000.001190]
> Application     00000001 EXIT  SQLSetConnectOption with return code  
> 0 (SQL_SUCCESS)
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      1051 (unknown connection attribute)
>   SQLLEN            305160
> [000000.001305]
> Application     00000001 ENTER SQLGetInfo
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      171 (SQL_DM_VER)
>   SQLPOINTER        ffbff500
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff306
> [000000.001376]
> Application     00000001 EXIT  SQLGetInfo with return code 0  
> (SQL_SUCCESS)
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      171 (SQL_DM_VER)
>   SQLPOINTER        ffbff500
>       | 03.52.0607.1008                          |
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff306 (15)
> [000001.697973]
> Application     00000001 ENTER SQLDataSources
>   SQLHENV           68f28
>   SQLUSMALLINT      2 (SQL_FETCH_FIRST)
>   SQLCHAR         * ffbff700
>   SQLSMALLINT       33
>   SQLSMALLINT     * ffbff306
>   SQLCHAR         * ffbff600
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff304
> [000001.698542]
> Application     00000001 EXIT  SQLDataSources with return code 0  
> (SQL_SUCCESS)
>   SQLHENV           68f28
>   SQLUSMALLINT      2 (SQL_FETCH_FIRST)
>   SQLCHAR         * ffbff700
>       | test                                     |
>   SQLSMALLINT       33
>   SQLSMALLINT     * ffbff306 (4)
>   SQLCHAR         * ffbff600
>       | Mysql ODBC 5.1 Driver DSN                |
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff304 (25)
> [000001.698774]
> Application     00000001 ENTER SQLDataSources
>   SQLHENV           68f28
>   SQLUSMALLINT      1 (SQL_FETCH_NEXT)
>   SQLCHAR         * ffbff700
>   SQLSMALLINT       33
>   SQLSMALLINT     * ffbff306
>   SQLCHAR         * ffbff600
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff304
> [000001.698921]
> Application     00000001 EXIT  SQLDataSources with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLHENV           68f28
>   SQLUSMALLINT      1 (SQL_FETCH_NEXT)
>   SQLCHAR         * ffbff700
>   SQLSMALLINT       33
>   SQLSMALLINT     * ffbff306
>   SQLCHAR         * ffbff600
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff304
> [000003.887549]
> Application     00000001 ENTER SQLDriverConnect
>   SQLHDBC           6c7b8
>   SQLPOINTER        0x0
>   SQLCHAR         * ffbff728
>       | test                                     |
>   SQLSMALLINT       -3 (SQL_NTS)
>   SQLCHAR         * 67f18
>   SQLSMALLINT       4096
>   SQLSMALLINT     * ffbff302
>   SQLUSMALLINT      1 (SQL_DRIVER_COMPLETE)
> [000003.936941]
> Application     00000001 EXIT  SQLDriverConnect with return code 0  
> (SQL_SUCCESS)
>   SQLHDBC           6c7b8
>   SQLPOINTER        0x0
>   SQLCHAR         * ffbff728
>   SQLSMALLINT       -3 (SQL_NTS)
>   SQLCHAR         * 67f18
>   SQLSMALLINT       4096
>   SQLSMALLINT     * ffbff302 (0)
>   SQLUSMALLINT      1 (SQL_DRIVER_COMPLETE)
> [000003.937219]
> Application     00000001 ENTER SQLGetInfo
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      7 (SQL_DRIVER_VER)
>   SQLPOINTER        ffbff500
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff306
> [000003.937318]
> Application     00000001 EXIT  SQLGetInfo with return code 0  
> (SQL_SUCCESS)
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      7 (SQL_DRIVER_VER)
>   SQLPOINTER        ffbff500
>       | 03.52                                    |
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff306 (5)
> [000003.937425]
> Application     00000001 ENTER SQLGetInfo
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      6 (SQL_DRIVER_NAME)
>   SQLPOINTER        ffbff500
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff306
> [000003.937496]
> Application     00000001 EXIT  SQLGetInfo with return code 0  
> (SQL_SUCCESS)
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      6 (SQL_DRIVER_NAME)
>   SQLPOINTER        ffbff500
>       | 03.52                                    |
>   SQLSMALLINT       255
>   SQLSMALLINT     * ffbff306 (7)
> [000003.937684]
> Application     00000001 ENTER SQLGetFunctions
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      999 (SQL_API_ODBC3_ALL_FUNCTIONS)
> [000003.937747]
> Application     00000001 EXIT  SQLGetFunctions with return code 0  
> (SQL_SUCCESS)
>   SQLHDBC           6c7b8
>   SQLUSMALLINT      999 (SQL_API_ODBC3_ALL_FUNCTIONS)
>   SQLUSMALLINT    * ffbff308
>       | SQL_API_SQLALLOCCONNECT                  |
>       | SQL_API_SQLALLOCENV                      |
>       | SQL_API_SQLALLOCSTMT                     |
>       | SQL_API_SQLBINDCOL                       |
>       | SQL_API_SQLCANCEL                        |
>       | SQL_API_SQLCOLATTRIBUTE                  |
>       | SQL_API_SQLCONNECT                       |
>       | SQL_API_SQLDESCRIBECOL                   |
>       | SQL_API_SQLDISCONNECT                    |
>       | SQL_API_SQLERROR                         |
>       | SQL_API_SQLEXECDIRECT                    |
>       | SQL_API_SQLEXECUTE                       |
>       | SQL_API_SQLFETCH                         |
>       | SQL_API_SQLFREECONNECT                   |
>       | SQL_API_SQLFREEENV                       |
>       | SQL_API_SQLFREESTMT                      |
>       | SQL_API_SQLGETCURSORNAME                 |
>       | SQL_API_SQLNUMRESULTCOLS                 |
>       | SQL_API_SQLPREPARE                       |
>       | SQL_API_SQLROWCOUNT                      |
>       | SQL_API_SQLSETCURSORNAME                 |
>       | SQL_API_SQLSETPARAM                      |
>       | SQL_API_SQLTRANSACT                      |
>       | SQL_API_SQLBULKOPERATIONS                |
>       | SQL_API_SQLCOLUMNS                       |
>       | SQL_API_SQLDRIVERCONNECT                 |
>       | SQL_API_SQLGETCONNECTOPTION              |
>       | SQL_API_SQLGETDATA                       |
>       | SQL_API_SQLGETFUNCTIONS                  |
>       | SQL_API_SQLGETINFO                       |
>       | SQL_API_SQLGETSTMTOPTION                 |
>       | SQL_API_SQLGETTYPEINFO                   |
>       | SQL_API_SQLPARAMDATA                     |
>       | SQL_API_SQLPUTDATA                       |
>       | SQL_API_SQLSETCONNECTOPTION              |
>       | SQL_API_SQLSETSTMTOPTION                 |
>       | SQL_API_SQLSPECIALCOLUMNS                |
>       | SQL_API_SQLSTATISTICS                    |
>       | SQL_API_SQLTABLES                        |
>       | SQL_API_SQLBROWSECONNECT                 |
>       | SQL_API_SQLCOLUMNPRIVILEGES              |
>       | SQL_API_SQLDATASOURCES                   |
>       | SQL_API_SQLDESCRIBEPARAM                 |
>       | SQL_API_SQLEXTENDEDFETCH                 |
>       | SQL_API_SQLFOREIGNKEYS                   |
>       | SQL_API_SQLMORERESULTS                   |
>       | SQL_API_SQLNATIVESQL                     |
>       | SQL_API_SQLNUMPARAMS                     |
>       | SQL_API_SQLPARAMOPTIONS                  |
>       | SQL_API_SQLPRIMARYKEYS                   |
>       | SQL_API_SQLPROCEDURECOLUMNS              |
>       | SQL_API_SQLPROCEDURES                    |
>       | SQL_API_SQLSETPOS                        |
>       | SQL_API_SQLSETSCROLLOPTIONS              |
>       | SQL_API_SQLTABLEPRIVILEGES               |
>       | SQL_API_SQLDRIVERS                       |
>       | SQL_API_SQLBINDPARAMETER                 |
> [000003.939449]
> Application     00000001 ENTER SQLAllocHandle
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHANDLE         6c7b8
>   SQLHANDLE       * 67d48
> [000003.939793]
> Application     00000001 EXIT  SQLAllocHandle with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHANDLE         6c7b8
>   SQLHANDLE       * 67d48 (78788)
> [000011.287144]
> Application     00000001 ENTER SQLPrepare
>   SQLHSTMT          78788
>   SQLCHAR         * ffbfeb28
>       | show tables;                             |
>   SQLINTEGER        -3 (SQL_NTS)
> [000011.287329]
> Application     00000001 EXIT  SQLPrepare with return code 0  
> (SQL_SUCCESS)
>   SQLHSTMT          78788
>   SQLCHAR         * ffbfeb28
>   SQLINTEGER        -3 (SQL_NTS)
> [000011.287386]
> Application     00000001 ENTER SQLExecute
>   SQLHSTMT          78788
> [000011.287821]
> Application     00000001 EXIT  SQLExecute with return code -1  
> (SQL_ERROR)
>   SQLHSTMT          78788
> [000011.287866]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288001]
> Application     00000001 EXIT  SQLGetDiagRec with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>       | (empty string)                           |
>   SQLINTEGER      * ffbfd3bc (1065)
>   SQLCHAR         * ffbfd3d0
>       | (empty string)                           |
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288289]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       2
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288417]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       2
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288511]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288604]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288715]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000011.288806]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.928633]
> Application     00000001 ENTER SQLPrepare
>   SQLHSTMT          78788
>   SQLCHAR         * ffbfeb28
>       | select * from t                          |
>   SQLINTEGER        -3 (SQL_NTS)
> [000020.928814]
> Application     00000001 EXIT  SQLPrepare with return code 0  
> (SQL_SUCCESS)
>   SQLHSTMT          78788
>   SQLCHAR         * ffbfeb28
>   SQLINTEGER        -3 (SQL_NTS)
> [000020.928932]
> Application     00000001 ENTER SQLExecute
>   SQLHSTMT          78788
> [000020.929244]
> Application     00000001 EXIT  SQLExecute with return code -1  
> (SQL_ERROR)
>   SQLHSTMT          78788
> [000020.929289]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.929410]
> Application     00000001 EXIT  SQLGetDiagRec with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>       | (empty string)                           |
>   SQLINTEGER      * ffbfd3bc (1065)
>   SQLCHAR         * ffbfd3d0
>       | (empty string)                           |
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.930033]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       2
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.930172]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       2
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.930265]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.930361]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.930490]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000020.930580]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.925305]
> Application     00000001 ENTER SQLPrepare
>   SQLHSTMT          78788
>   SQLCHAR         * ffbfeb28
>       | use test                                 |
>   SQLINTEGER        -3 (SQL_NTS)
> [000027.925525]
> Application     00000001 EXIT  SQLPrepare with return code 0  
> (SQL_SUCCESS)
>   SQLHSTMT          78788
>   SQLCHAR         * ffbfeb28
>   SQLINTEGER        -3 (SQL_NTS)
> [000027.925630]
> Application     00000001 ENTER SQLExecute
>   SQLHSTMT          78788
> [000027.926003]
> Application     00000001 EXIT  SQLExecute with return code -1  
> (SQL_ERROR)
>   SQLHSTMT          78788
> [000027.926057]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.926182]
> Application     00000001 EXIT  SQLGetDiagRec with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>       | (empty string)                           |
>   SQLINTEGER      * ffbfd3bc (1065)
>   SQLCHAR         * ffbfd3d0
>       | (empty string)                           |
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.926463]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       2
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.926699]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
>   SQLSMALLINT       2
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.926793]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.926886]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.927030]
> Application     00000001 ENTER SQLGetDiagRec
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000027.927119]
> Application     00000001 EXIT  SQLGetDiagRec with return code 100  
> (SQL_NO_DATA_FOUND)
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
>   SQLSMALLINT       1
>   SQLCHAR         * ffbfd3c0
>   SQLINTEGER      * ffbfd3bc
>   SQLCHAR         * ffbfd3d0
>   SQLSMALLINT       512
>   SQLSMALLINT     * 0x0
> [000030.552761]
> Application     00000001 ENTER SQLCloseCursor
>   SQLHSTMT          78788
> [000030.552920]
> Application     00000001 EXIT  SQLCloseCursor with return code 0  
> (SQL_SUCCESS)
>   SQLHSTMT          78788
> [000030.552958]
> Application     00000001 ENTER SQLFreeHandle
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
> [000030.553105]
> Application     00000001 EXIT  SQLFreeHandle with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       3 (SQL_HANDLE_STMT)
>   SQLHSTMT          78788
> [000030.553155]
> Application     00000001 ENTER SQLDisconnect
>   SQLHDBC           6c7b8
> [000030.553531]
> Application     00000001 EXIT  SQLDisconnect with return code 0  
> (SQL_SUCCESS)
>   SQLHDBC           6c7b8
> [000030.553622]
> Application     00000001 ENTER SQLFreeHandle
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
> [000030.553744]
> Application     00000001 EXIT  SQLFreeHandle with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       2 (SQL_HANDLE_DBC)
>   SQLHDBC           6c7b8
> [000030.553792]
> Application     00000001 ENTER SQLFreeHandle
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
> [000030.553833]
> Application     00000001 EXIT  SQLFreeHandle with return code 0  
> (SQL_SUCCESS)
>   SQLSMALLINT       1 (SQL_HANDLE_ENV)
>   SQLHENV           68f28
> ** Trace finished on Thu Aug 28 16:16:41 2008
>
>
>
>
> >
> > Hi,
> >
> > Where did you get your MySQL ODBC Connector package from? If you  
> compiled
> > it yourself, did you run
> > ./configure --with-iodbc-includes= --with-iodbc-libs=
> > with appropriate directories?
> >
> > Can you also attach a *complete* ODBC trace showing the  
> SQLDriverConnect(),
> > and SQLExecDirect() or SQLExecute() calls, not just the  
> SQLGetDiagRec()
> > bits off the end please?
> >
> > Thanks,
> >
> > ~Tim
> > --
> > Tim Haynes
> > Product Development Consultant
> > OpenLink Software
> > <http://www.openlinksw.com/>
>
>
>
> Windows Live Writer，支持离线撰写博客内容，随时随地 
> 想写就写。 立即使用！<mytrace.log>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/ 
> _______________________________________________
> Iodbc-applications mailing list
> Iod...@li...
> https://lists.sourceforge.net/lists/listinfo/iodbc-applications