Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odbc
Message
From
11/12/2003 15:06:45
 
 
To
10/12/2003 22:04:13
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Odbc
Miscellaneous
Thread ID:
00857956
Message ID:
00858321
Views:
15
Hi Craig.

>Currently, I have just started working with SQL from VFP. I have created a connection via ODBC and created a database (say: mydatabase.dbc) in which I have added some remote views for specific SQL tables from the connection.
>
>Question! Is there another way to create remote views, or are there WIN2000 utilites that will allow me to do this so I can insert, edit and change SQL table from VFP?
>
>Other then ODBC what are my alternatives, if any, in updating SQL tables from VFP?
>
You are using the Cursor Adaptor, I hope. My experience may be different than yours becuase everything I have done between VFP in front and SQLServer in back is in direct Cursors doing database conversions. The CA handles everything very seemlessly. Even gives a lot of power for databse manipulation. As far as the ODBC goes, I've decided to keep using it, as opposed to vfp oledb driver. Seems to be faster for me.

Regards,
- Glen -

The impossible we do immediately.
The miraculous will take a little longer.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform