我用如下代码出错 Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=sky;Initial Catalog=northwind;User Id=sa;Password=;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from test", CN, adOpenDynamic, adLockBatchOptimistic
Set DataGrid1.DataSource = Rs
执行到CN.Open就出错,我的ODBC-SQL正常开启,为什么连不上各位大侠赐教
在线等候
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=sky;Initial Catalog=northwind;User Id=sa;Password=;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from test", CN, adOpenDynamic, adLockBatchOptimistic
Set DataGrid1.DataSource = Rs
执行到CN.Open就出错,我的ODBC-SQL正常开启,为什么连不上各位大侠赐教
在线等候
Dim CN As New ADODB.Connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic
Set DataGrid1.DataSource = Rs
Dim Rs As New ADODB.Recordset
这样定义
就可以省略
Set cn=new ADODB.Connection
set rs=new New ADODB.Recordset
么???
数据库在ODBC里别名是sky
数据库是SQL Server7.0帮忙看看哪里错了
CN.ConnectionString = "Provider=sqloledb;DSN=sky;Initial Catalog=northwind;User Id=sa;Password=;"
后CN.Open不出错了
但是Rs.Open "select * from test", CN, adOpenDynamic, adLockBatchOptimistic出错
提示“Invalid Object Name 'test'这是为什么??????????