accessing data on remote web server for intranet asp's

[sweetleaf]

Hi,

if there is a database sitting on some remote web server and i would like to access one of it's tables
for an asp page on my company intranet , or from an .mdb on my pc, how could i do it?
is this even possible?

 

[link9]

It's possible if the other database is something like SQL Server or Oracle, and that database has a static IP address that is accessible via the Internet.

If that's the case, then get yourself a userName and password, check out the connection string FAQ in this forum, and you'll be good to go.


Paul Prewett

 

[sweetleaf]

thanks link9!

How about if i don't want the user to have to log on with each trip/transaction to the web db?
if a vpn is used to connect to the remote server can i just use standard odbc connections to the remote database?

Would obtaining the static IP for the remote database be the way to go if there was no VPN connection, however?

 

[link9]

Yes, the IP address is the only way to go if there's no VPN connection.... whether it be through an ODBC DSN or whatever... somewhere, the IP (or the serverName if there is the VPN connection always present) will have to be used in order for your script to know where to go.

Does that answer your question, or did I miss it?

paul