Academic Company Events Community Support Solutions Products & Services Contact NI MyNI
7 ratings:
 2.85 out of 5   

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

Problem:
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?

Solution:
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.

Related Links:
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?

Attachments:





Report Date: 06/20/2002
Last Updated: 08/11/2017
Document ID: 2MJ6PPFP

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit