LabVIEW Database Connectivity Error When Trying to Connect to a Database

Issue Details

• Error -2147467259 occured at NI_Database_API.lvlib:DB Tools Open Connec(String).vi->Untitled 1

• Error -2146824584 Occured at Untitled 1

 

• Error -2147287038 Occured at Untitled 1

• Database Connectiviy Issues. Please Contact Admin. Software to be Exit now.

Solution

The error messages suggest that LabVIEW is not able to connect to the database server and the Open Database Connectivity (ODBC) is either not configured or configured incorrectly. To access a database from other applications, you need to specify a Data Source name (DSN) or Microsoft Data Link file (.udl). Follow the next steps to try to solve this issue:

• Check Microsoft ODBC Data Source Administrator to verify that you can see a connection to your database. 
• Verify that the ODC connection is configured in the data source with the same bitness as the LabVIEW version you are using.

• Try using a shipping example to establish the connection in LabVIEW. For instance, you can try using the example called Database Connection VI. To get more information on how to access examples visit: Locating Examples Included with NI Software Products.
• Try to access the database with another program different than LabVIEW to confirm the database connection works.
• Try a connection method different from the one that is failing, you can use any of the following:
  • To configure a Microsoft Data Link file, please refer to Creating a Microsoft Data Link file (UDL) for Connecting to a Database in LabVIEW.
  • To configure a DSN file, please refer to How to Create a DSN File to Communicate with an Access Database in LabVIEW.
  • You can also access a database by passing a connection strings to the DB Tool Connection.vi. Please refer to the (external link) connection strings reference guide for the specific connection string for each database type. 

Additional Information