ACCESS/SQL Library

Hello all,

yesterday, using the "db2000 ADODB" library to query an MDB, I had a problem with the "like" clause. It seems that the "like" clause in not supported. The library accepts the query string without errors but returns .rowcount = 0.

Looking around on Internet to find a solution or a library substitute, I found a small library that "should" be able to provide access to both SQL and ACCESS databases. It "seems" to be compatible with b4ppc (at least the DLL is loaded in b4ppc without errors and classes have a New contructor). Properties and methods are quite well documented for C# users, and sources are provided. For what I understand (very few), the calling syntax and the logic behind the wrapper are close to b4ppc sqlite implementation.

Unfortunately I was unable to use it as it is (as I said, I'm limited). Is there any C# volunteers willing to lose a few hours to take a look at the library and, if it is useful/usable, write a few lines on how to use it in B4PPC?

Here is the link: Welcome to Stitch.Database

Many thanks for your cooperation

Mimmo
(skipper)

Hi skipper,

You have these problems with db2000 ADODB library because it uses jolly characters not standard in SQL! You use % and _ (undescore) and not * and ?. See my response in the Italian forum...

Best Regards,

Massimo

Hi Massimo,

many thanks for your help. I'm sorry for the misleading and inaccurate information about your library that I gave to the other users ...

Would you please have a look to my answer in the Italian forum?

Thanks again
Mimmo

Hi skipper,

seen and answered!

From now on we will continue in the appropriate forum in Italian...