04-26-2012 10:54 AM
Hello all,
I am trying to connect to a database created by MS Access through LabSQL (yes, I know it's archaic and comes with no support but the LV Database Connectivity Toolkit just isn't an option on my student budget )
I used a connection string from www.connectionstrings.com/access-2007, and the string is as follows: Provider=Microsoft.ACE.OLEDB.12.0;Dbq=C:\Users\Laura\Simulation\Polar Bear Window & Door Manufacturing LTD\1500A Awning NFRC Report\W6- Awning 1500A.mdb;Uid=Admin;Pwd=;
The error message I am recieving is "Exception occured in Microsoft Access Database Engine: Could not find installable ISAM. in ADO Connection Open.vi->Untitled 1"
Attached is a snip of my VI for more info.
Thanks!
Laura
04-26-2012 11:09 AM
Are there spaces in you mdb filename? If so, that may be causing the connection problem.
04-26-2012 11:27 AM
There were, but I deleted all spaces in the filename (and even the path to be safe), but still the same error!
I found this Microsoft KB article about the error: http://support.microsoft.com/kb/318161
Maybe you LabView experts can find a way to relate this to LabView!
04-26-2012 11:43 AM - edited 04-26-2012 11:43 AM
You are not using Jet.
Do you have Access 2007 installed?
04-26-2012 11:54 AM
I have Access 2003 (32 Bit) installed.
04-26-2012 12:47 PM
Then your connection string is wrong.
You need the one for Access and not Access 2007.
04-27-2012 11:28 AM
Either way the provider is Jet 4.0, is it not?
04-27-2012 12:15 PM
@lauraalkhoury wrote:
Either way the provider is Jet 4.0, is it not?
Uh, no.
04-27-2012 12:30 PM
Instead of some connection string you found somewhere, create one from scratch with a udl or create a dsn in the ODBC Data Source Administrator. You can validate it there and know it is working before trying it with LabSQL.
04-27-2012 01:40 PM
The connection string at ConnectionStrings.com are correct, but you have to know which one to use.