Devart Oracle License setup

Hello all,

I am adding an Oracle DB connection to JChem4Excel and running into an error (see below for stack trace). There appears to be an issue with the license for the Devart oracle driver. What steps do I need to take to get the driver licensed properly? FWIW: I am able to connect to the database without any problems through the JChem manager software.

Thanks,

--Josh

 

JChem4Excel version: 15.2.900.2335

 

Exception: ChemAxon.NET.Base.Exceptions.OpenDatabaseConnectionCxnException

Message: Could not open connection to database.

StackTrace:    at ChemAxon.NET.Base.Data.Oracle.AbstractAdoNetDataProviderWithConnection`1.OpenConnectionIfClosed()  at ChemAxon.NET.Base.Data.Oracle.Schema.OracleSchemaProvider.†††

†††‰˜†(Object )

   at ChemAxon.NET.Base.Data.Oracle.Schema.OracleSchemaProvider.FillSchema()

   at ChemAxon.NET.Base.Search.DatabaseSchemaModel.†††
†††Ž†‘(Object )   at ChemAxon.NET.Base.Search.DatabaseSchemaModel.FillSchema(ConnectionInfoDatabasePair cidp)

   at ChemAxon.NET.Base.Search.DatabaseTree.DatabaseTreeViewModelPresenter.†††

†††œ(Object , Object )

   at ChemAxon.NET.Base.Search.DatabaseTree.DatabaseTreeViewModelPresenter.FillSchema(ConnectionInfoDatabasePair cidp)
Exception: Devart.Data.Oracle.OracleException

Message: License not valid due to the problems with dotConnect for Oracle installation.

StackTrace:    at Devart.Data.Oracle.OracleConnection.Open()

   at ChemAxon.NET.Base.Data.Oracle.AbstractAdoNetDataProviderWithConnection`1.OpenConnectionIfClosed()

 

dd

Hi Josh,

 

please try to change the driver to Oracle JDBC:

 

http://www.chemaxon.com/jchem4excel/userguide/database_connection.html

http://www.chemaxon.com/jchem4excel/userguide/connecting_to_an_oracle_db.html

 

Viktor

hamoriviktor wrote:

Hi Josh,   please try to change the driver to Oracle JDBC:   http://www.chemaxon.com/jchem4excel/userguide/database_connection.html http://www.chemaxon.com/jchem4excel/userguide/connecting_to_an_oracle_db.html   Viktor

Worked. Thank you!