Error 1 When Connecting to a Microsoft Access Database
Primary Software: LabVIEW Toolkits>>LabVIEW Database Connectivity Toolset
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software: N/A
When I attempt to connect to a Microsoft Access database on my computer by wiring the database path to the DB Tools Open Connection.vi, I receive the following message.
Error 1 occurred at DB Tools Open Connection (Path).vi, the file provided is not a data link (UDL) or a file DSN.
How do I correctly connect to my database in LabVIEW?
This error is generated because it is not possible to directly connect to a database from the Database Connectivity Toolkit. A Microsoft Access database is a single file, but many databases are stored in multiple files, even on multiple computers. For this reason it is necessary to have a standard means of connecting to any database. With the Database Connectivity Toolkit, you have two connection options. Those options are to create a Universal Data Link (UDL) or a Data Source Name (DSN).
Chapter 3 of the LabVIEW Database Connectivity Toolkit User Manual contains the steps required to create either a UDL or a DSN. Once you have created a UDL or a DSN that points to your database, wire the UDL/DSN path into your DB Tools Open Connection.vi, and you will be able to establish a connection to your database.
Product Manual: LabVIEW Database Connectivity Toolkit User Manual
KnowledgeBase 2KFB4NOU: Creating a Microsoft Data Link file (UDL) for Connecting to a Database in LabVIEW
KnowledgeBase 2J5H09DJ: Can I Access MDE Files Using the LabVIEW Database Connectivity Toolset on a Computer Without Microsoft Access?
KnowledgeBase 1XMGJUHE: Can I Use LabVIEW to Open an Access Database Without Using SQL Functions?
KnowledgeBase 1Q5G4DJ6: Why Does My LabVIEW Application Leak Memory when Logging to an Access Database?
Report Date: 06/20/2002
Last Updated: 08/11/2017
Document ID: 2MJ6PPFP