what error is this ?

[ChongKit]

Hi all ,i need your help . I just got this error message when i wan to select column of my database.

NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Select Data.vi->FYP.vi<ERR>ADO Error: 0x80040E14
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Student name'. in NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Select Data.vi->FYP.vi

I am a newbie to to labview data, what should i do to slove this problem ???

[Norbert_B]

As i can see from your quoted error message, you are working with the database connectivity toolkit and connect to a database using the Microsoft OLE DB provider. Reading the error message carefully points out that you have an error within your SQL statement you are trying to execute on the database.

My guess would be that you have some kind of SELECT "Student name", but the active table does not have such a column/the database does not contain such a table.

So it seems to be a pure SQL issue.

hope this helps,

Norbert

[smercurio_fc]

Perhaps you should be asking your teacher.

[ChongKit]

i found out the solution... they say cannot put space... So jst write "StudentName"

[erganesh]

Hi there,,

I got same error out message to create table in MS Access Database..

NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->Untitled 3<ERR>ADO Error: 0x80040E14
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition. in NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->Untitled 3

Pls help me how to solve error message...

Rd,

ganesan

[nyc_(is_out_of_here)]

---

@CPUT wrote:

Hi there,,

I got same error out message to create table in MS Access Database..

NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->Untitled 3<ERR>ADO Error: 0x80040E14
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition. in NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->Untitled 3

Pls help me how to solve error message...

Rd,

ganesan

---

Not a LabVIEW problem

Go take a class in SQL. Plenty of online tutorials.

[smercurio_fc]

We also know that this is a homework problem.

[erganesh]

Thanks ...

Rd,

Ganesh

[ThibaultH]

I have the same problem, but my syntax in SQL seems to be just fine:

I've written a subVI to write in a table of our labdatabase some parameters every 30 seconds.

I've tested the subVI independantly, keeping it running with a autonomous open connection and it then works just fine (ie the parameters are written correctly in the database).

But when I run the VI in its normal environment (as a subVI in a very large operating program) I get this message... which I find wierd given that the exact same syntax works perfectly when run seperatly.

Do you have any idea on what the source of such an error could be?

Thank you very much.

[ThibaultH]

Here is a snapshot of the VI (As I use typedefs not included in the previous message).