How to access a database through a vpn connection

[dboiler]

Our production server is housed at an ISP and runs our system. We are using CF8. We have another server in another facility which has the database, SQL Server 2005, and have a VPN connection between the two sites. The server in the remote site is a stand alone and not part of any domain. My question is this; What is the best way to access the database from the production server system?

Thanks in advance.

Dave

[ilssac]

I don't know if this works for your situation.

But I access my remote SQL Server database through ColdFusion by putting SQLxx.domain.com into the 'Server' paramter of the DSN configuration form.

I do something similar to setup my SQL manager to connect to this database so that I can manage it's objects.

HTH

Ian

[Adam Cameron.]

"Via its IP address" seems too obvious an answer here, so I'm guessing I'm missing something.

I cringed at the potential performance implications of having the CF and DB servers housed at different sites, and the connection between the two being via VPN, btw.  Have you tested how well that performs, before committing to it?

--

Adam

[dboiler]

Hi Adam and thanks for the reply.

I can certainly ping the IP address of the remote database machine but I don't know how to go about writing a script to access the database there.

We have a dedicated T1 line with a permanent tunnel between the two servers. The traffic will be minimal as there will only be few records stored and retrieved at a time.

Thanks and I look forward to hearing from you if you have suggestions on storing and retrieving the data using CF.

Dave

[Adam Cameron.]

I can certainly ping the IP address of the remote database machine but I don't know how to go about writing a script to access the database there.

OK.  So just set up a datasource like you normally would then.  CF doesn't give a sh!t that the DB is across a VPN, all it cares about is having a TCP/IP connection.

Have you tried to set up a DSN?

--

Adam