开发者

SQL Server Connection String problem?

Using VB6, SQL Server 2000

I want to connect to others system database.

Code:

ConnectionString = "Provider=SQLOLEDB.1;" & _
                                "Persist Security Info=False; " & _
                  开发者_Python百科              "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?


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜