unknown sql error

[Fulmetalal]

I'm trying to pull a specific instance from a table and i'm receiving an error with no description. Any Ideas?

[AdnanZ]

Turn on highlight execution to check which VI is throwing the error (I am thinking it's the first). Have you checked whether you successfully established a connection between LabVIEW and the database?

[nyc_(is_out_of_here)]

http://digital.ni.com/public.nsf/allkb/E7984C0DA0F0E65086257694005B4CB7

[Fulmetalal]

The error is being thrown by the execute sql query function. So i think there might be some very small mistake with it, but i don't see one. The column i'm checking is a string. Both the table and column i'm searching are correct.

[dkfire]

But what column do you want data from ?

You need to specify a column to get data from in your select.

SELECT columnName FROM table1 WHERE ... or

SELECT * FROM table1 WHERE ...

[Fulmetalal]

Even if i specify which column to put it in it still has the same error.

Also nyc,

Even if i make a udl file it shows up as the same error.

[Dennis_Knutson · Accepted solution]

Change the column name. It seems that Current is reserved.

[Fulmetalal]

Thanks, you saved me a couple days of headaches trying to get it to work.

[Wart]

Sometimes you can work around reserved names by putting the name is square braces.

For example: [Current]