I am using the MySQL ODBC driver on a Windows Server 2008 R2 64-bit box. I enabled the debug feature on the odbc driver using the ODBC administrator at %windir%\SysWOW64\odbcad32.exe It does write queries to the c:\myodbc.sql file, but each time a new query appears it overwrites the file with the new query instead of appending the query to file each time a query is run. I made sure Tracing is off as well. I'm not sure what to do here. Is this normal behavior? I used the ODBC driver off of the MySQL website. Any help would be great. Thanks!


Ok This seems to be only a problem with the MySQL ODBC 5.1 Driver on a 64-Bit windows. On a 32-bit Windows 2003 Server R2 the myodbc.sql file writes correctly and the queries append correctly as well. I just moved my application to use that Windows 32-bit Server instead.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.