Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to Obtain schemas erroe PLEASE HELP ME ...

843859Mar 7 2008 — edited Nov 20 2014
Hi , im trying to connect to my database in Ms Access using the JDBC-ODBC BRIDGE through the IDE netbeans 6.0.1 and am using the jdbc.odbc.JdbcOdbcDriver driver and use the database URL jdbc:odbc:Products1.I have already set up a User DNS in the Microsoft ODBC Administrator called Products1 and have used the select button to associate a schema with it.But when i try to add a connection it says the connection is established but the following error comes ups , which does not allow me to select the schema from the get schema and does not show the table on the services section but does show a connection......it shows the following error


"Unable to Obtain schemas . There is insufficient information to establish a connection to obtain a list of schemas Check database URL, User Name and Password Driver Message [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented."

I have seen this error question asked on the forum but no one answered it .. They just said that they solved it...I ve been up three nights trying to solve it...its for my dissertation project and any help would be much apprecieated...Thank you...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2008
Added on Mar 7 2008
4 comments
256 views