Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC via the network
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00141084
Message ID:
00141361
Views:
19
You can do this using SQL Server, but not ODBC accessing VFP or Access tables. In order to have a client/server system you must have a database server. This means SQL Server, Sybase, Oracle, etc. The difference here is that there is a program actually running on the server that processes your queries and returns the results to the client. If you use ODBC to access VFP data, this is not what happens. The VFP ODBC driver is really just VFP's data engine with an ODBC interface. When you use it, the driver runs on the client. This means you still have to pull more than just the result set over the network.

However, you shouldn't think that VFP will pull an entire table over the wire to return one record. If your query is optimized, VFP can use the index to find the record(s) to return and pull significantly less than the whole table over the network.

>Thanks for the answer. The reason I didn't wanted the second computer from directly accessing the data is to prevent the entire 1 millon records table from going down the network to select just 1 record.
>
>But I thought that it wouldn't be possible with ODBC - after all, MS sells SQL Server! :-)
>
>>You're right with the exception of the part about the shared directory. In order to set up the DSN on the other computer, you'll have to tell it where the data is. If the data isn't located on a share, the other computer won't see it! This is a problem if you're using VFP data and don't want people having full access to the data via other applications other than your own.
>
>Sylvain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform