linking to ms access database using odbc adapters

Discussion in 'ASP .Net' started by somersbar@yahoo.com, Feb 15, 2006.

  1. Guest

    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?
    , Feb 15, 2006
    #1
    1. Advertising

  2. Guest

    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...
    , Feb 15, 2006
    #2
    1. Advertising

  3. Guest

    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]"
    , Feb 15, 2006
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ed Leafe

    Database adapters

    Ed Leafe, Jul 12, 2004, in forum: Python
    Replies:
    4
    Views:
    294
    Ed Leafe
    Jul 13, 2004
  2. =?ISO-8859-1?Q?Gerhard_H=E4ring?=

    Re: Database adapters

    =?ISO-8859-1?Q?Gerhard_H=E4ring?=, Jul 12, 2004, in forum: Python
    Replies:
    2
    Views:
    293
    =?ISO-8859-1?Q?Gerhard_H=E4ring?=
    Jul 13, 2004
  3. darrel
    Replies:
    0
    Views:
    386
    darrel
    Jan 30, 2007
  4. Richard Muller

    ASP linking to SQL Server using ODBC - problem

    Richard Muller, Oct 23, 2003, in forum: ASP General
    Replies:
    3
    Views:
    213
    Richard Muller
    Oct 26, 2003
  5. Wes Gamble
    Replies:
    1
    Views:
    151
    Gerardo Santana Gómez Garrido
    Apr 5, 2006
Loading...

Share This Page