ODBC Database Sample Lesson not working

[jstarkman]

Hi,

I haven't posted for a while... hopefully somebody can assist.

I've not used ODBC to connect to a database before. I'm trying to get the Sample lesson working, but am getting the following error:

"The specified DSN contains an architecture mismatch between the Driver and Application". Does anybody know what causes this?

Thanks,

Joel

[Mikey]

Switch to using the 32-bit odbc connector. This is a well-known problem, so for whatever DB you're using, if you hit their forums, there will be discussions about it.

[jstarkman]

Hi Mikey,

Thanks. That was the issue, and your suggestion resolved it. Thanks again.

Joel