NO_DATA error

[Krish]

Hi,

The sql returns value since i select primary key (cannot be null), but when
i try to bind with combo box i get following error.. i cant see data. Iam
using ODBC connection from asp.net to talk to DB2 database. Any help gurus

System.Data.Odb c.OdbcException : NO_DATA - no error information available

Thanks,
Krish

[Pat]

Krish maybe try posting some code..
That could help
Patrick

"Krish" <vi************ ***@GMAIL.com> wrote in message
news:uS******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

The sql returns value since i select primary key (cannot be null), but when i try to bind with combo box i get following error.. i cant see data. Iam
using ODBC connection from asp.net to talk to DB2 database. Any help gurus

System.Data.Odb c.OdbcException : NO_DATA - no error information available

Thanks,
Krish

[Krish]

OdbcDataReader ddDR2 = null;
OdbcConnection cn = new OdbcConnection( "DSN=TeacherCer t;UID=dexkme;
PWD=viji123;DBQ =db2t");
OdbcCommand ddSqlCommand2 = new OdbcCommand ("SELECT cd_district FROM
depdb.km_zip_di strict", cn);
cn.Open();
ddDR2 = ddSqlCommand2.E xecuteReader(Co mmandBehavior.C loseConnection) ;
cboMajor.DataSo urce = ddDR2;
cboMajor.DataTe xtField = "cd_distric t";
cboMajor.DataVa lueField = "cd_distric t";
cboMajor.DataBi nd();
ddDR2.Close();

I have already applying the info mentioned in microsoft kb article. It didnt
help
http://support.microsoft.com/default...;EN-US;q319243

"Pat" <na********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Krish maybe try posting some code..
That could help
Patrick

"Krish" <vi************ ***@GMAIL.com> wrote in message
news:uS******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

The sql returns value since i select primary key (cannot be null), but

when

i try to bind with combo box i get following error.. i cant see data. Iam
using ODBC connection from asp.net to talk to DB2 database. Any help
gurus

System.Data.Odb c.OdbcException : NO_DATA - no error information available

Thanks,
Krish

[Patrick.O.Ige]

Try going to:-
http://www.connectionstrings.com
And try if the connection string for ODBC could help
Patrick

"Krish" <vi************ ***@GMAIL.com> wrote in message
news:#S******** *****@TK2MSFTNG P15.phx.gbl...

OdbcDataReader ddDR2 = null;
OdbcConnection cn = new OdbcConnection( "DSN=TeacherCer t;UID=dexkme;
PWD=viji123;DBQ =db2t");
OdbcCommand ddSqlCommand2 = new OdbcCommand ("SELECT cd_district FROM
depdb.km_zip_di strict", cn);
cn.Open();
ddDR2 = ddSqlCommand2.E xecuteReader(Co mmandBehavior.C loseConnection) ;
cboMajor.DataSo urce = ddDR2;
cboMajor.DataTe xtField = "cd_distric t";
cboMajor.DataVa lueField = "cd_distric t";
cboMajor.DataBi nd();
ddDR2.Close();

I have already applying the info mentioned in microsoft kb article. It didnt help
http://support.microsoft.com/default...;EN-US;q319243

"Pat" <na********@hot mail.com> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Krish maybe try posting some code..
That could help
Patrick

"Krish" <vi************ ***@GMAIL.com> wrote in message
news:uS******** ******@TK2MSFTN GP10.phx.gbl...

Hi,

The sql returns value since i select primary key (cannot be null), but

when

i try to bind with combo box i get following error.. i cant see data. Iam using ODBC connection from asp.net to talk to DB2 database. Any help
gurus

System.Data.Odb c.OdbcException : NO_DATA - no error information available
Thanks,
Krish