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?



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net