Exception accessing Access database


I am trying to connect to access database.

dim objcon as new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\ASPNET\banking.mdb")
dim objcmd as new OleDbDataAdapter("select * from Names", objcon)
dim ds as DataSet = new DataSet()
MyDataList.DataSource = ds.Tables("Names").DefaultView

The above is the piece of code where i am getting error
The error is
Source Error:

Line 10: dim ds as DataSet = new DataSet()
Line 11:
Line 12: objcmd.Fill(ds,"Names")
Line 13: MyDataList.DataSource = ds.Tables("Names").DefaultView
Line 14: MyDataList.DataBind()

Stack Trace:

[OleDbException (0x80004005): Unspecified error: E_FAIL(0x80004005)]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +154
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +57
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
ASP.AdoTest_aspx.Page_Load(Object obj, EventArgs e) in c:\inetpub\wwwroot\CustomControls\AdoTest.aspx:12
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724
This is the error ...I dont have any idea. I tried restarting IIS rebooting ..

Any One please help me..
Thnaks in advance
8/1/2003 6:00:22 PM
asp.net.access-datasource 4679 articles. 0 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 31

well first up I don't see you actually opening the connection. it shouldn't throw this error, but nonetheless, it's there....

RTFM - straight talk for web developers. Unmoderated, uncensored, occasionally unreadable

Jason Brown - MVP, IIS
8/2/2003 7:15:29 AM
Check your file, IIS, and Access permissions.

8/4/2003 11:53:28 PM

Similar Artilces:

accessing access
------=_NextPart_000_029B_01C29063.1E2098D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi! I am trying to access an access mdb file for the first time. I get the following error: Can't connect(dbi::ODBC:pfawtbls.mdb ), no database driver specified and DBI_DSN env var not set at jfa_data.pl line 147 for the code: my $dbh = DBI->connect( "dbi::ODBC:pfawtbls.mdb", "", "", ) or die "Unable to connect: ". $DBI::errstr. "<br>"; What am I missing? Thanks, Jer...

Access access
========== Hi, Everyone ... I'm going to lock this thread for now. If you have a question about working with Access in Web Matrix, please start a new thread in this forum. Otherwise, this thread will get to be unwieldy. Thanks! ========== Updated 6/29/03 Hello, everyone. I've been working with the new version of Web Matrix (version .6, build 812, available right now!). In particular, I've been playing with support for Microsoft Access, which is one of the great new features in the new release. I wrote up some notes on what I've found to share some of my experiences and to a...

accessing ACCESS database
Hi, I am trying to write a script that copies an information from ACCESS but it gives me the following error: Can't call method "Sql" on an undefined value at franowner.pl.txt line 4. Here's the script: use Win32::ODBC; $DSN="db1"; $db = new Win32::ODBC("db1"); $db->Sql("SELECT owner_first_name, owner_last_name FROM Owners WHERE ID=11"); if ($db->Error()) { print "Error: $db->Error"; } statement:\n$DBI:errstr\n"; ($ownerfname,$ownerlname) = $db->FetchRow(); print "Database results: first ...

How to access remote Access database?
Hello everyone, What are the permissions we have to give in the Acess db which is in remote? It would be really great if you share me some ideas. Have a good one. Thanks!!!    http://databases.aspfaq.com/database/why-can-t-i-access-a-database-or-text-file-on-another-server.htmlhttp://forums.asp.net/t/1381295.aspx...

Problem in accessing access database
Hi  I am establishing connection with MS access. MS Access Database is placed in the same directory as the project.Connection string is " "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=testdb.mdb"   But I am getting the error  the file "testdb.mdb" not found   Can anyone please tell me what is wrong with the connection string Regards KaranRegardsKaran GuptaFor .net,Javascript and Sql server articles and interview question visithttp://guptakaran21.googlepages.com/main Try putting the DB in the APP_Data folder or changing 'testdb.mdb&#...

Accessing an Access Database on Linux
------=_NextPart_000_000E_01C1DB0F.7665F3F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I need to access a MS Access Database residing on a Linux box and perform some queries. Any suggestions? Thanks in advance. ------=_NextPart_000_000E_01C1DB0F.7665F3F0-- ...

Centrailized access for access database
i want to convert a vb application into asp.net  and back end as access database.how to get an centrailzed access using access database and thru web forms.any help.  Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply helped you. any help would be more appericated Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply helped you. could not found any reply Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply helped you.  Any possible solutions would be more appreciated Jai Ganesh. J , GSD ,IndiaPlease Mark As Answer If my reply help...

Problems accessing access database
Running netware 6.1 with SP1A. When several users access the access database the second user tries to open you will receive a message that says there is a table that is exclusivly open by another user, so we can not open the document. How to make it work with databases. Is it possible that you are using an 4.90SP1 client? If yes, you should use 4.90SP1a instead -- Marcel (using XanaNews I can resist everything but temptation >Running netware 6.1 with SP1A. Actually 6.5 I suspect. -- Andrew C Taubman Novell Support Forums Volunteer SysOp http://sup...

Accessing a Microsoft Access Database
Hello all, I'm relatively new to the list, so I'm sorry if I'm going over old ground here ! I would like to use PERL to view information in a Microsoft Access Database and then use this information in other programs away from the Database. Trouble is, I'm slightly confused by all the information on offer and am not sure=20 of the best way to proceed to allow PERL to gain the information in the Database and I'm also unsure exactly what I need to install on the machine. Does anybody know of a useful web site that I can look at or does anybody have any simpl...

accessing MS Access from .net
hi I am accessing ms access data base which has a table called customers. when i try to insert data into the table i am gettign the error like "Operation must use an updatable query" and the line its showing is myOleDbcommand.ExecuteNonQuery() here is my code in page lode event Sub Page_Load(Sender As Object, E As EventArgs) Dim StrConnectString as String Dim strStatement as String strConnectSTring = "Provider=Microsoft.Jet.OLEDB.4.0;Password='';User ID=Admin;Data Source=C:\Inetpub\wwwroot\Srinu\WebApplication2\...

Accessing a MS Access database
Hi, I would like to do a lookup into an Access database, and display the result in a grid. I'm an embedded programmer being thrown into the world of .net, asp, VB, and databases so I don't know where to start :-) ...... can anyone help me ? Thanks. Really jus ta matter of making a connection, doing your query, and displaying results. Here is a sample from a module I use. The data is bound to a datagrid. Sub LoadSchedule() Dim strSrc As String = CType(Settings("src"), String) If Trim(strSrc) <> "" Then ...

accessing remote access database
Hi to all, When ever i need to add or delete something from the mdb file where I cant do it in my web site, i am downloading the mdb file, doing the modifications then uploading again.I want my code running on localhost to reach the mdb file on my web site and do any modifications. I have tried to replace the following code string path = Request.MapPath(@"mydb.mdb") with string path = Request.MapPath(@"http://www.mysite.com/mydb.mdb") but i get the error "A virtual path is expected. " Is there a way to reach a remotely hosted mdb file ?   Thanks in advance short answer : No,...

Remote Access access
Hello, Currently new in the Web Matrix world and I'm a little lost. I'm looking for a way to connect to my remote Access database (ISP hosted) through the Workspace pane. I have an IP adress, even DNS, but I have no idea of how to formulate it to open my connection. I'm usually using FrontPage XP who includes a connection wizard. Thanks for any help ! You can only connect to Access databases that you have file access to. This means they must be either on your local computer, or on a computer share you have access to. One solution is to copy the MDB file to your local computer,...

Access access prase
I first found the power of web matrix and access in .NET show 30 when I searched for web matrix on microsoft site. I just gasped. If you are going to create more functionality it would be wonderfull. Web matrix the one click webpage. Ill have to see or maybe someone can tell me has web matrix already got automatic Database URL linking, If not this would be cool.Hardware is not easy to pirate so it is cheep. Software isnt getting bigger because of complex features, Its growing to stop the pirates....

Web resources about - Exception accessing Access database - asp.net.access-datasource

Motor vehicle exception - Wikipedia, the free encyclopedia
The exception is based on the idea that there is a lower expectation of privacy in motor vehicles due to the regulations they operate. Additionally, ...

Podcast #42 – It’s The Exception That Proves The Rule
... Language and Usage , which was frustrated by the high number of certain types of questions that were coming in. Is this podcast the exception ...

RWW News: Marco Rubio Reiterates His Opposition To Rape Or Incest Exceptions - YouTube
http://www.rightwingwatch.org/content/marco-rubio-reiterates-his-opposition-rape-or-incest-exceptions Right Wing Watch reports on the extreme ...

Why Kevin Pietersen is the exception to the No Dickhead Rule
Something fascinating is going on in English cricket at the moment.

John Lomax 'gutted' for Issac Luke, but says finals no exception to rules
... missing a grand final to a 10-game suspension, but says the NRL judiciary must maintain consistency in its rulings and cannot make exceptions ...

India becomes the exception to US nuclear ban
President George Bush has agreed to share civilian nuclear technology with India, reversing decades of US policies designed to discourage countries ...

Is Richard Umbers, Bernie Brookes' replacement as Myer CEO, an exception?
Myer's CIO was recently elevated to the top job, but he's in a very small minority.

Men Need to Admit That Jian Ghomeshi Is No Exception
That men like Jian Ghomeshi are a terrible exception and if we as men simply stand up and say we are not as bad as that, or that we are not rapists ...

China, Thailand reach visa exception agreement
China, Thailand reach visa exception agreement People's Daily Online ... this at a forum on China's foreign diplomacy held in Beijing. Both ...

No exception allowed in graft crackdown: People's Daily
No exception allowed in graft crackdown: People's Daily - Ecns.cn ecns The expulsion of Ling Jihua from the Communist Party of China (CPC) ...

Resources last updated: 12/19/2015 10:40:08 PM