Access db connection falure

[lordhuh]

using the connection string with {microsoft acesss.....} in it i get

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xda8 Thread 0x49c DBC 0x254d024 Jet'.


i have read several articles and have found this string is a very flaky one. so they say use this one

myconn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & server.mappath("nwind.mdb") & ";"

when i do this i get "unspecified error" everysingle time. It is driving me mad.

http://www.learnasp.com/learn/accessSQLserver.asp

i have run this test script on my server and found it to fail everysingle conenction. whereas it works on the server it resides on.

my copy of it is here

http://www.crantorland.com/valkyries/a/index.asp

Does any one have any ideas i have sp2 for windows 2k installed (problem was happening before and after sp2) and also have very latest version of jet. any suggestions. PLEASE Karl Pietri

http://www.crantorland.com

 

[link9]

This question has surfaced a few times before --

This may or may not be of help to you, but I used to get that error when I worked with Access databases, and it always meant one of two things:

(1) -- the database was currently open on another machine, and that had placed the db in a state that the JET engine was unable to open and read from it

(2) -- I had forgotten to explicitly close and destroy a connection object on a previous page, and (even though connection objects are SUPPOSED to be stateless) that had left the database in much the same state as the above situation... it never made any sense to me, and was a constant pain in the rear...

Actually, it was these types of problems that prompted me to go to the powers that be and flat out insist that we invest the money to get SQL Server --

I hope it helped --
Paul Prewett