SQL Server Connection String problem?

Question

Using VB6, SQL Server 2000

I want to connect to others system database.

Code:

ConnectionString = "Provider=SQLOLEDB.1;" & _
                                "Persist Security Info=False; " & _
                                "User ID=" & SQL_Username & "; Password = " & SQL_Password & "; " & _
                                "Initial Catalog=" tmp_table1 ";" & _
                                "Data Source=" & SQL_ServerAddress

Values

SQL_ServerAddress = 192.11.12.11\SQLEXPRESS
SQL_Username = sa
SQL_Password = sa

Unable to connect to others system database

How to get a database from the other system?

Answer 1

You have configured Sql Express to accept remote connections haven't you? Networking protocols are disabled by default in Sql Express and you have to enable them to remotely access the database. You'll need to configure Sql Express to accept remote connections