Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 28th, 2005, 03:57 AM
Authorized User
Join Date: Jun 2003
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access MDB with a Linked SQL Server Table.....


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking in Access DB linked to SQL Server backend gibbers Access 3 April 24th, 2007 03:20 PM
MS Access .mdb calling SQL server 2000 stored proc fazzou Access 6 September 8th, 2006 11:32 AM
create SQL Server table from Access PorcupineRabbit SQL Server DTS 2 December 30th, 2005 06:11 AM
Access and update linked SQL Server 2000 table Lizu Access 9 May 10th, 2004 12:42 PM
copy table from one access .mdb to another jimsparks Classic ASP Databases 2 July 26th, 2003 05:22 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.