Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > linking to ms access database using odbc adapters

Reply
Thread Tools

linking to ms access database using odbc adapters

 
 
somersbar@yahoo.com
Guest
Posts: n/a
 
      02-15-2006
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.asp x.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(IDbConn ection connection,

ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(O bject 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.asp x.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?

 
Reply With Quote
 
 
 
 
kahtava@gmail.com
Guest
Posts: n/a
 
      02-15-2006
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...

 
Reply With Quote
 
 
 
 
kahtava@gmail.com
Guest
Posts: n/a
 
      02-15-2006
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]"

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Supply Telephone Voice Modular Adapters,Telephone Modular Couplers,Modular Duplex Jack,Triplex Adapters,Telephone extension Cord samul888@vip.163.com Cisco 1 11-13-2005 09:23 AM
Supply Telephone Voice Modular Adapters,Telephone Modular Couplers,Modular Duplex Jack,Triplex Adapters,Telephone extension Cord samul888@vip.163.com Computer Support 0 11-12-2005 06:22 AM
Supply Telephone Voice Modular Adapters,Telephone Modular Couplers,Modular Duplex Jack,Triplex Adapters,Telephone extension Cord samul888@vip.163.com VOIP 0 11-12-2005 06:22 AM
Supply Telephone Accessories,Modular Adapters Couplers,Duplex Jack,Triplex Adapters,ADSL Adapters,Plug With RJ12 Jacks samul888@vip.163.com Cisco 0 11-10-2005 07:47 AM



Advertisments