I have a problem which is doing my head in. Basically I have 2 pages which use the same connection to open the database and an SQL statement to select records from 2 different tables. The code for the first page is as follows: Code:
Last night, 6 pm dedicated windows 2000 server rebooted and ever since I get an error with all my sites on that box that says:
ASP Error occurred 8/16/2005 10:39:16 AM in Microsoft JET Database Engine
Error number: -2147467259 (0x80004005) File: /demo3/funcs.asp, line 100 Unspecified error
The funcs.asp is the file that opens the access database to read from. I have tried all sorts of things to fix this and I need your help. I searched for this error but can't find any more than people having the problem.
I got Win2000 and I just developed an intranet solution installed on my web server (IIS). The application worked nicely and there were not any problems.
Few days ago I re - installed win2000 and I installed the IIS and my intranet solution but there is an error and the application doens't operate correctly with the Access database. When it tries to retrieve data from the database the following error appears:
Microsoft JET Database Engine (0x80004005) Unspecified error
The line of the code which is indicated by the error is the following: Code:
I have one activex control which fetches data from database and writes it in text file. This control i am using in my asp page. The page executes perfectly fine on my machine but when i execute it from different machine it gives me following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /changeprofile.asp, line 44
I am using MSAccess 2003 as my DB, ASP page my front end. My access file is in the temp folder which ahs IUSR_Machine permissions. My asp page works fine, connects to DB and retrieves what I want. Now, when I open my db file in Microsoft Access in Exclusive mode my ASP page doest establish a connection which is correct as exclusive open locks the files and prevents further connections. Upto here no problem.
Now when I close that opened Microsoft Access instance, my web page resumes working. If I refresh it, it works. The third time I refresh the page I get "Unspecified Error". Again if I refresh it works and again if I refresh I get "Unspecified error" when I debugged it fails at connection open. Code:
I've had some problems with an ASP site I've developed. Everything is pretty simple/basic, however, the box it is hosted on is very "neglected" to say the least (old NT 4.0 box, zero services, etc).
Anyway, I have these pages that worked fine until today. The pages are fed from an Access 2000 database. The system administrator's been switching all the DNS records for various boxes lately and was wondering if this could be the culprit giving me this error.
I know this error is often associated with I_USR account privileges, could they have been re-set during this process thus giving me the error? Or could it be something else?
we just transfered our ASP app from one server to another(test-production). we are getting this error. I searched a lot and found one microsoft article which said to detect if it is a permission problem or not, give the folder full control and check it, if the problem is resolved with full control the it is permission thingy.
I did the same and my problem went off and it wokrs fine, But my network admin says we cannot do bec it would be very dangerous and people could easily change things. we production is a win2003 server and we r using access db.
Generally, using DreamWeaver, it generates the ASP include file, with the variables, in the document I am modifying. That is where I am getting my problem. All this is was a simple insert into an Access DB. Only 2 items were being inserted. I listed the code below. Code:
I occassional get this error when trying to check passwords and usernames. It's not all the time, but occassional. I just updated the connection to the jet drivers. Code:
Has anyone seen this error before.we moved an ASP app from our internal test server onto the production and suddenly we are having this error. On our internal server we had no problems. we are using Server2003 with access database.
I'm getting an "Unspecified Error" on a page while attempting to read a db table. The error occurs on line 95 where I open the connection string. Code:
What the heck is that? I keep getting this error message and it say it is unspecified. It give me a line number and the line refers to a connection. The strange thing is is that this site is a copy of another one, and the only alteration was to the records in the DB.
I am getting Javascript Unspecified Error.I am getting this error only when Onbeforeunload function is called.When I click on OK button then this error doesnt comes up but in case if I click Cancel button this error pops up.It says:
Im recieving the following error, which I cant really see what im supposed to do.
Im making a simple form page to insert a record into my access database. I dont get why there is a problem cause i used a stock Dreamweaver object (dialog) to create the code...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
I've written an asp page to transfer values from a form into an Access .mdb file, and I'm getting this error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xe68 Thread 0x798 DBC 0x15c1024 Jet'.
I'm running Win XP with pretty much all critical and recommended updates.
I'm trying to learn from a book "Sams Teach Yourself E-Commerce Programming with ASP in 21 Days". I'm doing very poorly BTW.
Anyway, I am trying to create a login script so I can password protect a page but when I test the page in IIS, I get the following error:
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'. /TEST/checkpassword.asp, line 12
I have an ASP page (deleteselect.asp) that is set up to query an Access database, list the records in the table, and then create a link for each record that calls on another asp page (deletepublication.asp) and deletes the record from the database using the primary key (ID) field.
I got this exact same code to work for another page to delete users from the database. I copied the code exactly to create the delete publication page but then I started getting the error (the delete user page still works, just not the deletepublication page). Basically I have 2 tables in the dB, one called "users" and one called "publications", so I just changed the code accordingly and started getting the error.
This sounds quite complicated, but basically I can't figure out why one works, and the exact same code for another page doesn't work and generates this error: Code:
I m getting the following error when executing the below given code:
==== Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. =====
Error: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query.
I have xp professional with iis6.the folder is under wwwroot with asp file and mdb file. Is there something with permission and LDB?I have try everything with permission.