Originally posted by: SystemAdmin

Hi all,

I am trying to connect oracle DB with OPL code in a file solver.dat wrote code DBConnection db("oracle11","username/password@Dbinstance");

I struck with fallowing error,

• ERRORDATA_103 at 7:74-75 C:\xampp\htdocs\project\Code\solver\solver.dat: Database error (state= code=0): ORA-12154: TNS:could not resolve the connect identifier specified

, near "username/password@dbinstance".

1. OPL exception: Processing failed.

Please can one can help to resolve it.....
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Hi

this is an Oracle error. Can you connect to your database with another tool like SQL*Plus?
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Hi,

First of all very thanks for you to reply.

Yes i can able to connect my Oracle DB with other tools.

But i cant able to connect while trying in this way ..

I am in urgency to finish this issue in time can please get me some Basic ideas to resolve it please
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

> I am trying to connect oracle DB with OPL code in a file solver.dat
> wrote code DBConnection db("oracle11","username/password@Dbinstance");
> I struck with fallowing error,
> ■ERRORDATA_103 at 7:74-75
> C:\xampp\htdocs\project\Code\solver\solver.dat: Database error (state=
> code=0): ORA-12154: TNS:could not resolve the connect identifier
> specified
> , near "username/password@dbinstance".

I am assuming that the DBConnection statement in your dat file has the correct connection string (actual values for username, password and DBinstance). After confirming this, please go through the possible causes for the ORA-12154 error as listed in the following site to see if they are leading to the error:

http://ora-12154.ora-code.com/
#DecisionOptimization
#OPLusingCPLEXOptimizer