connection to mdb with labwindows cvi

[Hai 261]

Is it possible to do a connection to a mdb (MS-Access97) database without using the add for dataconnections.

Maybe there is an example available.
Thanks a lot
HH

[Chris Matthews]

The easiest way would be to get our CVI Enterprise Connectivity toolkit which includes a library for SQL programming to access the database. You can see the details of that toolkit here.

If you don't want to do this you can access it through ActiveX and Microsoft's Data Access Components. You can use the Tools->Create ActiveX Controller... to create a instrument driver to program the Data Access Components (MDAC). It will be harder to program this way, but you can find documentation for MDAC from Microsoft on MSDN (msdn.microsoft.com).

Best Regards,

Chris Matthews
National Instruments

[DanielMcchane]

Yes, it is possible to make a connection to Access without using the SQL toolkit. The method for doing so would be through ActiveX.
You simply create an ActiveX controller from the project window of your project, and select Microsoft Access. This will generate an .fp file that will allow you to control access through function calls from your created driver.
However, I would like to point out here that it will be more difficult to control Access in this way, as the driver will have to no help for your generated function panels. But it is very possible.

Daniel McChane
Application Engineering
National Instruments