Re: ODBC insert on a linked table failed

[Jay Alverson]

If you're using a DSN, find that one in the ODBC Manager and open it.

Click DETAILS button and Look on the DEBUG tab it offers "Log queries to myodbc.sql"

and see if the full error is present in that file.

http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-connection-parameters.html

Go down to option #4

4 	FLAG_DEBUG 	Trace Driver Calls To myodbc.log 	

Make a debug log in C:\myodbc.log on Windows, or /tmp/myodbc.log on Unix
variants. This option was removed in Connector/ODBC 3.51.18.

See if more info show up there.

If not, google for your exact error message.

>

Thanks, Jay