LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect syntax near the keyword 'where' in NI_Database_API.lvlib

I'm trying to connect to SQL Data Base using provided .udl file.

I tested .udl file using "Test Connection" button and the connection is successfull.

My Code is attached.

I get error:

 

NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools List Columns.vi->Untitled 2<ERR>ADO Error: 0x80040E14
Exception occured in Microsoft OLE DB Provider for SQL Server: Incorrect syntax near the keyword 'where'. in NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools List Columns.vi->Untitled 2

0 Kudos
Message 1 of 2
(2,625 Views)

I get the same error when I input a null string as table name to DB Tools List Columns vi.

Are you sure that index is in range? What's the table name?

Paolo
-------------------
LV 7.1, 2011, 2017, 2019, 2021
0 Kudos
Message 2 of 2
(2,619 Views)