CREATE CONNECTION

[rlals]

Hi!
I´m using Visual Foxpro version 6 with SP 5.
I want to use a SQL server data base but my Fox doesn´t give options to create remote views ou connections.
This just let me use *.dbc files.

What is wrong ? There is a special version to do that, or I need to set up something ??


Ricardo

 

[Mike Lewis]

Ricardo,

No, you don't need a special version.

Here are the steps you need to go through:

1. In Control Panel, create a DSN for your SQL Server database. You use the ODBC applet to do that (this might be part of Administrative Tools, depending on your version of Windows).

2. In VFP, create or open a DBC.

3. In the project manager, drill down into the DBC; click on Connections; click on New. In the Data Source drop down, select the name of the DSN you created in step 1. Save and close the Connection.

4. Still in the DBC / project manager, click on Remote Views. Click on New. Choose the connection you created in step 3.

5. You will now be in the remote view designer, and you can go ahead and create your view.

The above is only an overview. If you need more details, come back.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[rlals]

Yes!! This works.
Thank you.

Ricardo