How do I connect to a sql server over an IP address?
 

Hi --

I am not too technical so just need a plain laymen's answer - or point me in
a direction.

I use ADO connections within Excel VBA to connect to local sql servers in
order to access information; however, it seems that it is difficult to access
remote servers through ado connections that are accessible through a web
browser (vpn connections excluded). I am assuming this is because the web
browser is a more secure interface with the sql server being accessed (ie,
this security was set-up purposely by the db or web developer).

I have noticed that Crystal Reports can also typically access info I cannot
access through Excel. Is there a safe way I can set-up a connection to a sql
server through Excel? If it comes down to it I can use a web query to pull
info to Excel through a browser type interface, but can I use a web query to
write data to a database?

Thanks in advance --

Jim