Bob Schneider
asked on
Connect vb6 app to remote db
I am trying to connect my vb6 app to either a local or a remote database, depending on which is selected. Here is my connection string:
I get a "server not found" error when I try to connect. Is there an error in my string or my process?
If sWhichSrvr = "Remote" Then
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CCMeet;User ID=id;Password=pwd;Data Source=209.185.199.1,1433\SQLEXPRESS"
Else
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CCMeet;UID=id;Pwd=pwd;Data Source=VIRA-5\SQLEXPRESS"
End If
I get a "server not found" error when I try to connect. Is there an error in my string or my process?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Incredibly helpful!!
Glad to help.
ASKER