linking to ms access database using odbc adapters

[somersbar]

im trying to get a basic ASP.NET application running. im trying to
display data from a microsoft access database on my web form. im trying

to bind the data to a data-grid. but i get the following error wen i
try and run it:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.


Exception Details: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified


Source Error:


Line 55: Private Sub Page_Load(ByVal sender As System.Object, ByVal

e As System.EventArgs) Handles MyBase.Load
Line 56: DataSet11.Clear()
Line 57: OdbcDataAdapter1.Fill(DataSet11)
Line 58: DataGrid1.DataBind()
Line 59: End Sub


Source File: c:\inetpub\wwwroot\WebApplicationTest\WebForm1.aspx.vb
Line: 57


Stack Trace:


[OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified]
System.Data.Odbc.OdbcConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,

ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
WebApplicationTest.WebForm1.Page_Load(Object sender, EventArgs e) in

c:\inetpub\wwwroot\WebApplicationTest\WebForm1.aspx.vb:57
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


Line 57 is obviously the problem but i dont understand exactly what
"Data source name not found..." means or how to fix it.


can anyone help me please?

 

[kahtava]

What does your connection string look like?

Are you using the JET driver?

Have you installed the JET or other ODBC driver?

The following msg: "Data source name not found and no default driver
specified" indicates that there is a problem with your connection
string, or that you have not installed the respective ODBC driver...

 

[kahtava]

On another note....

To resolve your errors quicker I suggest you try googling the entire
error msg.

Try it... Google: "System.Data.Odbc.OdbcException: ERROR [IM002]"