General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Checking. Thanks
>>Hello:
>>I use OLEDB connections for some queries. In my new developments I have to connect Excel with VFP OLEDDB data sources, but the stock OLEDB connection to VFP Tables is not recognized by Excel, so I downloaded the new OLEDB driver.
>>The problem is that queries that used to run very fast with the old driver now take a long time. Does anyone know about ths?
>>Regards
>
>Sergey is most likely correct - I'd bet on the codepage. You can specify the codepage in the connection string (just add ;CODEPAGE=437 or whatever the codepage is). You can check the codepage from within VFP. Use the table, then ? CPDBF()
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only