Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No OLEDB Support in 7?
Message
From
26/09/2001 18:55:21
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00561239
Message ID:
00561261
Views:
28
Hi Steve,

Just to clarify what Steve and Hector said (and they are both right), remote views and SQL pass-through will only work with the ODBC drivers. The OLEDB can be used via ADO. John Peterson has a whitepaper on ADO for the VFP developer on the MSDN website. Essentially, an ADO recordset is what you would be using -- which you can bounce back and forth to and from a cursor with RSToCursor() and CursorToRS() functions.

>I think I am missing something. Is there no way to query and OLEDB data source (MSSQL2K) in VFP7? I tried to make a new Remote View and dropped in my OLEDB connection string and it choked.
>
>How can I use OLEDB features in VFP7?
>
>Thanks.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform