Rrror while connectiong DB2 using ODBC

[PPCC]

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

"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/

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:

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

[gep13]

Hello,

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

Have you checked here:

http://connectionstrings.com/

Gary