我用sa登陆,密码没错!调试vb是,出现以下问题,我不知道在那改选项!各位打下帮帮忙!You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column
Dim cn As ADODB.Connection Dim rst As ADODB.Recordset Dim msg As String Set cn = New ADODB.Connection cn.Open "Driver={SQL Server};Server=服务器名;Uid=sa;Pwd=;database=数据库名" Set rst = New ADODB.Recordset rst.Open Trim$(sql), cn, adOpenKeyset, adLockOptimistic 我是这样连接的不知道对你是否有用
这怎么知道你哪错了啊
是用 ADO+SQL SERVER2000 吧
Dim rst As ADODB.Recordset
Dim msg As String
Set cn = New ADODB.Connection
cn.Open "Driver={SQL Server};Server=服务器名;Uid=sa;Pwd=;database=数据库名"
Set rst = New ADODB.Recordset
rst.Open Trim$(sql), cn, adOpenKeyset, adLockOptimistic
我是这样连接的不知道对你是否有用