Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / February 2006

Tip: Looking for answers? Try searching our database.

linking to ms access database using odbc adapters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
somersbar@yahoo.com - 15 Feb 2006 21:29 GMT
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@gmail.com - 15 Feb 2006 23:06 GMT
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@gmail.com - 15 Feb 2006 23:09 GMT
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]"

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.