Firewall Connections.

[SYMBIO]

Hi. i have been developing on our companies InTRAnet box and now its ready to go live on the InTERnet box. they have this procedure where instead of linking from one system to another (using same database on different boxes) they have 2 separate databases, and they do this import thing which keeps things synchronised.

i remember connecting through a firewall from the internet box to the intranet box (but that was using a ORACLE database)...does anyone know how to do this?

i currently use the connection string:

oConn = "Driver={SQL Server};Server=THEINTRANETBOX;Database=RAYDB;Uid=limp;Pwd=crimp"

cheers,