Query Works in Access But Not in App
-
I am new to DB programming in VC. Any Idea why this SQL statement will not return any results in my program: SELECT * FROM Table WHERE Field1 LIKE "*text*" AND Field2 LIKE "*txt*"; The query runs fine in Access 2002 but will not return any results in my VC app. "Microsoft.Jet.OLEDB.4.0" is my provider when connecting to the Acesss DB. I tried to use "Microsoft Access Driver" but that throws an exception because it can not be found(???). Thanks for any suggestions. Matt (Padawan Learner)
-
I am new to DB programming in VC. Any Idea why this SQL statement will not return any results in my program: SELECT * FROM Table WHERE Field1 LIKE "*text*" AND Field2 LIKE "*txt*"; The query runs fine in Access 2002 but will not return any results in my VC app. "Microsoft.Jet.OLEDB.4.0" is my provider when connecting to the Acesss DB. I tried to use "Microsoft Access Driver" but that throws an exception because it can not be found(???). Thanks for any suggestions. Matt (Padawan Learner)
Wow, solved my own problem. For those interested, these articles helped me out: ACC: Running Stored Access Queries with Wildcards via ODBC May Return Incorrect Results OLE DB Provider for Microsoft Jet Matt (Padawan Learner)