ODBC Problem

Post Reply
Jamesnic7
Newbie
Posts: 6
Joined: Sat Dec 31, 2016 3:21 pm

ODBC Problem

Post 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]."

:?
freddyp
Advanced member
Posts: 413
Joined: Thu Feb 09, 2012 3:53 pm

Re: ODBC Problem

Post 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).
Jamesnic7
Newbie
Posts: 6
Joined: Sat Dec 31, 2016 3:21 pm

Re: ODBC Problem

Post by Jamesnic7 »

Hi

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

Cheers
Post Reply