Re: Problem in connecting DataBase through ODBC

Caddre — Sat, 23 Apr 2005 20:49:00 GMT

Try this url for samples with DSN. Hope this helps.

http://www.carlprothman.net/Default.aspx?tabid=81

Problem in connecting DataBase through ODBC

adnan152 — Sat, 23 Apr 2005 10:29:02 GMT

Hii,

I am using DBase database throught Odbc in ASP.NET. But it gives following error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Note that, I have applied same code in WindowApplication using C#. In WindowApplication it works properly and gives no error. It gives error olny in WebApplication. I have also tried Access Database using Odbc in ASP.NET and WindowApplication. Here is also the same problem.

My code is here for binding data in DataGrid.

void BindDg()

{

string conStr = "MaxBufferSize=2048;FIL=dBase 5.0;DSN=newdbase;PageTimeout=5;DefaultDir=C:\\ORIGINAL;DBQ=C:\\ORIGINAL;DriverId=533";

OdbcConnection con = new OdbcConnection(conStr);

string qry = "SELECT ACCOUNTNO, COMPANY, CONTACT FROM Contact1";

OdbcCommand cmd = new OdbcCommand();

cmd.CommandText = qry;

cmd.Connection = con;

OdbcDataAdapter adapter = new OdbcDataAdapter();

adapter.SelectCommand = cmd;

DataSet ds = new DataSet();

adapter.Fill(ds);

this.DataGrid1.DataSource = ds;

this.DataGrid1.DataBind();

}

Data Access and ObjectDataSource Control

Re: Problem in connecting DataBase through ODBC

Problem in connecting DataBase through ODBC