Open an MS Access Linked Table via ASP

[Jason Whitaker]

I have a MS Access database. Within this database, I have
several linked tables that connect to a mainframe's
database. The linked tables use a DSN to connect to the
mainframe. I want to open the Access database and query
the linked tables from an ASP page. However, the DSN that
the linked tables use require a password. What should I
do? Here is a snippet of my code:

adoSiteCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\wwwroot2\GCCC
FORMS\events\eventsdb\eventsdb.mdb;Persist Security
Info=False;Jet OLEDB:Database Password=nunya"

'Create an ADO recordset object
Set rsSites = Server.CreateObject("ADODB.Recordset")

'SQL statement to query the linked table
strSiteSQL = "SELECT * FROM csrs_site;"

rsSites.CursorLocation = 3 'adUseClient

'Open the recordset with the SQL query
rsSites.Open strSiteSQL, adoSiteCon

When I run the ASP page, I get the following error:
Microsoft JET Database Engine error '80004005'
ODBC--connection to 'csrsdsn' failed.

I'm assuming this is because I'm not giving the DSN (that
the linked tables use to connect to the mainframe) a
password.

[Ken Schaefer]

Does this help:
[url]http://support.microsoft.com/?id=245587[/url]
How To: Supply User Authentication when Opening Jet Linked Tables to ODBC
Datasources

Cheers
Ken


"Jason Whitaker" <jason.whitaker@titan.com> wrote in message
news:05fc01c3459f$8dc1a2a0$a301280a@phx.gbl...
: I have a MS Access database. Within this database, I have
: several linked tables that connect to a mainframe's
: database. The linked tables use a DSN to connect to the
: mainframe. I want to open the Access database and query
: the linked tables from an ASP page. However, the DSN that
: the linked tables use require a password. What should I
: do? Here is a snippet of my code:
:
: adoSiteCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
: Source=D:\wwwroot2\GCCC
: FORMS\events\eventsdb\eventsdb.mdb;Persist Security
: Info=False;Jet OLEDB:Database Password=nunya"
:
: 'Create an ADO recordset object
: Set rsSites = Server.CreateObject("ADODB.Recordset")
:
: 'SQL statement to query the linked table
: strSiteSQL = "SELECT * FROM csrs_site;"
:
: rsSites.CursorLocation = 3 'adUseClient
:
: 'Open the recordset with the SQL query
: rsSites.Open strSiteSQL, adoSiteCon
:
: When I run the ASP page, I get the following error:
: Microsoft JET Database Engine error '80004005'
: ODBC--connection to 'csrsdsn' failed.
:
: I'm assuming this is because I'm not giving the DSN (that
: the linked tables use to connect to the mainframe) a
: password.