Hello,

i have a application which is developed with Visual Basic. I can access to a .DBC Database with the OLE-DB Provider from VFP. I use ADO to access. But i have problem with the SQL syntax.

Problem:
THE SOURCE CODE:

01 myconnectString "Provider=VFPOLEDB.1;Data Source=c:\Folder of the 02 Database .dbc;Password='';Collating Sequence=GENERAL"


03 Dim XZ as new ADDÒDB.Recordsets

04 XZ.open "Select * from customer where typ = 'PARTNER'", myconnectstring

With this Syntax allways is ok. I have a recordount of 3 Datasets results and this is the true results and it is ok.

But now my Problem:

when i write

04 XZ.open "Select * from customer where typ = 'partner'", myconnectstring

'partner' is here not in Ucase. I have not recordcounts (0). Not results. But i have 3 Partner entries in the Table of customers.

In Visual Fox Pro 7.0 i have not this Problem. It come the same results when i write 'partner' or 'PARTNER'. But i have this Problem with ado when i acces to the database from Visual Basic.

Why?

It is possible to change the Provider settings.

Can You help me!

Thanks

Fehmi