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 January 12th, 2004, 04:33 AM
Registered User
 
Join Date: Jul 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADODB.Recordset (0x800A0E7A) Error in chapter 2

I have just bought the book and follow the step in the book.
My system is windows XP and IIS 5.1. The example in chapter 2. I got the error as following:

ADODB.Recordset (0x800A0E7A)
Provider cannot be found. It may not be properly installed.

What have I done wrong? Thanks in advance

 
Old January 14th, 2004, 08:12 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Probably just a typo in your connection string. If you can't see anything wrong with it then post it here and we'll take a look.
 
Old January 14th, 2004, 10:36 PM
Registered User
 
Join Date: Jul 2003
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you so much.
I have checked the code again. I typed it correctly.

Here is the code:

<%@Language=VBScript%>
<html>
<head>
<title>Home Page</title>
</head>
<body>
<p>This line from HTML</p>

<p>Next line from ASP will work<br>
if ASP extensions installed correctly:<br>
<%
response.write "<b>From ASP</b>"
%>

<p>Next line from ADO will work if a DSN named sailors has been set<br>
for the database which is named SAILORS.MDB.</p>
<%
set oRS=server.createobject("ADODB.recordset")
oRS.open "Select * from People", "DSN=sailors"
oRS.movefirst
response.write "<b>" & oRS("PeopleNameLast") & "</b>"
%>

Finished test page</p>
</body>
</html>

Please give me suggestion! Thanks again
 
Old January 15th, 2004, 08:06 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Must be a problem with the 'sailors' DSN then. I assume the book has steps to create the DSN? Did you have any problems setting it up?

You can test the DSN using a udl file. Just create a new file called anything.udl, then double-click it and a "Data Link Properties" dialog will appear. On the Connection tab, under "Specify the source of data", choose the "Use data source name" option and select the sailors dsn from the drop-down. The hit the 'Test Connection' button and see what happens!





Similar Threads
Thread Thread Starter Forum Replies Last Post
ADODB.Recordset error '800a0bb9' - PLEASE HELP! gmoney060 BOOK: Beginning ASP 3.0 3 April 25th, 2007 09:21 PM
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
ADODB.Connection (0x800A0E7A) sumanst Classic ASP Databases 1 August 5th, 2005 02:56 PM
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.