database conectivity question?

[yanhuaguang for china]

when I select the OLE DB provider is "microsoft OLE DB provider for
ODBC Drivers",I can write to database,but I can't read from database
using data connectivity toolkit?
i use the SQL language
SELECT * FROM motor WHERE serial="aaa"
the error is :
"error-2147217904 occurred at conn Execute.vi-fetch record.vi(myvi).
possible reasons:
Invlid string:specified field does not exist or contains an
unsupported character"

but when I select the OLE DB provider is "microsoft JET 4.0 OLE DB
provider" in UDL file,i can read the record using the same language.

[ebarker]

Please refer to the LabVIEW Database Connectivity User Manual, as it goes into great detail about the background of OBDC and also the Jet protocal. Specifically, look at Chapter 2, page 2-10. Good luck!