Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Document Type: Example Program
NI Supported: Yes
Publish Date: Sep 6, 2006

Connect Directly to a Microsoft Access Database Using Connection String

1 ratings | 5.00 out of 5
Print

Downloads

Filename: mdb_tools_open_connec_string.vi
Requirements: View

With the LabVIEW Enterprise Connectivity Toolkit, you can access many different types of databases using the appropriate Microsoft ActiveX Data Object (ADO)-compliant OLE-DB or ODBC driver.

One database is the Microsoft Access database. You can connect to an Access database using the Microsoft Jet OLEDB driver.

Usually you can set up the connection by creating a Universal Data Link (.udl) file and inputting the path to the DB Tools Open Connec VI in the LabVIEW Enterprise Connectivity Toolkit. However, you also can connect to a database directly without setting up a UDL file. This example demonstrates how to use connection strings to set the provider for the database. Because connection strings can be difficult to use and using a UDL file offers more control over the type of access to the database, using the UDL file is recommended.

Related Links:
LabVIEW Enterprise Connectivity Toolkit
KB 3OSAJHTJ: Programmatically Creating Universal Data Link (*.udl / UDL) Files
KB 2E7GIDDT: What Is the Difference between a System DSN, a User DSN, and a File DSN?

Requirements


Filename: mdb_tools_open_connec_string.vi

Software Requirements


Application Software: LabVIEW Full Development System 7.0
Toolkits and Add-Ons: LabVIEW Enterprise Connectivity Toolset 3.0.1
Language(s): LabVIEW

 
1 ratings | 5.00 out of 5
Print

Reader Comments | Submit a comment »

 

Legal
This example program (this "program") was developed by a National Instruments ("NI") Applications Engineer. Although technical support of this program may be made available by National Instruments, this program may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this program with each new revision of related products and drivers. THIS EXAMPLE PROGRAM IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).