JDBC-ODBC Bridge driver & ODBC driver are two different installati

L

lse123

http://www.paphoscarhire.mobi/odbc-bridge2.jpg
desktop control panel settings, I have above URL (IMG) Settings
well, I need to run in my PC: Type 1 db driver Access / java[SE1.6] Desktop
Applications, what I need to install ?

I refer for Type 1, JDBC-ODBC Bridge driver.... Is it needed install and
Access 2003 ODBC driver (see URL) ...? How I understand if I already
installed it(?) since I do not know ? JDBC-ODBC Bridge driver & ODBC driver
are two different installations?

How to load driver in my program ? The below are correct for: Class.forName
& DriverManager.getConnection ?
Code:
 class  ResultSetDemo    {
public static void main (String  [ ] args)    {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn
=DriverManager.getConnection("jdbc:odbc:RedWines");  // DSN=RedWines
Statement  sttmnt  =  conn.createStatement (  );
I GET ERROR !
Code:
 C:\Users\User\Documents\TextBooks Data Files\The Web Warrior Guide to
Web Database Technolo
gies, 1st Edition\extract\Chapter06\Chapter>java ResultSetDemo
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax
error in FROM claus
e.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
at ResultSetDemo.main(ResultSetDemo.java:10)


C:\Users\User\Documents\TextBooks Data Files\The Web Warrior Guide to Web
Database Technolo
gies, 1st Edition\extract\Chapter06\Chapter>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top