473,549 Members | 2,329 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problems with Access

I get this error:

-------------------------------------------------------
ADODB.Connectio n error '800a0e7a'
Provider cannot be found. It may not be properly installed.

/inc/DBconnect.asp, line 6
-------------------------------------------------------

I have just set up a new server, Win 2003 Std x64 bit

It seems like the driver for connecting to the database does not work on x64
bit!?!

Is there any workarounds on this, or do I have to get myself a new Win
edition?

Best regards,

Christopher Brandsdal
May 10 '06 #1
12 11682
Christopher Brandsdal wrote:
I get this error:

-------------------------------------------------------
ADODB.Connectio n error '800a0e7a'
Provider cannot be found. It may not be properly installed.

/inc/DBconnect.asp, line 6
-------------------------------------------------------


There's your error: line 6.
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
May 10 '06 #2
The code is in use on about 100 websites I have made, so the code is fine i
guess. It just seems that the provider is not supported in x64? I have
googled the problem, and it seems to be common among 64 bits...
This is the code it reacts on:

1: <%
2: ' Connection to the database / Datenbankverbin dung
3: Dim ConnectString, conn
4: ConnectString = Application("Ad oConnection")
5: Set conn = Server.CreateOb ject("ADODB.Con nection")
6: conn.open ConnectString
7: %>
"Dave Anderson" <GT**********@s pammotel.com> skrev i melding
news:Oc******** ******@TK2MSFTN GP04.phx.gbl...
Christopher Brandsdal wrote:
I get this error:

-------------------------------------------------------
ADODB.Connectio n error '800a0e7a'
Provider cannot be found. It may not be properly installed.

/inc/DBconnect.asp, line 6
-------------------------------------------------------


There's your error: line 6.
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message.
Use of this email address implies consent to these terms.

May 10 '06 #3
Christopher Brandsdal wrote:
I get this error:

-------------------------------------------------------
ADODB.Connectio n error '800a0e7a'
Provider cannot be found. It may not be properly installed.

/inc/DBconnect.asp, line 6
-------------------------------------------------------

I have just set up a new server, Win 2003 Std x64 bit

It seems like the driver for connecting to the database does not work
on x64 bit!?!

Is there any workarounds on this, or do I have to get myself a new Win
edition?

Does this help?
http://www.aspfaq.com/show.asp?id=2340
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
May 10 '06 #4
I read an article about the same thing:
-----------------------------------------------------------
I'm using Windows XP Professional 64 bit with Access 2000.

Databases I've used for quite sometime, now error in the line strConn =
"DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath( "/db/sample.mdb")

I've tried using strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=" & Server.MapPath( "/db/sample.mdb") but this results in an
'800a0e7a' error.

The first error is "Provider is not specified and there is no designated
default provider", the second is "Provider cannot be found. It may not be
properly installed."

I've tried downloading and installing MDAC 2.8 but it errors on this
platform??
------------------------------------------------------------------------

MDAC cannot be installed on x64. when I try to download it says that it's
only for 32 bit.
I guess I just have to get me a 32 bits win2k3... :(

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> skrev i melding
news:e7******** ********@TK2MSF TNGP04.phx.gbl. ..
Christopher Brandsdal wrote:
I get this error:

-------------------------------------------------------
ADODB.Connectio n error '800a0e7a'
Provider cannot be found. It may not be properly installed.

/inc/DBconnect.asp, line 6
-------------------------------------------------------

I have just set up a new server, Win 2003 Std x64 bit

It seems like the driver for connecting to the database does not work
on x64 bit!?!

Is there any workarounds on this, or do I have to get myself a new Win
edition?

Does this help?
http://www.aspfaq.com/show.asp?id=2340
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

May 10 '06 #5
Christopher Brandsdal wrote:
I read an article about the same thing:
-----------------------------------------------------------
I'm using Windows XP Professional 64 bit with Access 2000.

Databases I've used for quite sometime, now error in the line strConn
= "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath( "/db/sample.mdb")

I've tried using strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=" & Server.MapPath( "/db/sample.mdb") but this results in an
'800a0e7a' error.

The first error is "Provider is not specified and there is no
designated default provider", the second is "Provider cannot be
found. It may not be properly installed."

I've tried downloading and installing MDAC 2.8 but it errors on this
platform??
------------------------------------------------------------------------

MDAC cannot be installed on x64. when I try to download it says that
it's only for 32 bit.
I guess I just have to get me a 32 bits win2k3... :(

Did you try downloading and installing the Jet components? Those are
separate from the MDAC installation.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
May 10 '06 #6
Christopher Brandsdal wrote:
I read an article about the same thing:
-----------------------------------------------------------
I'm using Windows XP Professional 64 bit with Access 2000.

Databases I've used for quite sometime, now error in the line strConn
= "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath( "/db/sample.mdb")

I've tried using strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=" & Server.MapPath( "/db/sample.mdb") but this results in an
'800a0e7a' error.

The first error is "Provider is not specified and there is no
designated default provider", the second is "Provider cannot be
found. It may not be properly installed."

I've tried downloading and installing MDAC 2.8 but it errors on this
platform??
------------------------------------------------------------------------


Hmm, I've just been doing some googling myself and now see what you are
talking about: no x64 driver or provider for Jet.

Small consoloation, but according to this,
http://redmondmag.com/reports/articl...itorialsID=128, " ... JET is
getting x64 support ... "

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
May 10 '06 #7
Lol, i guess I don't have the time to sit around and wait! :-p

But thanks a bunch for helping me, Bob! :-)
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> skrev i melding
news:OG******** ******@TK2MSFTN GP03.phx.gbl...
Christopher Brandsdal wrote:
I read an article about the same thing:
-----------------------------------------------------------
I'm using Windows XP Professional 64 bit with Access 2000.

Databases I've used for quite sometime, now error in the line strConn
= "DRIVER={Micros oft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath( "/db/sample.mdb")

I've tried using strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=" & Server.MapPath( "/db/sample.mdb") but this results in an
'800a0e7a' error.

The first error is "Provider is not specified and there is no
designated default provider", the second is "Provider cannot be
found. It may not be properly installed."

I've tried downloading and installing MDAC 2.8 but it errors on this
platform??
------------------------------------------------------------------------


Hmm, I've just been doing some googling myself and now see what you are
talking about: no x64 driver or provider for Jet.

Small consoloation, but according to this,
http://redmondmag.com/reports/articl...itorialsID=128, " ... JET is
getting x64 support ... "

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

May 10 '06 #8
Christopher Brandsdal wrote:
I get this error:

Christopher! Are you still around? Check this out:
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
May 10 '06 #9
After alot of help from Bob Barrows, there is finally a solution! :-D

Here is a short summary:

If you run Windows 2003 64 bit verion and still want to run Jet engine,
Acces and FrontPage, you have to do the following steps:

1. Make shore you have SP1 installed on the server

2: Check to ensure that you have all the DLL's required in ypur system
folders
Here is a list of DLL files needed:
http://support.microsoft.com/?kbid=829558

"there's only a 32-bit Jet driver in WS2003 x64, so only a 32-bit
application will be able to access Jet.
In order for IIS to use 32-bit drivers, you must flip it from 64-bit to
32-bit."

3: Convert IIS to run in 32 bit mode:
http://support.microsoft.com/default...b;en-us;894435

Make sure that the status of ASP.NET version 2.0.40XXX is set to Allowed in
the Web service extension list in Internet Information Services Manager.

4. To run FrontPage server extensions, download and run:
http://www.microsoft.com/downloads/d...DisplayLang=en

Once again; thanks alot Bob! I have learned a great deal about 32/64 bit
software now ;-)
May 12 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2285
by: David | last post by:
Hi, I want to work with Access 2002. I will need to be able to distribute my application to users that may still have access 2000 on their computers. I know access 2002 has a function that enables you to convert a database to a format of an earlier version of Access. I wanted to check for any unforeseen problems so here is what I did: I...
1
2320
by: jdola | last post by:
I have a customer that is using Access to create reports from FoxPro tables. We started noticing problems with the indexes on the FoxPro tables. It is to the point where we have to delete and rebuild the indexes on a nightly basis. We cannot determine if Access is the culprit and I have not been able to look at the Access reports and...
2
1477
by: Bill Engel | last post by:
Some computers in our office have Access 2000 and others have Access XP. The original database was written in Access 2000. Is there a reason that code has some problems while being run on the Access XP machines?
2
1392
by: PatrickO | last post by:
Hi to you all, I have some questions. I just converted my Access 97 database to Access 2003. To let it still work i referenced the Jet 2.5/3.5 jet engine in my database. Is this oke?
26
2650
by: jamesbeswick | last post by:
I've been using Access since version 97 and I've migrated to 2003. I've noticed a substantial number of strange ActiveX/OLE and code corruption problems when writing databases. The only solution I've found is to create a new database and import all the objects from the corrupted file. Has anyone else found a solution to this annoying...
10
2389
by: BBFrost | last post by:
We just recently moved one of our major c# apps from VS Net 2002 to VS Net 2003. At first things were looking ok, now problems are starting to appear. So far ... (1) ComboBox.SelectedValue = db_value; If the db_value was not included in the ComboBox value list the ComboBox.SelectedIndex used to return -1, Now the very same code is
4
3506
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The objective in utilizing this new deployment method is to reduce the maintenance overhead as well as making it easier for my users to setup and run the...
1
8112
by: Duffman | last post by:
Hi, I have what seems to be a common problem, but the solutions I've found don't seem to work. I would like to use a web service to create a file at a UNC location in a shared file. Currently I'm just running it locally and saving the file locally using my machines UNC path. I have given user ASPNET full control over the folder I want...
8
1862
by: reema via AccessMonster.com | last post by:
Did any one faces any difficulties ,issuess or problems using Microsoft Access -- Message posted via http://www.accessmonster.com
3
1664
by: Earl Anderson | last post by:
One of the users in our departmental db has Read/Write permissions to a particular form. He was able to access and edit the form at will until 2 weeks ago. His current problem was that he was not able to edit the data (no message ever appeared telling him he could not change any data). The only change to the db since he experienced the...
0
7471
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7985
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6071
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5387
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3496
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1962
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1082
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
784
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.