how to acces remote database using labview and db connectivity tools

[steve johnston]

How do i connect to a remote MS access database using labview and the db connectivity toolset

[Crystal]

Connecting to a remote database is exactly the same as connecting to a local one - you do it either through the ODBC Administrator (in the Control Panels) or by creating a Data Link file (*.udl).

I prefer creating UDL files by going to the Tools>>Create Data Link dialog. In the Provider tab, select the Jet 4.0 driver. In the Connection tab, select the browse button and you can then go through the My Network Places, you can connect to your remote database file (*.mdb). When you return to the Connection tab, you can then Test Connection to make sure it works. Save the UDL file and then use that path for the connection in the DBTools Open Connection VI. Be sure to always check the error coming out of the Open Connection subVI so that you catch problems (networ
k problems, remote computer not on, etc) before you try to read/write data.

[leebowers]

Hello I am having problems with consistently connecting to an MS Access database

I am using a UDL file or rather 2 files (1 local 1 remote) and I can connect ok but then for no reason it just falls off? When I open my udl and 'test connection' all is ok but i still cant connect via the labview program

The only way I can then rectify the problem is to reboot the PC

Can you help

[THailey3]

Hi Lee,

On new issues like this, I would recommend creating a new thread. Is the only way to rectify the problem really rebooting your PC? What happens when you restart LabVIEW? LabVIEW does some garbage collection upon closing, so I would be curious to see if that helped any. If not, it may not be as much of a LabVIEW issue as it may be a database issue.

Hope this helps,