ADO Connection

[Weste]

I am tring to connect to our SQL database via VBA code. I am using the
format below:
Set cnn = New ADODB.Connection
cnn.Open "Provider=sqloledb;" & _
"Data Source=yourServerName;" & _
"Initial Catalog=yourDatabaseName;" & _
"User ID=userid;" & _
"Password=password;"

I've replaced yourServerName etc with the appropriate values. It seems I am
having problems connecting because I am behind a firewall using VPN. Does
anyone know how to modify the connection string for this circumstance?
Thanks for your help.

 

[Douglas J. Steele]

See http://support.microsoft.com/kb/269882