OLEDB for Access

HCL Domino Domino Forum
1

What needs to be set up on the server to be able to read a Microsoft Access db through Lotusscript?

I have a new test server with Windows 2008 (64 bit). An existing program uses code such as:

Dim con As New Lcconnection(“oledb”)

con.provider = “Microsoft.Jet.OLEDB.4.0”

con.server = “\dbpath\dbname.mdb”

con.Connect

This code errors on the test server with:

Error:

No Error Info posted; HResult: 0x80040154

, Connector ‘oledb’, Method -Connect- (12325)

Thanks in advance.

2

Subject: re: OLEDB for Access

I think you’ll need to install the Microsoft.Jet.OLEDB.4.0 drivers. Typically the 12325 error is given when the provider drivers haven’t been installed.

3

Subject: re: OLEDB for Access

Thanks, but there isn’t a Jet driver for 64 bit. Will be trying to install the 32 bit Domino Server and testing it from there.

4

Subject: OLEDB for Access 32 bit ok

The code works with Domino 32 bit. Though, we moved to a 32 bit Windows server, too, so I don’t know if it would work with 64 bit Windows and 32 bit Domino.