Dim strConn As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=1234;Data Source=127.0.0.1;Initial Catalog = test"
pubConn.Open strConn请问这个代码如何改,放在哪!
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=1234;Data Source=127.0.0.1;Initial Catalog = test"
pubConn.Open strConn请问这个代码如何改,放在哪!
解决方案 »
- 用VB来开发插件的问题
- vb在文件夹右键菜单中怎么增加分隔符?
- 关于声音文件图形编辑控件NCTWavplayer(收费控件),请问各位大哥,如何去掉烦人的弹出窗口
- 求助:如何把多个EXCEL里的数据合并到1个EXCEL的1个SHEET里?
- 关于创建对象实例
- 请高手指点怎样学好 windows API 函数
- 怎样做有安装序列号的安装文件?
- 十万火急!wise做安装程序,如何吧vb6引用的ocx,dll全部加进来呀?
- 高分求InstallShield Professional 7.0 正式版下载地址
- Mscomm控件的问题?
- 求教,将字符串中,某个特定字符替换成其他字符,如何实现!
- Datagrid怎样加复选框or按钮?
public pubConn As New ADODB.Connection
public rsTable As New ADODB.Recordset
public strSQL As String
Public Sub Main()
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=1234;Data Source=127.0.0.1;Initial Catalog = test"
pubConn.Open strConnEnd Sub
public strConn As String
public pubConn As New ADODB.Connection
public rsTable As New ADODB.Recordset
public strSQL As String
放在该模块的开头。
下面的代码放在你第一次要连接数据库的地方。以后就可以用pubconn这个变量了
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=1234;Data Source=127.0.0.1;Initial Catalog = test"
pubConn.Open strConn