CODEWITHSUNDEEP
c#dockerms-accessoledb
Miky
Miky

Reputation: 71

Docker for Windows & MS-Access database & Jet.OLEDB.4.0

I need to setup a docker container in which a legacy application needs to connect to an MS-Access 2003 DB. The connectionstring to the DB is embedded in the application itself and therefore cannot be changed. So I cannot change the provider to be ACE.OleDb either.

I have created docker images based on …

… but I always get the same result when running the legacy application on the container.

The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

I also tried to register the msjetoledb40.dll in SysWow64 with the following command in the container ...

C:\Windows\SysWow64\regsvr32 Msjetoledb40.dll

... but does not seem to work either.

I have also installed the Microsoft Access Database Engine Redistributable (2007, 2010 & 2016) in 32 and 64 bit (AccessDatabaseEngine.exe & AccessDatabaseEngine_X64.exe) but always get the same error as mentioned above.

2007 Office System Driver: Data Connectivity Components

Microsoft Access Database Engine 2010 Redistributable

Microsoft Access Database Engine 2016 Redistributable

Any ideas?

Upvotes: 3

Views: 3190

Answers (1)

Miky
Miky

Reputation: 71

SOLVED:

I found a 'Jet 4.0 Service Pack 8 (SP8) for Windows 95/98/NT 4.0 (KB829558)' package.

Copied the Jet40SP8_9xNT.exe to the container and added this statement to the dockerfile

RUN Jet40SP8_9xNT.exe /Q

Upvotes: 3

Related Questions