avatar
Help on JDBC:ODBC SOS# Database - 数据库
s*u
1
I am trying to connect to access database through JDBC:ODBC in a java
programm
I tried to connect to the following url:
JDBC:ODBC:MyServer;database=mydb.mdb
and establish the access file with corresponding server and filename.
but when I run the program, it keep on telling me the following:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
fou
nd and no default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3661)
at sun.jd
avatar
m*t
2
Did you create a data source with that specific name in your ODBC
settings?

【在 s**u 的大作中提到】
: I am trying to connect to access database through JDBC:ODBC in a java
: programm
: I tried to connect to the following url:
: JDBC:ODBC:MyServer;database=mydb.mdb
: and establish the access file with corresponding server and filename.
: but when I run the program, it keep on telling me the following:
: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not
: fou
: nd and no default driver specified
: at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3661)

avatar
s*u
3

I set up the data source with "ODBC datasource administrator". I added a MS
Access driver, setting as following:
DRIVER={Microsoft Access Driver (*.mdb)}
Server=MyServer
database=mydb
then I selected the file mymd.mdb to link to the datasource
source file named mydb.dsn was constructed by computer.
there must be something wrong, but i just don't know it

【在 m******t 的大作中提到】
: Did you create a data source with that specific name in your ODBC
: settings?

avatar
m*t
4
What is the name you gave to the data source? It has to be
the one you passed to the JDBC:ODBC bridge in your program.

【在 s**u 的大作中提到】
:
: I set up the data source with "ODBC datasource administrator". I added a MS
: Access driver, setting as following:
: DRIVER={Microsoft Access Driver (*.mdb)}
: Server=MyServer
: database=mydb
: then I selected the file mymd.mdb to link to the datasource
: source file named mydb.dsn was constructed by computer.
: there must be something wrong, but i just don't know it

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。