question about ASP with ACCESS

[Utada P.W. SIU]

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


--

[John Blessing]

"Utada P.W. SIU" <wi******@hotmail.com> wrote in message
news:Oy**************@TK2MSFTNGP15.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=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\yourdb.mdb;Persist
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

[Bob Barrows [MVP]]

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"

[Utada P.W. SIU]

but i had used dsn-less already, here's my code

function get_connection()
dim connection
dim cnString

cnString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;" & _
"DATA SOURCE=" & server.mappath("..\projects\lib\db\data.mdb") & ";"

set connection = server.createObject("Adodb.Connection")
connection.Open cnString

set get_connection = connection
set connection = nothing
end function

any question about above code?? thanks

--

[Bob Barrows [MVP]]

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=MICROSOFT.JET.OLEDB.4.0;" & _
"DATA SOURCE=" & server.mappath("..\projects\lib\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"