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.Odbc.OdbcException: NO_DATA - no error information available

Thanks,
Krish

 

[Pat]

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

 

[Krish]

OdbcDataReader ddDR2 = null;
OdbcConnection cn = new OdbcConnection("DSN=TeacherCert;UID=dexkme;
PWD=viji123;DBQ=db2t");
OdbcCommand ddSqlCommand2 = new OdbcCommand ("SELECT cd_district FROM
depdb.km_zip_district", cn);
cn.Open();
ddDR2 = ddSqlCommand2.ExecuteReader(CommandBehavior.CloseConnection);
cboMajor.DataSource = ddDR2;
cboMajor.DataTextField = "cd_district";
cboMajor.DataValueField = "cd_district";
cboMajor.DataBind();
ddDR2.Close();

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

 

[Patrick.O.Ige]

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