Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP App and Sybase
Message
 
To
14/12/2000 10:00:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00453328
Message ID:
00453551
Views:
23
>I want to use my VFP app with Sybase. I know that I have to use remote views but I don't know how to manage them.
>Can I create a DBC with remote views only ? Is that possible with XCASE ?
>I need more informations.
>
>Marc

Hi Marc,

Don't know about XCASE, but you can do it just with a DBC. Create new ODBC source through the Control Panel/Data Sources (ODBC), using ODBC driver for Sybase. Create a new VFP project; create a new database; create a Connection in your new DBC using your new Sybase ODBC data source, test the connection from Connection Designer, save it. Then add new Remote View. It will ask you to specify the connection. Select your connection and it will bring you the list of tables from Sybase database. Select the table(s) you need, select fields, etc., save the remote view. Now you will be able to use it. Your DBC will contain only Connection and Remote views.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform