Anyone using Studio 4 with MSAccess as DBMS?  
Author Message
mdrafn





PostPosted: 2003-12-6 5:16:00 Top

java-programmer, Anyone using Studio 4 with MSAccess as DBMS? Is anyone using the Studio4 (Community version, Windows NT) IDE for
building forms using an MS Access database to supply a JTable via
net.beans palette components (nBCachedRowSet or nJcdbRowSet)? (Using
the JDBC-ODCB bridge). I can succesfully connect and initialize
components--can see the tables and columns in the Runtime explorer
connection--but when I execute the form, all columns are blank.

Also, when GUI editing, if I try to set the TableModel using the
TableEditor tab and select the nBCachedRowSet component, I get the
following error: "Unable to fetch columns; SQL-server rejected
establishment of SQL-connection. PointBase." Why is it still looking
at Pointbase?

Here's how components are set:
connectionSource1
Database URL = jdbc:odbc:IM_EDITOR (this works with MSQuery, so ODBC
is good)
Driver = sun.jdbc.odbc.JdbcOdbcDriver (ok here)
nBCachedRowSet1
command = select * from IM (this also works in MSQuery)
Database URL = jdbc:odbc:IM_EDITOR
jTable1
selection Model = nBCachedRowSet1

Need more code?

I give up! I really want to use Access for the DBM due to other
issues, but I am running out of patience!
TIA
Frustrated...
Mark