Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing tables through the internet
Message
 
To
26/06/2001 20:49:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00523938
Message ID:
00523976
Views:
11
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
Hector Correa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform