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?

What do you mean by "unable to connect"? Is that the error message you get? — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Oct 12, 2009 at 8:19

Chris Latta · Accepted Answer · 2009-10-12 08:25:20Z

5

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

answered Oct 12, 2009 at 8:25

Chris Latta

20.6k4 gold badges67 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonathan Over a year ago

yep, 90% of times, this is the problem.

Collectives™ on Stack Overflow

SQL Server Connection String problem?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related