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 ?
I GET ERROR !
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 ( );
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>