MS ACCESS error on 64bit application

[massimoz]

Hi to all.
I'm evaluating the UniDAC components suite on a Windows7 64Bits environment, with Delphi XE2 Update4 IDE.

I have to connect to MsAccess MDB database. I created a small test application with:
UniConnection, UniTable and Uniconnectiondialog dropped to form.
I set:
Conn.ProviderName := 'Access';
Conn.Username := '';
Conn.Password := ''; // no password
Conn.Server := '';
Conn.Database := 'myFolder\MyDatabase.MDB';
Tbl.TableName := 'TheTableName';

When I compile to a Win32 application all work fine.

When I compile to a Win64 application the following error is generated:
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."
when I try to connect.

What's wrong?

I also tried the same with a MsSQL database and in this case all works fine (in Win64 too).
Only Access fails.

Thanks in advance.
Massimo Zanoletti

[AlexP]

hello,

Microsoft doesn't allow to have 2 ODBCs drivers (x32 and x64) simultaneously on one OS, this is a Microsoft limitation. If you need to create a 64-bit application, you should remove the 32-bit driver and install a 64-bit one.

[massimoz]

Hello.

Thanks for answwer.
I didn't install any ODBC driver. I just installed the O.S., the development environment (Delphi XE2) and UniDAC components.

How can I remove the 32bit version and install the 64bit one? (and where can I find it?)

Massimo Zanoletti

[AlexP]

hello,

You can download both driver versions (x32 and x64) from the official site of Microsoft

http://www.microsoft.com/en-us/download ... n&id=13255

[massimoz]

Thanks so much for your answer.
After dowloaded and installed, now works fine.

Just a question: this means that on a Windows7 64bits is automatically installed the 32bit version of drivers (I didn't install any driver to connect with a 32bits application).
Vice-versa the 64bits driver must be manually installed.
Is it right?

Massimo.

[AlexP]

hello,

32-bit MS Access ODBC driver is installed when you install Windows 7 x64, 64-bit version of the driver has to be installed independently.