asp_database_setup thread: MS Access stored procedure can't connect to linked database
I am working with an Access database which is a subset of information from
a larger Pervasive database. The Access db contains the proper stored
procedures which connect to the linked Pervasive db and populate the db
using the most current info. What I want to do is create an admin web
page which will do the same thing. Problem is, when I call that stored
procedure using ASP code, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'VendorDSN'
failed.
Here's the relevant code:
-------------------------
<%
VendorDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("[path to database].mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open VendorDSN
Set Command = Server.CreateObject("ADODB.Command")
Command.ActiveConnection = VendorDSN
Command.CommandText = "[name of stored procedure]"
Command.CommandType = adCmdStoredProc
Command.Execute , , adExecuteNoRecords
%>
---------------------------
So it appears to connect to the Access db without any problem, but then
the stored procedure can't connect to the linked Pervasive DB.
Please help!