Did you ever find a solution to this problem?  I'm running into exactly 
the same issue and can't seem to find a solution.  I'm trying to use ADO 
to run a stored procedure that should update my Access database using data 
from the linked Pervasive database.  The procedure runs fine from inside 
Access, but using the ASP page I get the 80004005 ODBC--connection 
to 'DSNNAME' failed.


> 
> I'm currently working on a project that uses an Access 2000 database 
with 
> links to tables maintained by an IBM AS/400 server. I'm designing this 
on a 
> laptop, so I'm using PWS to emulate a web server--I have yet to field 
the 
> system on an actual web server. I have a DSN configured to connect to 
the 
> AS/400 library where the data resides. The DSN works when I invoke 
queries 
> or view tables through Access, but not when I attempt to use it through 
my 
> ASP pages.
> 
> Basically, I can run a query stored in the Access database and get 
results 
> from the linked table.  However, when I invoke the query from an ASP 
file, 
> I get the following error:
> 
> Microsoft JET Database Engine error '80004005'
> 
> ODBC--connection to <DSN name> failed
> 
> When I try to access the AS/400 directly (not desirable for this 
project, 
> but worth trying to solve the problem), I get the following error:
> 
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> 
> [Microsoft][ODBC Driver Manager] Data source name not found and no 
default 
> driver specified
> 
> I keep thinking my PWS isn't configured correctly, but I've been unable 
to 
> find a solution on MSDN.  Any help would be appreciated!
> 
> Larry Hutson