Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Acces via ADO and ODBC, does not like like?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Acces via ADO and ODBC, does not like like?
Miscellaneous
Thread ID:
00183110
Message ID:
00183110
Views:
55
Hi,

For some reason my application has to interact with an Access .MDB file. I use ODBC and ADO to interact with this .MDB.

I cannot get the following sql statement to return values:

select * from addresses where name like "*DAVID*"

where Addresses is a table in the MDB and Name is a one of the fields in it.

In Access, executing this selection does return records.

Is it ADO, ODBC or me?

TIA,

Marc

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Next
Reply
Map
View

Click here to load this message in the networking platform