powerpuffgirl

我作了一個Java程序使用JDBC_ODBC聯接Access的數據庫﹐在我的 Local computer上﹐我的Java Applet運行的很好。\n我在config.properties裡這樣定義的﹕
jdbc.dataSource=Access
jdbc.driver=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.db=jdbc: odbc:questMA97

但是﹐想把我的Java Applet發到網上﹐仍然想用Access的數據庫聯上JDBC-ODBC的Driver, 我就申請了一個固定的IP Host地址(lala.myftp.org)﹐我稍微把config.properties做了一點修改。前面兩行是一樣的﹐在最後一行是這樣改的﹕
jdbc.dataSource=Access
jdbc.driver=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.db=jdbc: odbc://lala.myftp.org/questMA97 (lala.myftp.org 為我的固定的Host地址)

運行沒有問題(那是一定的)﹐但當我聯接數據庫時有錯誤信息。
錯誤信息是這樣的﹕:confused:
No connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified。

怎麼回事呢﹖謝謝各位大俠的回答。 先謝過。

oiioiio

1.I am not sure odbc can be accessed remotely.maybe not?
2. did you include jdbc odbc bridge driver with your applet?
Just for your reference.

fanri

jdbc.db=jdbc: odbc://lala.myftp.org/questMA97 (lala.myftp.org 為我的固定的Host地址)

dose this mean that your access dB should be in your site root directory.
right for ref

powerpuffgirl

Thanks Frank, ifyou and fanri!

Actually "lala.myftp.org" is my static IP address, a solution for remote database connection with my own computer, is that wrong?

:confused:

nickwang

you should create a dsn on your own computer which point to the database server. so in the third line it should be the dsn name.

powerpuffgirl

The third line of config.properties : jdbc.db=jdbc: odbc://lala.myftp.org/questMA97, is exactly user DSN name.
  :confused: