Page 1 of 1

ODBC Problem

Posted: Thu Feb 23, 2017 2:29 pm
by Jamesnic7
Hi

Just updated to the new 2017 version and I can no longer connect to our SQL Server database.
Using SysWOW64/odbcad32 and database "TharsternPRIMO".
Everything was fine until the update now.
Anybody else having a similar problem or have a solution?

Error is "Database error is [ [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application QODBC3: Unable to connect]."

:?

Re: ODBC Problem

Posted: Thu Feb 23, 2017 2:52 pm
by freddyp
Switch 2017 is now completely 64-bit, which means that you also have to change the database driver to the 64-bit version. It is in the release notes :)

Loading the 64-bit driver is not done with odbcad32.exe, but with the regular Control Panel - Administrative tools - Data sources (ODBC).

Re: ODBC Problem

Posted: Thu Feb 23, 2017 4:23 pm
by Jamesnic7
Hi

So what your saying is RTFM....
All OK now I think :D

Cheers