ashim_ind


I am heaving a problem & I can't seem to find any information on the internets to help me. I am trying to connect a VFP 6 free table that is on separate machine on the network. My question is

1. How I connect VFP 6 free table on the network using ODBC or other proc.

Please help me

Thanking you




Re: VFP 6 Free Table Connection

AndyKr


There are lots of ways to do this, but easiest is:

[1] Create an empty VFP database for yourself on your machine and open it for modification:
CREATE DATABASE freecon
MODIFY DATABASE freecon

[2] Create a new connection in the database by right-click and choose "connections", then "New". Choose "New Data Source" from the dialog

[3] Select "System Data Source", then Next

[4] Choose "Microsoft Visual FoxPro Driver", then Next

[ 5 ] Give it a Name (e.g. "FreeDBF") and Description (e.g. "Connect to DBF on Network") and  Choose "Free Table Directory" then either enter the path, or browse to the location of your tables, then hit OK

[ 6 ] Now choose your DSN from the drop down list and choose "Verify Connection" - it should say "Connection Succeeded"

Now you can cancel out of the tool, delete the database because the DSN has been created in the WIndows Registry. YOu can use like any other system DSN with SQLCONNECT().

(If you want a connection string for it, just choose "connection string" instead of "System Data Source" at step 3).

 







Re: VFP 6 Free Table Connection

ashim_ind

Thanks for giving reply.

Every think is correct but serial no 5. after giveing system DSN name and choose the "Free Table Directory" then either enter the path, or browse to the location of my tables, then hit OK. my question is if I follow the serial no. 5 that mains I have share the drive where the free table Directory are available. If I share the drive that mains I give the right to user for read and write to particular drive. If I do this the secority problem arise. It is possible without sharing the dirve I am access the free table form separate machine on the network, just like a Sql Server.

Thanking You






Re: VFP 6 Free Table Connection

AndyKr

If you do not have rights to the drive you cannot acces it. Period. Not by ODBC or any other way - just as in SQL Server if you do not have rights to the database you cannot open it. What you are asking makes no sense!






Re: VFP 6 Free Table Connection

ashim_ind

Dear Sir,

I understand. But my question is if I install SQL server in a server machine and give the right to user for accessing database that time I can't share the drive (i.e. c:\) in a server machine where the SQL server software are installed or SQL database & table are create. that time authenticate user are access the database form separate machine on the network. If it is possiable, then why VFP6 "Free Table Directory" not access from server machine without sharing the dirve (i.e. c:\).

Thanking Your