If you encounter difficulties with MyODBC, you should start by making a
log file from the ODBC manager (the log you get when requesting logs
from ODBCADMIN) and a MyODBC log. To get a MyODBC log,
tag the `Trace MyODBC' option flag in the MyODBC
connect/configure screen. The log will be written to file
`C:\myodbc.log'. Note that you must use
Check the queries that MyODBC sends to the MySQL server; You
should be able to find this by searching after the string
You should also try duplicating the queries in the
If you find out something is wrong, please only send the relevant rows (max 40 rows) to the email@example.com. Please never send the whole MyODBC or ODBC log file !
If you are unable to find out whats wrong, the last option is to to make a archive (tar or zip) that contains a MyODBC log file, the ODBC log file and a README file that explains the problem. You can send this to ftp://www.mysql.com/pub/mysql/secret. Only we at TCX will have access to the files you upload and we will be very discrete with the data!.
If you can create a program that also shows this problem, please upload this too!
If the program works with some other SQL server, you should make a ODBC log file where you do exactly the same thing in the other SQL server.
Remember that the more information you can supply to us, the more likely it is that we can fix the problem!