Rrror while connectiong DB2 using ODBC

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:mad:

Hello,

It could be that the connection string that is required is different.

Have you checked here:

http://connectionstrings.com/

Gary