PSIfusion: Valid Connection String to OleDb Data Provider(.mdb) and (.accdb)

Question:

I keep getting the following error when trying to set a connection string to the following Database format .mdb

An error occurred connecting to the data source:
The data provider failed to load the list of available tables/views

Answer:

Permissions and formatting of the connection string are most likely what is causing this issue.

Use the following connection string format;

In order for this to work you must have the proper permissions to the individual .mdb file. Right click on the .mdb file and go to properties. Click on Security and set permissions to Everyone[Full Control]. Go into PSI:Fusion Connection settings and use the following format for the Connection String:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Adjust to database location];

If you are connecting to a .accdb Access Database use the following connection string. (NOTICE: In order for this to work you will need to have the Access Database Engine Installed on the machine running Fusion.)

Link to Access Database Engine Download: https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;


Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.