Database Discussion - ADODB Installation Help

Print Page | Close Window

ADODB Installation Help

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=2614
Printed Date: 30 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ADODB Installation Help

Posted By: Gullanian
Subject: ADODB Installation Help
Date Posted: 11 May 2003 at 5:25pm

Hi guys! Access WWG forums work perfect, tried to install trial version of SQL server on my pc, it made it go funny (my os is a bit old), removed it, now i cant create an ADODB connection to an access database, is there any way to fix this without installing PWS over?

ASP scripts come up with this error

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

With this code (red is error line)

Set adoCon = Server.CreateObject("ADODB.Connection")
strDbPathAndName = Server.MapPath("data/wwForum.mdb")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName
adoCon.connectionstring = strCon
Set rsCommon = Server.CreateObject("ADODB.Recordset")
adoCon.Open

Thanks for any help!

Replies:

Posted By: michael
Date Posted: 11 May 2003 at 6:11pm

SQL Server 2000 installs MDAC 2.6 (without SP's applied) so evtl. something went wrong there. Just dl MDAC from MS e.g. MDAC 2.7 SP1 from microsoft.com/data this should fix it.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 11 May 2003 at 6:35pm

Yup downloaded MDAC 2.7 Sp1 already, still same error:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

/david/new/includes/common.asp, line 57

Anything i can do in control pannel manualy? Im in Win98sp2

Posted By: michael
Date Posted: 11 May 2003 at 7:45pm

Check your Registry. What does it say for the version key in:
HKEY_Local_Machine > Software > Microsoft > DataAccess

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Gullanian
Date Posted: 12 May 2003 at 2:40am

(Default) (value not set)
Full21Install    Oxfffffff (4294967295)
FullInstallVer   "2.71.9030.9"
IE5_Version     "0.0.0.0"
RollBackVersion "2.71.9030.9"
SavedRollbackVersion "2.60.6526.2"
Version     "2.71.9030.9"

Posted By: Gullanian
Date Posted: 12 May 2003 at 11:00am

im getting in a panic here guys! i really need this to get up soon, any help appreciated i have a deadline to meet :S

Posted By: Gullanian
Date Posted: 13 May 2003 at 3:53am

cant anyone help?