Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: MS Access stored procedure can't connect to linked database


Message #1 by "Josh Dutcher" <josh.dutcher@e...> on Wed, 14 Aug 2002 21:19:24
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!

  Return to Index