ADO Connection

  • Thread starter Thread starter Weste
  • Start date Start date
W

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.
 
Back
Top