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
精彩评论