Hi,
I tried to use a listbox to display a column in MS Access 2000 nwind.mdb by
using ole DataAdapter, Connection and dataset controls. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." I put ole DataAdapter, Connection and dataset controls and fill
in the properties of the listbox. The only code I have is
OleDbDataAdapte r1.Fill(DataSet 11, "employees" ) in page_load sub. How can I
fix it?
By the way, I can use these objects in code to load data. I tried these
controls in window form, they worked. The only problem is when I use them
in a web form, the line OleDbDataAdapte r1.Fill(DataSet 11, "employees" )
caused error.
Thank you a lot.
Chris
Below is the error message:
Server Error in '/Web420' Application.
----------------------------------------------------------------------------
----
The Microsoft Jet database engine cannot open the file
'C:\web420\Nwin d.mdb'. It is already opened exclusively by another user, or
you need permission to view its data.
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.Ole Db.OleDbExcepti on: The Microsoft Jet
database engine cannot open the file 'C:\web420\Nwin d.mdb'. It is already
opened exclusively by another user, or you need permission to view its data.
Source Error:
Line 204: OleDbDataAdapte r1.Fill(DataSet 11, "employees" )
Source File: c:\inetpub\wwwr oot\web420\WebF orm1.aspx.vb Line: 204
Stack Trace:
[OleDbException (0x80004005): The Microsoft Jet database engine cannot open
the file 'C:\web420\Nwin d.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr)
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider()
System.Data.Ole Db.OleDbConnect ion.Open()
System.Data.Com mon.DbDataAdapt er.QuietOpen(ID bConnection connection,
ConnectionState & originalState)
System.Data.Com mon.DbDataAdapt er.Fill(Object data, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior)
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
web420.WebForm1 .Page_Load(Obje ct sender, EventArgs e) in
c:\inetpub\wwwr oot\web420\WebF orm1.aspx.vb:20 4
System.Web.UI.C ontrol.OnLoad(E ventArgs e)
System.Web.UI.C ontrol.LoadRecu rsive()
System.Web.UI.P age.ProcessRequ estMain()
----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.0.370 5.288; ASP.NET
1  1800  This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ed_P. |
last post by:
Hello
I have a Windows Form that I am trying to use to display data in a DataGrid object from an Access Database. I have created an OleDbCommand Object (with the appropriate Connection string) to Select the appropriate data. I then use a OleDbDataAdapater to Fill a DataSet object. My problem is that I can't seem to show the results of the query on my datagrid object. Here is Code
private void btnSearch_Click(object sender,...
|
by: Alpha |
last post by:
Hi,
I'm working on a Windows applicaton with VS 2003 on windows 2000. I have a
listbox that I have binded to a dataset table, "source" which has 3 columns.
I would like to display 2 of those columns, "scode" and "sname", as 1 column
(if not possible then 2 columns will be fine) in the listbox. Can the
listbox display 2 columns information from the dataset and how can I do that?
Also, I set the property of the listbox to selectionmode...
|
by: Alpha |
last post by:
I retrieve a table with only 2 columns. One is a auto-generated primary key
column and the 2nd is a string. When I add a new row to the dataset to be
updated back to the database. What should I do with the 1st column ? (Below
I have a "1" in place for now). Also, Does the datase.AcceptChanges();
updates the changes to the database? Which command do I use to update the
changes in dataset back to the Access database table? Thanks, Alpha...
|
by: Chuck Ritzke |
last post by:
Hi all,
I am getting an intermittant error after uploading a project from my
development machine. I click on a link which opens an aspx page that, upon
page load, reads a very small amount of data from an MS Access database,
using ODBC and a stored query. There is no problem on my development
machine. On the production server though, I get the intermittant error shown
below. If I click back and forth between the problem page and the...
|
by: M. David Johnson |
last post by:
I cannot get my OleDbDataAdapter to update my database
table from my local dataset table. The Knowledge Base
doesn't seem to help - see item 10 below.
I have a Microsoft Access 2000 database which indexes
computer magazine articles for personal reference.
I am developing a Visual Basic.NET program whose sole
purpose is to enter new records into the database. No
updates to existing entries, no deletions, and no display
| | |
by: Benoit Martin |
last post by:
I'm working on a project in VB.net connecting to a SQL Server 2000 database
that I can't modify
I created a dataset with a schema identical to the DB.
When trying to update the DB from the dataset using the dataAdapter.update
sub, I get an error.
The problem seems to be that one of the fields was named 'desc' which is a
reserved word for SQL.
I've been able to work around this design flaw 'till now but it looks like
the update sub can't...
|
by: Rico |
last post by:
I have tried to access a database using asp.net. after some entries like
120+, I got an unspecified error message. Anyone know what is happening, it
seems to be stuck at the same line even when i added a new line.
Here is the error message:
Server Error in '/sonamy' Application.
--------------------------------------------------------------------------------
Unspecified error
|
by: krajah |
last post by:
Need Help Here.......
I'm using visual C#:
How to insert the value that user have entered combobox and click button.The value will sent into database.This is in form1.
In form2,if click button it will display in listbox.There also got another button to to delete the value according the index have chose using cursour.
I'm using sql server 2005,the were connection problem.How to know the server name for my computer. Below is the coding I...
|
by: mark.norgate |
last post by:
Hello
I'm filling a data set in C# from an SQL database and then binding
this to a repeater. I have an OnItemCreated method on this repeater
and I am trying to get the value in a column called "ServiceFK".
However, it appears I can only use an index rather than a column name
which I am loathe to do. Can anyone help? Here's a sample of my code:
protected void Page_Load(object sender, EventArgs e)
{
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
| | |
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |
