Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Connection Problem (With OLEDB)
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00565686
Message ID:
00565880
Views:
28
Then how are you opening the MS SQL Server database and tables?

>Thanks, I will look, but if I can't call something via the VFP7 OLEDB provider from VBScript, I can't use it.
>
>Thanks again.
>
>>You can use any of the available ADO recordset to VFP cursor conversion tools for this. In such case you would only need the SQL provider and not the VFP one. May I suggest you use the following UT download (that I posted) : http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1454 , after you have the cursor just save it as a DBF. Half of the work is done for you in this download which has a test program that can open the specified SQL Server database and loops through all the tables to perform the conversion. Just change and use the connection string for a SQL Server database.
>>
>>Alternatively you could use the VFPCOM utility from MS.
>>HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform