Originally posted by: Krishnendu Mukherjee

Hi,

            To connect SQL database from OPL we need to add any .dat file and in the .dat file we need to write the two line code as per the manual:

                                 DBConnection db("oledb", "user/password/master/myserver\\SQLEXPRESS");

                                 Persons from DBRead(db,"select NAME,EMAIL,AGE from PEOPLE");

           where Persons is a tuple with the above attributes mentioned in the SQL string.

           For example, database name is tempdb, dbserver name is name of the computer or host name, and SQLEXPRESS is the instance name. Username and password is blank.

          Please let me know the connection string format as  " temdb/127.0.0.1\\SQLEXPRESS" is not working?

          Thanks,

Hi

which Cplex version ?

regards

Originally posted by: Krishnendu Mukherjee

Hi,

              I am using Cplex 12.6. and 12.8 on two different machines. Please let me know for both.

Regards,

Hi,

for 12.6 you could try

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

for 12.8 you should read

https://www.ibm.com/developerworks/community/forums/html/topic?id=b8018a82-9b9a-4830-8872-3f40eae608fc&ps=25

regards