Hi,

Ive set a up an ASP page which successfully connects to an Access Database. My problem is with a linked table in this database which is held in a Sequel Server Database (ODBC). I have the user and password for this server.

When I try to open the ASP page I get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL ServerMORRDEVELOPER' failed.
/ae_area_monitoring1.asp, line 60


Asp code is as follows:

Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("A_E_SOURCE.mdb")

Set rs_temp = Server.CreateObject("ADODB.Recordset")

str_sql_make_patdata = "SELECT dbo_PATDATA.* INTO PATDATA FROM dbo_PATDATA;"


'Open the recordset with the SQL query
rs_temp.Open str_sql_make_patdata, adoCon <----- error occurs here

Any ideas????

Many Thanks


Tim

__________________
Tim