Dim conn As ADODB.Connection
Const connectString = "udi=;pwd=;drive{SQLServer};server=local;database=vbPrac;dsn=,,connection=adConnectAsync"Private Sub Form_Load()
With conn
.ConnectionString = connectString
.ConnectionTimeout = 10
.Open
End With
End Sub运行显示Error:object variable or with block variable not set
Const connectString = "udi=;pwd=;drive{SQLServer};server=local;database=vbPrac;dsn=,,connection=adConnectAsync"Private Sub Form_Load()
With conn
.ConnectionString = connectString
.ConnectionTimeout = 10
.Open
End With
End Sub运行显示Error:object variable or with block variable not set
解决方案 »
- SysTray.ocx作出的托盘图标可以闪动么?高分在线等待。。。
- vb中数据库代码问题
- chenyu5188(来自东方的狼)请进,达人也请进?
- 下面的代码为何只进纸而确无法打印???
- 有谁能给我全加上注释
- 怎么样能使命令按钮每按一次都会在"显示"和"隐藏"之间变换!!!??
- 一个关于VB控件VsFlexGrid的问题。
- vb中怎么样做dll 并注册呢
- 一个菜鸟级的小问题~!
- 现在怎么了,我写个UPDATE也说我 不允许回复为空!!不允许有 gz、up!!!!来点创意吧!!!
- 控件mscomm来循环传输数据的解决方法?
- VB如何读取ACCESS数据库中的二进制图片,并在PICTUREBOX中显示出来
Set Conn = New ADODB.Connection对象需要实例化
Dim conn As new ADODB.Connection
set conn=createobject("ADODB.Connection")
Const connectString = "udi=;pwd=;drive{SQLServer};server=local;database=vbPrac;dsn=,,connection=adConnectAsync"Private Sub Form_Load()
With conn
.ConnectionString = connectString
.ConnectionTimeout = 10
.Open
End With
End Sub
但我调试只能通过DSN连接ODBC,请问能不能直接连SQL Server啊?
明明是装了SQL Server的,而且运行正常,在其中也创建了vbPrac这个数据库,但上面的语句调试总是显示找不到