Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question on using OLE-DB Provider and SQLEXEC
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00606696
Message ID:
00606724
Views:
29
Yes, OLEDB library (file #10002 in UT downloads) has a set of SPT functions to work with OLEDB providers.

>Question on a VFP app that is using SQL Server 2000 as the back-end database.
>
>If one makes a connection without a DSN (basically, using OLE-DB Provider instead), is it still possible to use pass-through?
>
>(Basically, if I connect with the long connection string using the OLE-DB Provider to get a connection handle, can I still use SQLEXEC, or do I have to use ADO for everything?) I do realize that one can convert ADO to Cursor and back, but was still curious about pros and cons.
>
>This is in VFP 6. If the answer is 'no', that I must use ADO and can't use SQLEXEC, follow-up question is whether this can be done in VFP7.
Previous
Reply
Map
View

Click here to load this message in the networking platform