各位高手,在Remote OLE DB Provider Connections数据库链接方式中,http://carl2中的carl2具体应该怎样写,服务器端具体应该怎样配置?
i)ODBC DSN:
oConn.Open Remote Server=http://carl2; & _
Remote Provider=MSDASQL; & _
DSN=AdvWorks; & _
Uid=admin & _
Pwd=;
ii)OLE DB Provider:
oConn.Open Provider=MS Remote; & _
Remote Server=http://carl2; & _
Remote Provider=Microsoft.Jet.OLEDB.4.0; & _
Data Source=\somepath\mydb.mdb;, _
admin,
iii)OLE DB Provider自定义事务对象
oConn.Open Provider=MS Remote; & _
Remote Server=http://carl2; & _
Handler=MSDFMAP.Handler; & _
Data Source=MyAdvworksOLEDBConnectTag;
b)MS Remote - SQL Server
i)ODBC DSN:
oConn.Open Remote Server=http://carl2; & _
Remote Provider=MSDASQL; & _
Network Library=DBMSSOCN; & _
DSN=Pubs; & _
Uid=sa & _
Pwd=;
ii)OLE DB Provider
oConn.Open Provider=MS Remote; & _
Remote Server=http://carl2; & _
Remote Provider=SQLOLEDB; & _
Network Library=DBMSSOCN; & _
Data Source=carl2; & _
Initial Catalog=pubs; & _
User ID=sa; & _
Password=;
**************************************************************************
i)ODBC DSN:
oConn.Open Remote Server=http://carl2; & _
Remote Provider=MSDASQL; & _
DSN=AdvWorks; & _
Uid=admin & _
Pwd=;
ii)OLE DB Provider:
oConn.Open Provider=MS Remote; & _
Remote Server=http://carl2; & _
Remote Provider=Microsoft.Jet.OLEDB.4.0; & _
Data Source=\somepath\mydb.mdb;, _
admin,
iii)OLE DB Provider自定义事务对象
oConn.Open Provider=MS Remote; & _
Remote Server=http://carl2; & _
Handler=MSDFMAP.Handler; & _
Data Source=MyAdvworksOLEDBConnectTag;
b)MS Remote - SQL Server
i)ODBC DSN:
oConn.Open Remote Server=http://carl2; & _
Remote Provider=MSDASQL; & _
Network Library=DBMSSOCN; & _
DSN=Pubs; & _
Uid=sa & _
Pwd=;
ii)OLE DB Provider
oConn.Open Provider=MS Remote; & _
Remote Server=http://carl2; & _
Remote Provider=SQLOLEDB; & _
Network Library=DBMSSOCN; & _
Data Source=carl2; & _
Initial Catalog=pubs; & _
User ID=sa; & _
Password=;
**************************************************************************
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货