database connectivity 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?
but when I select the OLE DB provider is "microsoft JET 4.0 OLE DB
provider"
that's no problem.i don't known why?

thank you in advance!
yhg-163@163.com

[ebarker]

Please look at the LabVIEW Database Connectivity User Manual, specifically chaper 2, as it explains in great detail the differences between the two different providers. Good luck!

[yanhuaguang for china]

ebarker wrote in message news:<506500000005000000DD060100-1042324653000@exchange.ni.com>...
> Please look at the
> href="http://www.ni.com/pdf/manuals/321525c.pdf">LabVIEW Database
> Connectivity User Manual, specifically chaper 2, as it explains in
> great detail the differences between the two different providers.
> Good luck!



I have saw LabVIEW Database Connectivity User Manual,I can't get some
useful information.
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 stored data in access database (.db
file) and i use the SQL language:
SELECT * FROM motor WHERE serial="aaa"
the error is :
"error-21472179
04 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" ,i can read the record using the same language.