Question

VB6.0如何连接SQL server 2005

原有一个ACCESS的数据库连接，现在如何换成SQL server 2005的呢？
数据库内容、名字完全一样~
SQL server 2005-----用户名sa 密码123
谢谢~

Answer 1

Public sqlcon As System.Data.SqlClient.SqlConnection
Public sqladapter As System.Data.SqlClient.SqlDataAdapter
Public command As System.Data.SqlClient.SqlCommand
Public ds As System.Data.DataSet
Public dr As System.Data.DataTable

sqlcon = New System.Data.SqlClient.SqlConnection
sqlcon.ConnectionString = "Server=服务器名; Initial Catalog=数据库名 ; User ID=sa; Password=123"
ds = New System.Data.DataSet
dr = New System.Data.DataTable(" 表名 ")
ds.Tables.Add(dr)
sqladapter = New System.Data.SqlClient.SqlDataAdapter("select * from 表名", sqlcon)
sqlcon.Open()
sqladapter.Fill(dr)
sqlcon.Close()

Answer 2

Public Cns As New adodb.Connection '定义连接
With Cns '定义连接
.CursorLocation = adUseClient
.Provider = "sqloledb"
.Properties("Data Source").Value = SQLServerName
.Properties("Initial Catalog").Value = DatabasesName
.Properties("User ID") = UserID
.Properties("Password") = LoadPassword
.Properties("prompt") = adPromptNever
.ConnectionTimeout = 15
.Open
End With

Answer 3

是不是你链接语句写的有问题，SQL
Server2005一般我们用下面语句：
Adodc1.ConnectionString="Driver={SQL Server};Server=192.168.1.50;UID=sa;PWD=111;DataBase=数据库名"