LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

open .mdb database

The problem is that you are using LabVIEW 32-bit but the ODBC Administrator that you start from your Control Panel is the 64-bit variant since you are running 64-bit Windows. Instead you want to start the 32-bit version of the ODBC Administrator in C:\Windows\SysWOW64\odbcad32.exe. This version will enumerate the 32-bit ODBC drivers and there you have a JET DB driver. You can then setup a DSN in there that you can use from the Database VIs when running LabVIEW 32-bit. 

 

 

Rolf Kalbermatter
My Blog
0 Kudos
Message 11 of 13
(580 Views)

I found that the ACE drivers are better than the JET drivers.

The connections string is also a bit tricky.

image.png

The above connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source="%s"

 

---------------------------------------------
Certified LabVIEW Developer (CLD)
There are two ways to tell somebody thanks: Kudos and Marked Solutions
0 Kudos
Message 12 of 13
(563 Views)

Thank you so much for your help! Now it works!

0 Kudos
Message 13 of 13
(550 Views)