Originally posted by: HemanthKG
Hi,
I am unable to connect to a SQL Database using this in the dat file. Thanks for help in advance.
Error :
Description Resource Path Location Type
Data parsing error: syntax error, unexpected (identifier), expecting from or to.
DAT File content
DBConnection db("oledb","sa/Passwordmy@123/sample/localhost//MSSQLSERVER");
Products from DBRead(db,"Select Product from Promo");
Offers from DBRead(db,"'Select CombinationKey from Promo");
Cost from DBRead(db,"'Select Cost from Promo");
Profit from DBRead(db,"Select Profit from Promo");
#DecisionOptimization#OPLusingCPLEXOptimizer