Re: help: beans accessing database

[Chay Weei Jye <wjchay@geocities.com>]

ok, I've switched to MS Access 97 ODBC driver ver. 4.x. My codes are still
the same, i.e.
            strSQL = "SELECT ProductName FROM Product";

            Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection connect;
            connect = DriverManager.getConnection( "jdbc:odbc:test" ,
"admin" , "sa" );
            etc.

However, when I run my test application ->  java.sql.SQLException: Column
not found

The SQL query is definitely correct. What else could cause the problem? I
have even tried other forms of SQL i.e. "select * from product", "select
Product.ProductName from Product".

Has anyone experienced any problem like this before? Thanks.

Carsten Heyl wrote:

> >java.sql.SQLException: Specified driver could not be loaded due to
> >system error 126 (Oracle73).
> >
> >But this works with Test.java application.
>
> Wheres the driver in (jar? dir?)?
> Whats your repository settings/intargs?
>