Problem on 32bit apps (MDB) access 64bit apps (ODBC)

[wlsiew]

Hi all,

I am having problem 32bit apps (MDB) access 64bit apps (ODBC) in a web apps.

Here is the scenario: -

MS Access MDB 32 bit
ODBC 64 bit
ASP pages

I can't create a MDB connection in ODBC. Anyone facing the same problem?

Regards,
WL Siew

[Wendor]

32 bit ODBC and 64 bit ODBC are completely different subsystems under 64 bit Windows.

32 bit apps need 32 bit DSN's created.

So instead of using the normal ODBC Administrator, you have to use the 32 bit ODBC Administrator.

It is normally located at "C:\WINDOWS\SysWOW64\odbcad32.exe" (that location will of course vary based on where the system directory is in a Windows VPS (haven't looked at one yet myself)

[wlsiew]

I had tried this C:\WINDOWS\SysWOW64\odbcad32.exe command and managed to add the DSN but when I tried to login in the web apps, it give the same error.

[Wendor]

Originally Posted by wlsiew

... it give the same error.

Since you haven't said what the error message was, it makes it a lot harder to help.