473,545 Members | 1,981 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

question about ASP with ACCESS

Dear All,

My asp run smoothly before. But, now, I found the ASP page is not smoothly
recently.
Sometime if the ASP is requested to connect to Access, the page will prompt

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xdd8 Thread 0xae0
DBC 0x3a85074 Jet'.

What's going on? Thanks


--
Jul 22 '05 #1
4 3872

"Utada P.W. SIU" <wi******@hotma il.com> wrote in message
news:Oy******** ******@TK2MSFTN GP15.phx.gbl...
Dear All,

My asp run smoothly before. But, now, I found the ASP page is not smoothly
recently.
Sometime if the ASP is requested to connect to Access, the page will
prompt

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xdd8 Thread 0xae0
DBC 0x3a85074 Jet'.

What's going on? Thanks

Use a dsn-less connection instead.

Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=C:\temp\ yourdb.mdb;Pers ist
Security Info=False

<C:\temp\yourdb .mdb should be changed to the location of your database
file>

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook
Jul 22 '05 #2
Utada P.W. SIU wrote:
Dear All,

My asp run smoothly before. But, now, I found the ASP page is not
smoothly recently.
Sometime if the ASP is requested to connect to Access, the page will
prompt

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0xdd8 Thread
0xae0 DBC 0x3a85074 Jet'.

This error is Microsoft's way of telling you to stop using ODBC (I'm joking,
but seriously <g>)

Take John's advice and switch to OLE DB.

John, I never use that "Persist ... " attribute. To me, it's just extra
stuff to type. :-)

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #3
but i had used dsn-less already, here's my code

function get_connection( )
dim connection
dim cnString

cnString = "PROVIDER=MICRO SOFT.JET.OLEDB. 4.0;" & _
"DATA SOURCE=" & server.mappath( "..\projects\li b\db\data.mdb") & ";"

set connection = server.createOb ject("Adodb.Con nection")
connection.Open cnString

set get_connection = connection
set connection = nothing
end function

any question about above code?? thanks

--
Jul 22 '05 #4
Are you getting the same error with that code? What kind of comment do you
expect? See inline:
Utada P.W. SIU wrote:
but i had used dsn-less already, here's my code

function get_connection( )
dim connection
dim cnString

cnString = "PROVIDER=MICRO SOFT.JET.OLEDB. 4.0;" & _
"DATA SOURCE=" & server.mappath( "..\projects\li b\db\data.mdb") &
";"


The & ";" is not hurting anything but it is not needed.

If you are having a problem here, I suspect it is because you are using \ in
your url instead of /. Try:

"DATA SOURCE=" & server.mappath( "../projects/lib/db/data.mdb")

If that still produces an error, do

Response.Write cnString

and verify that the path produced is the valid path to your database. Also,
verify that the IUSR_machine account has Change permissions for the folder
containing your database. It needs to create, modify and delete the database
lock file (data.ldb) to permit multiuser activity.

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6433
by: Tcs | last post by:
My backend is DB2 on our AS/400. While I do HAVE DB2 PE for my PC, I haven't loaded it yet. I'm still using MS Access. And no, I don't believe this is an Access question. (But who knows? I COULD be wrong... :) I've tried the access group...twice...and all I get is "Access doesn't like ".", which I know, or that my query names are too...
11
4232
by: Mark Yudkin | last post by:
The documentation is unclear (at least to me) on the permissibility of accessing DB2 (8.1.5) concurrently on and from Windows 2000 / XP / 2003, with separate transactions scope, from separate threads of a multithreaded program using embedded SQL. Since the threads do not need to share transaction scopes, the sqleAttachToCtx family of APIs do...
18
7319
by: Andre Laplume via AccessMonster.com | last post by:
I have inherited a bunch of dbs which are are shared among a small group in my dept. We typically use the dbs to write queries to extract data, usually dumping it into Excel. Most dbs originated in MsAccess 97 or prior and have been converted to 2003. On occassion user 1 will open a db. When user 2 opens the db it will not let user 2...
10
3399
by: glenn | last post by:
I am use to programming in php and the way session and post vars are past from fields on one page through to the post page automatically where I can get to their values easily to write to a database or continue to process on to the next page. I am now trying to learn ASP to see if we can replace some of our applications that were written in...
7
2220
by: News | last post by:
Hello, I have to build a program with the future in mind and I need a bit of guidance from a guru or two. My program will start as a multi-user Windows Application built with VB.Net and using an Access 2002 database backend. The future will require that 1. The database be switched with minimal effort to SQL Server and 2. A Web Application...
29
2064
by: Greg | last post by:
Now can someone help me answer this question? Northwind Traders is a chain of department stores located around the country. It is setting up a new sales system cashiers will use to accept payments from customers. As a pilot project, you are creating a Windows application to implement a new sales system in one of the stores. You want to use...
10
3687
by: Rider | last post by:
Hi, simple(?) question about asp.net configuration.. I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm first start application the follow message shown. ========= Server Error in '/QuickStartv20' Application. -------------------------------------------------------------------------------- Configuration Error...
2
2424
by: russell.lane | last post by:
I'm building out a pretty standard n-tier web application. The stack includes application/presentation, biz logic, and data access layers on top of an SQL server back end. We want to use impersonation and delegation to forward the user's Windows login through all layers in the stack. To support this, I'm setting up a set of domain...
34
2543
by: Mathieu Trentesaux | last post by:
Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button remains desperatly grayed. It also seems impossible to open the library in another Access instance
6
1508
by: Bri | last post by:
I've just started checking this out. I've got it to work alright with one exception. It is a secured MDE, so I've setup all the INI file options for it. The problem is that the UserID I setup for it to use to do the version test, seems to need more than the claimed 'minimum rights'. I haven't figured out what specifically it needs rights to,...
0
7484
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7928
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7440
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7775
tracyyun
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...
0
5997
agi2029
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...
0
4963
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...
0
3470
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...
0
3451
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
726
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.