Unable to connect with Jchem Manager -- ORA-12514 error

Hi,

I am unable to connect to our Oracle database with Jchem Manager.

I am hitting an Oracle ORA-12514 error (ORA-12514, TNS:listener does not currently know of service requested in connect descriptor). However, I can connect via other tools such as SQL Plus and SQL Developer. All other programs are able to connect to the database except for JChem Manager using the exact same connection URL.

Driver: oracle.jdbc.driver.OracleDriver

database URL: jdbc:oracle:thin:@//myDB:1521/MYSID

Any thoughts?

 

Thanks,

Guy

Hi Guy,

What about this url:

jdbc:oracle:thin:@myDB:1521:MYSID

? (http://www.chemaxon.com/jchem/doc/admin/JChemBaseFAQ.html#dburl)

Peter

You may also try removing the package name, "driver", from the Driver name:

Driver: oracle.jdbc.driver.OracleDriver

 

Jon

pkovacs wrote:

Hi Guy, What about this url: jdbc:oracle:thin:@myDB:1521:MYSID ? (http://www.chemaxon.com/jchem/doc/admin/JChemBaseFAQ.html#dburl) Peter

 

Thanks Peter.

It works now -- my bad.

The strange thing is that the other URL worked (sometimes)