Originally posted by: adgadg

I have following error for the 'oil blending' example from ILOG OPL.

Database error (state=IM002 code=0): MicrosoftODBC Driver Manager Data source name not found and no default
driver specified, near "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\temp\ilog\oil-tmp\oilDB.mdb//"

I use in a .dat file:
DBConnection db("access","oilDB.mdb");

The oilDB.mdb is present at C:\temp\ilog\oil-tmp

In general, the ILOG / CPLEX documentation is not sufficient clear at this point.

Microsoft access is installed on my system and I can open the oilDB.mdb.

Regards,
Ad.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: Brummel

Hi Ad,

you will most likely need to download an up-to-date driver.

Go to: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

After that, it should work.

Regards,

Sven
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: gwangya

What if I run on windows 7 - 64bit and the MS access 2010 installed on my PC is 32 bit?

CPLEX installed on my PC is 64bit.

This is my environment and I can't connect to my access DB.  Any clarification?

#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: Y7KC_Yan_Feng

I have the same problem with connecting ILOG OPL to Access Database.

I run the Oil example from ILOG OPL, I receive the following error:

Yan

#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: hoangho

me too :( how to solve this ?

#DecisionOptimization
#OPLusingCPLEXOptimizer