Originally posted by: Nourredine

Hi guys,

I am trying to connect to connect SQL server database (e.g. Test) located on a server/instance (e.g. AAA is the server and BBB is the instance) using the connection string that is in the OPL documentation (DBConnection db("odbc","dataSourceName/userName/password"))

My connection string using oledb can stated as: DBConnection db("oledb","//Test/AAA\\BBB").

I tried to swap oledb with odbc: DBConnection db("oledb","//Test/AAA\\BBB"), but I got an error (

What would be the connection string to Test on AAA\BB?

Thanks,

Hi,

DBConnection db("oledb","userName/password/database/dbServer");

or

DBConnection db("odbc","dataSourceName/userName/password");

in IDE and OPL > Optimization Programming Language (OPL) > Language Reference Manual > OPL, the modeling language > Data sources > Database initialization

regards

Originally posted by: Nourredine

Thanks Alex it works now; the CPLEX (OPL) model can connect to SQL server database, the solution is found.

I have issue writing the solution to the same database using DBupdate. Below is the connection string, DBUpdate statement and the error message where trying to retreive the ouput from CPLEX and push it to the same database.

DBConnection DBConn_HiringProblem("odbc","Hiring_Problem/PC08XT7T\\SQL2008DEVDSKTOP//");

solution to DBUpdate(DBConn_HiringProblem, "insert into cplxo_hiring_problem_report(title, person, cost) values (?,?,?)");

Error:

Database error (state=22001 code=0): [Microsoft][ODBC SQL Server Driver]String data, right truncation, near "solution"

Hi,

this looks like a database issue.

Are you sure your columns in the database are big enough to hold the strings from OPL ?

regards