06-06-2018 04:42 AM
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
06-06-2018 05:06 AM
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?