问题描述
求教,如何用语句将远程ACCESS导入SQLSERVER2000,我用insertinto外观检测记录select*FROMOpenDataSource('Microsoft.Jet.OLEDB.4.0','DataSource=//IP/SharedDocs/mydatabase/TEST.MDB;UserID=admin;Password=;')...外观检测记录导入时,如果IP是本机地址这条语句可以顺利执行,如果是ACCESS与SQLSERVER2000不在同一电脑上则会出现错误,错误如下:Microsoft][SQLServer2000DriverforJDBC][SQLServer]OLEDB提供程序'Microsoft.Jet.OLEDB.4.0'报错。java.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC][SQLServer]OLEDB提供程序'Microsoft.Jet.OLEDB.4.0'报错。atcom.microsoft.jdbc.base.BaseExceptions.createException(UnknownSource)atcom.microsoft.jdbc.base.BaseExceptions.getException(UnknownSource)atcom.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(UnknownSource)atcom.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(UnknownSource)atcom.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(UnknownSource)atcom.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(UnknownSource)atcom.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(UnknownSource)atcom.microsoft.jdbc.base.BaseStatement.commonTransitionToState(UnknownSource)atcom.microsoft.jdbc.base.BaseStatement.postImplExecute(UnknownSource)atcom.microsoft.jdbc.base.BaseStatement.commonExecute(UnknownSource)atcom.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(UnknownSource)atcom.microsoft.jdbc.base.BaseStatement.executeUpdate(UnknownSource)atdb.Data.insert(Data.java:62)atSerialDemo.upLoad(SerialDemo.java:67)atSerialDemo.main(SerialDemo.java:34)求高手指教
解决方案
解决方案二:
先確定遠程可以select出資料。
解决方案三:
用远程调用吧RMI可以Access好像不支持远程访问,我没成功过,最后还是用RMI之类的搞定