远程连接access的问题，请帮忙！！

Question

Statement stmt;
PreparedStatement pstmt;
ResultSet rs;    
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc://172.16.6.152:5000/student"; String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=172.16.6.182:5000/d:/hh/student.mdb"; 这个url应该是什么啊，怎么也连不上。请帮忙！！

Answer 1

错误提示是：
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 文件名无效。
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3028)
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3
23)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at studentsmanager.DBOP.InquirePsw(DBOP.java:92)
        at studentsmanager.LoginFrame$4.actionPerformed(LoginFrame.java:123)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:17
64)
        at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(Abstra
ctButton.java:1817)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:419)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257
)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:245)
        at java.awt.Component.processMouseEvent(Component.java:5093)
        at java.awt.Component.processEvent(Component.java:4890)
        at java.awt.Container.processEvent(Container.java:1566)
        at java.awt.Component.dispatchEventImpl(Component.java:3598)
        at java.awt.Container.dispatchEventImpl(Container.java:1623)
        at java.awt.Component.dispatchEvent(Component.java:3439)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450
)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
        at java.awt.Container.dispatchEventImpl(Container.java:1609)
        at java.awt.Window.dispatchEventImpl(Window.java:1585)
        at java.awt.Component.dispatchEvent(Component.java:3439)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
        at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:197)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:150)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)        at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)

Answer 2

172.16.6.182:5000/d:/hh/student.mdb
这样子写可以吗?
又是IP地址
但是却加上d:
????

Answer 3

哈哈，搞定了，用ODBC远程配置数据库就行了，谢谢啦！！！

Answer 4

因为你是用的jdbc:odbc,当然要配置ODBC再使用这个url:
String url="jdbc:odbc://172.16.6.152:5000/student";