写过一个类似的,以下代码可以调出数据库连接生成窗体,ADO那种 请你先引用Microsoft OLE DB Service Component 1.0 Type Library Dim DataLink As MSDASC.DataLinks Dim sConnect As StringOn Error Resume Next Set DataLink = New MSDASC.DataLinks sConnect = DataLink.PromptNew Set DataLink = Nothing If sConnect = "" Then Exit SubMsgBox sConnect If MsgBox("您真的要把你的数据库设置更改吗? " & _ "一旦更改数据完整性可能被破坏!", vbQuestion + _ vbYesNo, MsgCaption) = vbNo Then Exit Sub Call WriteINI("DATABASE", "ConnString", sConnect, SettingFile) ConnString = sConnect Set Conn = Nothing Set Conn = New ADODB.Connection Conn.ConnectionString = sConnect Conn.Open
Dim adoConnection As ADODB.Connection Dim strCon As string Dim strServer As String Dim strUserName As String '数据库用户名 Dim strPassword As String '数据库密码 Dim strDBName As String '数据库名 Dim strServer As String '服务器名 此处为"B"set adoConnection = Noting set adoConnection = New ADODB.ConnectionstrCon="Provider=SQLOLEDB.1;Persist Security Info=False;User ID _ =" & strUserName & ";pwd=" & strPassword ";Initial Catalog=" & strDBName _ & ";Data Source=" & strServer adoConnection.Open strCon要先引用ado
Dim adoConnection As ADODB.Connection set adoConnection = New ADODB.ConnectionadoConnection.Open "Provider=SQLOLEDB.1;Persist Security Info=False; User ID = 登录B机的用户名;PassWord=登录B机的密码;Initial Catalog=B机上的数据库名;Data Source="=B机名或IP"
Dim adoConnection As ADODB.Connection set adoConnection = New ADODB.ConnectionadoConnection.Open "Provider=SQLOLEDB.1;Persist Security Info=False; User ID = 登录B机的用户名;PassWord=登录B机的密码;Initial Catalog=B机上的数据库名;Data Source=B机名或IP"
请你先引用Microsoft OLE DB Service Component 1.0 Type Library
Dim DataLink As MSDASC.DataLinks
Dim sConnect As StringOn Error Resume Next
Set DataLink = New MSDASC.DataLinks
sConnect = DataLink.PromptNew
Set DataLink = Nothing
If sConnect = "" Then Exit SubMsgBox sConnect
If MsgBox("您真的要把你的数据库设置更改吗? " & _
"一旦更改数据完整性可能被破坏!", vbQuestion + _
vbYesNo, MsgCaption) = vbNo Then Exit Sub
Call WriteINI("DATABASE", "ConnString", sConnect, SettingFile)
ConnString = sConnect
Set Conn = Nothing
Set Conn = New ADODB.Connection
Conn.ConnectionString = sConnect
Conn.Open
Dim strCon As string
Dim strServer As String
Dim strUserName As String '数据库用户名
Dim strPassword As String '数据库密码
Dim strDBName As String '数据库名
Dim strServer As String '服务器名 此处为"B"set adoConnection = Noting
set adoConnection = New ADODB.ConnectionstrCon="Provider=SQLOLEDB.1;Persist Security Info=False;User ID _
=" & strUserName & ";pwd=" & strPassword ";Initial Catalog=" & strDBName _
& ";Data Source=" & strServer
adoConnection.Open strCon要先引用ado
set adoConnection = New ADODB.ConnectionadoConnection.Open "Provider=SQLOLEDB.1;Persist Security Info=False;
User ID = 登录B机的用户名;PassWord=登录B机的密码;Initial Catalog=B机上的数据库名;Data Source="=B机名或IP"
set adoConnection = New ADODB.ConnectionadoConnection.Open "Provider=SQLOLEDB.1;Persist Security Info=False;
User ID = 登录B机的用户名;PassWord=登录B机的密码;Initial Catalog=B机上的数据库名;Data Source=B机名或IP"