先建立连接,再打开记录集。例如:
dim Cnn As New ADODB.Connection
dim rs as New ADODB.Recordset
Cnn.Open "driver={SQL Server};server=" & YourServer & ";uid=" & YourUid & ";PWD=" & pwd & ";database=" & YourDB
rs.open"select * from 表1",cnn
dim Cnn As New ADODB.Connection
dim rs as New ADODB.Recordset
Cnn.Open "driver={SQL Server};server=" & YourServer & ";uid=" & YourUid & ";PWD=" & pwd & ";database=" & YourDB
rs.open"select * from 表1",cnn
解决方案 »
- 自定义控件增加文件浏览框属性
- 如何获取一个窗口的句柄hWnd
- VB如何调用Data Report Designer
- 怎么样在一个VB程序中建立一个SQL SERVER数据库
- 如何在VB中获得本机或网络的SQL Server 2000 的服务器名称
- 简单问题:Option Explicit出现在哪里,作用是什么
- 又一个windows media player 问题
- 如何把 DataGrid 中的数据打印出来呢?在线等待。。。。。。
- 如何快速从access导出一张表,存放在Excel中?
- 十万火急!求高手指点!!!!想做一个用户登录的界面,可是会弹出错误,用的是access数据库
- 请斑竹或ACTIVEVB等超一流高手帮小弟看一下这个问题,万分感谢!!(关于勾子函数的问题))
- 请教高手:在vb中如何实现win2000的网上邻居登录??
'DSN-less Connection
'以SQL Server为例
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open "driver={SQL Server};server=server_name;uid=user_name;pwd=pwd;database=pubs" 'OLE DB Connection
'以SQL Server为例
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open "provider=sqloledb;data source=server_name;initial catalog=pubs;user id=user_name;password=pwd;" http://www.chaxiu.com/club/replan.php?boardid=15&planid=664
Dim rst As New ADODB.Recordset
Dim strsql As String
Dim strcnn As String
'还有这个也可以
'cnnstr = "Microsoft.Jet.OLEDB.4.0;Data Source=C:\phone\phone.mdb;Persist Security Info=False"
strcnn = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=c:\phone\phone.mdb;"
cnn.Open strcnn
strsql = "select 字段 from 表名"
rst.Open strsql, cnn, adOpenDynamic, adLockBatchOptimistic
dim rsTable as new adodb.recordset
stTable.open "DSN=MySampleDSN",3,1it's ok.