JDBC:ODBC

J

John

I have created a number of databases in that I would like to make available
through the Sun JDBC:ODBC Driver.
After numerous attempts at configuring the databases as a Datasource I can
find no way of enabling this.
Everything works fine if I use the sample VISIO database shipped with Office
2003 but none of the databases I have creqted will allow another program to
view the schema or metadata info.
Any help would be appreciated.
 
J

John

Windows XP Professional
Access 2003
ODBC Data source tried configuration as user and system with and without
system database and with and without Admin password
I have admin rights on the computer but have not changed any Access settings
from default install.
Using Pentaho Kettle configuration utility to connect through ODBC
Can connect to the database with success but fails with an ODBC reported
error.
Using NetBeans configuration utility to connect through ODBC
Can connect to database but fails with the following response.
"There is insufficient information to establish a connection to
obtain a list of
schemas. Check database URL, user and password.
Driver message: [Microsoft][ODBC Access Driver]Optional feature not
implemented"
Each of the above will connect to the VISIO sample database as shipped with
the VISIO install major differecne is it is a 2000 database.
Examined all security settings on VISIO and compared to created databases
and detected no difference in the settings. The system tables are set to View.
Each of the above have no trouble connecting to MySQL or Postgress.
Is there a native Windows test tool for the ODBC configured connections?

Thanks for your response and I hope this info can lead to an answer.
 
Top