Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing tables through the internet
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00523938
Message ID:
00524506
Views:
13
Better yet, in an Article in FPA a while ago Rick Strauhl (sp) did an article on it. Providing its not too big, and that you have some bandwidth and access to the share the table is on, you can indeed with VFP and windows use a table just as you showed. Don't use the http but rather USE \\10.0.0.1/ServerFolder/FileName.DBF which will actually open it over the internet. I actually done this at home for playing around purposes (of course I have a cable modem). This being said, if you are actually trying to get stuff done, I would recommend as others that you consider West Winds tools for that as they move a lot of the load to the server so that only the data gets moved across the internet.

>Yes you can do this with a SQL Server database. Just define a connection to the IP address where SQL Server is installed. For example:
>
>
>n = SQLSTRINGCONNECT('DRIVER=sql server; SERVER=123.123.123.123; UID=sa; PWD=; DATABASE=northwind; Address=123.123.123.123,1433; Network=DBMSSOCN')
>SQLEXEC( n, 'select * from employees' )
>browse
>
>
>>Hi All,
>>
>>Is there a way to access a data table over the internet. For instance if I wanted to write an application that I could run at home and could run a query on our server at work and return the result to me at home. Or have me reference a table for editing over the internet like Use http://10.0.0.1/ServerFolder/FileName.DBF? Is this possible to do using SQL Server?
>>
>>Thanks in advance for any help.
>>
>>Aloha,
>>
>>James
Cy Welch
Senior Programmer/Analyst
MetSYS Inc
Previous
Reply
Map
View

Click here to load this message in the networking platform