再程序中分别打开两个连接对象,连接不同的数据库,
CString m_sConnectString=_T("Provider=sqloledb;Data Source=dbserver;Initial Catalog=DataBase;User Id=xx;Password=xx;");
m_pConn->ConnectionString=_bstr_t(m_sConnectString);
m_pConn->Open("","","",-1);是打开sQl Server
用另外的m_pConn1->Open(Access数据库)
CString m_sConnectString=_T("Provider=sqloledb;Data Source=dbserver;Initial Catalog=DataBase;User Id=xx;Password=xx;");
m_pConn->ConnectionString=_bstr_t(m_sConnectString);
m_pConn->Open("","","",-1);是打开sQl Server
用另外的m_pConn1->Open(Access数据库)
' Initialize variables.
Dim cn As New ADODB.Connection
Dim provStr As String' Specify the OLE DB provider.
cn.Provider = "sqloledb"' Specify connection string on Open method.
ProvStr = "Server=MyServer;Database=northwind;Trusted_Connection=yes"
cn.Open provStr再建一个DSN连本地