Error when trying to open Access DB on web

[James Houston]

I'm trying to connect to an Access DB on my web site. I used FrontPage
2000's Database Results wizard, but the page it built just doesn't have the
features I need, so I've started setting up a page by hand. I snagged the
connection string out of the global.asa file and pasted it into my ASP code
like so:

dim sCon 'ado connection string
dim adoConn 'ado connection
set adoConn = server.createobject("adodb.connection")
sCon = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=CurrentShipped.mdb"
adoconn.open sCon

Which generates the following error message:
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 0x958 Thread 0xcf0
DBC 0x24cfafd4 Jet'.
/test.asp, line 95
Anybody know what I'm doing wrong and how to fix it? Any help would be
greatly appriciated.

Best,
JIm

 

[MD Websunlimited]

Hi James,

That error usually means that the database in open by someone else exclusively.

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Stop Spam Email Mining from your web pages with SpamStopper
http://www.websunlimited.com/order/product/SpamStopper/spam_stopper_help_dir.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible