asked on

Accessing Remote DB with VB6

I have a data-driven vb6 app that uses a sql server express 2008. It runs fine off of the sql server on the machine itself. Is there anyway I can get it to "find it" from my server if I can see the server-located database in my local sql server console? I would really like to run off the server so I don't have to manually move data back-and-forth.

ASKER CERTIFIED SOLUTION

Rimvis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

David Cherny

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bob Schneider

ASKER

Thanks. In response to HostOne, I think I am good there because I can access my remote sql server on my local machine using my sql server management studio. Here is my connection string:

If sSource = "h51software.net" Then
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CCMeet;UID=some_id;Pwd=password;Data Source=" & sSource
Else
conn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CCMeet;UID=some_id;Pwd=password;Data Source=" & sSource
End If

(Note that the "Else" clause is how I connect to the db locally and the other is how I am trying to connect to it remotely. How can I configure the remote connection string using config file, registry, etc?

SOLUTION

Rimvis

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial