ADO可以远程访问网络上共享的Acess数据库吗? 现在网络上有一共享的access数据库,我想使用ado访问,但是我把打开的source设为共享路径,如:\\10.0.0.125\ShareAccess\MyData.mdb,结果提示打开出错,是根本就不允许这样作还是我的程序有问题,请高手多多指教! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 a)MS Remote - Access (Jet) 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=;" www.csdn.net elite Reposted by: ghj1976 From: http://www.active.com.cn 小型散分... VC9中“新建工程”界面如何实现? 进程中利用WM_COPYDATA通信遇到的问题? 共享打开文件 CDialog::OnPaint();函数究竟做了什么 急问怎样实现放大缩小功能查看地图????????? [VC新手]问矢量轮廓描述与填充算法 ADO+ACCESS数据库,读录大量数据后,用CTreeCtrl来显示的问题! *.cue及*.bin的下载文件怎么打开? 请问,dll如何向对话框里的listbox增加内容 关于内存使用和sql server配置问题 哪里有简单又不错的安装程序制作工具下载?
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=;"
Reposted by: ghj1976
From: http://www.active.com.cn