Dear All,
I have installed iSeries Access ODBC Driver Version 11.00.08.00. I have created System DSN ODBC Connection to connect to DB2 database (JDE).
I have created macro in excel and added Micosoft Active X Library
Using below connection string
Code:
"Provider=MSDASQL.1;Persist Security Info=False;User ID=PPCC;PASSWORD=****;Data Source=Business Data - PROD;QueryTimeOut=0;"
i am able to connect to DB2 database of JDE.

But same connection string does not work in .net/
Code:
using System.Data.Odbc;

OdbcConnection cn = new OdbcConnection(
   "Provider=MSDASQL.1;Persist Security Info=False;User ID=PPCC;PASSWORD=****;Data Source=Business Data - PROD;QueryTimeOut=0;");

cn.Open();
OdbcCommand cmd = new OdbcCommand("SELECT COUNT(*) FROM TABLENAME", cn);
it is throwing error:
Code:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
what could be the reason and what is the worlaround.

I need help,Please

Regards,
PPCC