Unidac access database connection

[kncs31]

I create a simple application to test UNIDAC possibilities.

Compilation environnement :
- Windows seven (x64)
- Rad studio XE
- Unidac 4.6.12

I don't have any problems on my computer and some others. But for a couple of computers there is an error during the connection when I run the same executable.
All these computers have got seven x64 as operating system with Office 2010 installed.

See below my connection function :

void __fastcall TForm1::ConnectToAccessFile(UnicodeString FileName, UnicodeString Username, UnicodeString Password)
{
FConnection = new TUniConnection(this);
FConnection->ProviderName = "Access";
FConnection->Database = FileName;
FConnection->Username = Username;
FConnection->Password = Password;
FConnection->LoginPrompt = false;
FConnection->Connected = true;
}

Is anybody have a solution?

[AlexP]

Hello,

MS Windows doesn't allow to simultaneously install two versions of MS Access ODBC driver (x32 and x64), therefore, depending on the format of the appliacation (x32 or x64) you are developing, a corresponding client should be installed on your computer for the possibility to connect to a MS Access DB

[kncs31]

Hello AlexP,
Thanks for you reply.

We tried to solve connection problem installing:
- AccessRuntime.exe or AccessRuntime64.exe depending computers
- AccessDatabaseEngine.exe or AccessDatabase64.exe depending computers

It seems solve problem on 32bits computers but it doesnt for 64bits computers.

My application is a 32bits executable.

Which client should I install to solve this problem on x64 computers?

[AlexP]

Hello,

You need to install the 32-bit MS Access ODBC driver for work of a 32-bit application on a 64-bit system.