Error Question

[glenmac]

I've just started getttng this error when tryiong to access an Access DB. I have all the permissions set right and have not changed any code sice the last time I used the asp page. All help greatly appreciated.

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 0x96c Thread 0x9a4 DBC 0x205c514 Jet'

 

[NiteCrawlr]

please post the conn string

 

[glenmac]

This the string

Set dc = Server.CreateObject("ADODB.Connection&quot
Set rs = Server.CreateObject("ADODB.Recordset&quot

dc.Open "DBQ=" & Server.Mappath("DBase/databasenew&quot & ";Driver={Microsoft Access Driver (*.mdb)};"

 

[onpnt]

Hi glenmac
you need the ext. on the db like this
Server.Mappath("DBase/databasenew.mdb&quot
A language that doesn't affect the way you think about programming is not worth knowing.

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[glenmac]

Thanks onpnt I'm at work right now but wil give it a try.

 

[glenmac]

Nope same error. I know the code works because I use it on another server on another HD. Must be something in the registry but darned if I can find it. Oh well I'll keep looking.

 

[NiteCrawlr]

try this line.....

objconexapen "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.Mappath("DBase/databasenew.mdb&quot&";"

 

[entaroadun]

It seems like the server you have an error on is having a problem creating a temporary registry key to house the ODBC connection string information. The account you are running under on that server may not have sufficient permissions to create these volatile DSNs (but I doubt it).

When in doubt, use an OLEDB connection. NiteCrawlr provided a string right above my post.

 

[glenmac]

I tried your connection string NiteCrawlr but got this error this time. Thanks for trying

Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/Guestbook.asp, line 163

 

[NiteCrawlr]

could you post the code from your page?? line 155 - 170???

 

[glenmac]

This my code Including the different con strings I've tried that are commented out. I've lable them try 1 and 2 ( of course I didn't use the labels in the attempts). The first one works on another server.

<% response.buffer=true %>

<%
'declaring all database variables and opening connections

Set dc = Server.CreateObject(&quot;ADODB.Connection&quot
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot

dc.Open &quot;DBQ=&quot; & Server.Mappath(&quot;DBase/databasenew.mdb&quot & &quot;;Driver={Microsoft Access Driver (*.mdb)};&quot;
'(Try 2)dc.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot;&Server.Mappath(&quot;DBase/databasenew.mdb&quot&&quot;;&quot;
' (Try 3)dc.open &quot;DSN=guestbook;&quot;
%>

<%
' this script adds a record to database

openMethod = request.form (&quot;openMethod&quot
if openMethod = &quot;postMessage&quot; then 'this line checks if the ASP file should post a message

 

[glenmac]

oops I mean try 2 and 3

 

[NiteCrawlr]

you have to put everything in the same line..

 

[MadJock]

I had a very similar problem recently. I was getting the same error number with one of two description:
'unspecified error' or 'file in use'

It was to do with the permissions on the folder housing the database. The user accessing the page via ASP (that being iUser or similar) did not have permissions necessary to lock required parts of the database.

The internet user needs pretty much full permissions so they can create / amend / delete the LDB file created by Access.

Hope this helps,

Graeme website:

http://www.graeme-taylor.co.uk

 

[gfxser]

Hi!
I had the same error and foud solution at microsoft site.

&quot;
SYMPTOMS:
When you access a page that connects to an Access database, you may receive the following error message in the browser:

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 0x614 Thread 0x6c0 DBC 0x21dd07c Jet'.
(FileName), (LineNumber)


CAUSE:
The account that is being used to access the page does not have access to the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC registry key.


SOLUTION:
1.Start Registry Editor (Regedt32.exe).
2.Select the following key in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC

3.On the right click menu, click Permissions.
4.Type the required permissions for the account that is accessing the Web page.
&quot;

http://support.microsoft.com/support/kb/articles/Q295/2/97.asp

GFX

http://purex.dk/1