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