Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." 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 Basics 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 May 24th, 2004, 12:23 PM
Registered User
 
Join Date: Jul 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADODB.record error

I am working the examples in the Beginning ASP book in chapter 14 page 615 and 619. I am getting this error: "Error Type:
ADODB.Record (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/BegASP/CreateBackup.asp, line 15"

I found an old thread in the archives with this error that said to make sure I ws on MDAC 2.5 or greater. I have installed MDAC 2,8 and still get this error. Any ideas anyone?
 
Old May 24th, 2004, 01:09 PM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

How about posting your code or at least your connection string (if DSNless).

 
Old May 24th, 2004, 01:22 PM
Registered User
 
Join Date: Jul 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry, here it is

<%
  Dim objStream, objRecord, strURLofFile, strURLofBackup, strText, strDateStamp
  strURLofFile = Request.Form("URLofFile")
  strURLofBackup = Request.Form("URLofBackup")

  set objRecord = Server.CreateObject("ADODB.Record")
  objRecord.Open "", "URL=" & strURLofFile
  objCopyRecord "", strURLofBackup,,, adCopyOverWrite
  objRecord.Close
  Set objRecord = Nothing
 
Old May 25th, 2004, 04:53 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Tachtenberg,

Based on the code you posted, I couldn't get to know what you are trying to do there. But this could help you in a way. Please take a look at this.

http://support.microsoft.com/default...b;EN-US;248255
(HOWTO: Use the ADO Recordset, Record and Stream Objects to Open Documents)

Hope that Helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection
 
Old May 26th, 2004, 08:04 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 171
Thanks: 0
Thanked 1 Time in 1 Post
Default

Change

set objRecord = Server.CreateObject("ADODB.Record")

to

set objRecord = Server.CreateObject("ADODB.Recordset")

for starters.

----

The rest I can't tell for sure, but are you trying to copy a record?





Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB.Recordset error lance Wrox Book Feedback 2 February 23rd, 2007 02:37 PM
ADODB.RecordSet -- Error nabeeljohn Classic ASP Professional 10 November 9th, 2006 05:23 AM
Get the error "ADODB.Recordset error '800a0e7d' " Raymond Classic ASP Databases 2 August 5th, 2006 03:53 PM
How to get adodb.record from adodb.recordset John Pennington Pro VB Databases 1 November 20th, 2004 06:17 AM
ADODB.Record (0x800A0E7A) error toma BOOK: Beginning ASP 3.0 1 May 24th, 2004 03:43 PM





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