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;
Comments
Please sign in to leave a comment.