Unable to Obtain schemas erroe PLEASE HELP ME ...
843859Mar 7 2008 — edited Nov 20 2014Hi , 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...