模块:
Option Explicit
sub ljdata()'连接数据库的过程
Dim cn As New ADODB.Connection
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=sa;password=fjzhqm89uiaz;Initial Catalog=db_zdtl;Data Source=datacenter"
……
end sub
Option Explicit
sub ljdata()'连接数据库的过程
Dim cn As New ADODB.Connection
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=sa;password=fjzhqm89uiaz;Initial Catalog=db_zdtl;Data Source=datacenter"
……
end sub
public cn As New ADODB.Connection
然后在过程(或函数)中
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=true;User ID=sa;password=fjzhqm89uiaz;Initial Catalog=db_zdtl;Data Source=datacenter"
我就是想在其他过程中 可以直接调用 cn 变量
老兄你有沒有引用ADO Object呀?