Home > Archive > ASP > May 2006 > Problems with Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problems with Access
|
|
| Christopher Brandsdal 2006-05-09, 6:55 pm |
| I get this error:
-------------------------------------------------------
ADODB.Connection 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
| |
| Dave Anderson 2006-05-09, 6:55 pm |
| Christopher Brandsdal wrote:
> I get this error:
>
> -------------------------------------------------------
> ADODB.Connection 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.
| |
| Christopher Brandsdal 2006-05-09, 6:55 pm |
| 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 / Datenbankverbindung
3: Dim ConnectString, conn
4: ConnectString = Application("AdoConnection")
5: Set conn = Server.CreateObject("ADODB.Connection")
6: conn.open ConnectString
7: %>
"Dave Anderson" <GTSPXOESSGOQ@spammotel.com> skrev i melding
news:OcFDRq3cGHA.5048@TK2MSFTNGP04.phx.gbl...
> Christopher Brandsdal wrote:
>
> 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.
>
| |
| Bob Barrows [MVP] 2006-05-09, 6:55 pm |
| Christopher Brandsdal wrote:
> I get this error:
>
> -------------------------------------------------------
> ADODB.Connection 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.
| |
| Christopher Brandsdal 2006-05-09, 6:55 pm |
| 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={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("/db/sample.mdb")
I've tried using strConn = "Provider=Microsoft.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]" <reb01501@NOyahoo.SPAMcom> skrev i melding
news:e7K%23jR4cGHA.4592@TK2MSFTNGP04.phx.gbl...
> Christopher Brandsdal wrote:
> 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.
>
>
| |
| Bob Barrows [MVP] 2006-05-09, 6:55 pm |
| 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={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("/db/sample.mdb")
>
> I've tried using strConn = "Provider=Microsoft.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.
| |
| Bob Barrows [MVP] 2006-05-09, 6:55 pm |
| 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={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("/db/sample.mdb")
>
> I've tried using strConn = "Provider=Microsoft.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/artic...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.
| |
| Christopher Brandsdal 2006-05-09, 6:55 pm |
| 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]" <reb01501@NOyahoo.SPAMcom> skrev i melding
news:OGJqQ24cGHA.4932@TK2MSFTNGP03.phx.gbl...
> Christopher Brandsdal wrote:
>
> 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/artic...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.
>
>
| |
| Bob Barrows [MVP] 2006-05-09, 6:55 pm |
| Christopher Brandsdal wrote:
> I get this error:
>
Christopher! Are you still around? Check this out:
http://www.microsoft.com/downloads/...&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.
| |
| Christopher Brandsdal 2006-05-12, 7:55 am |
| 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/defaul...kb;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/...&DisplayLang=en
Once again; thanks alot Bob! I have learned a great deal about 32/64 bit
software now ;-)
| |
| Bob Barrows [MVP] 2006-05-12, 7:55 am |
| Christopher Brandsdal wrote:
> 3: Convert IIS to run in 32 bit mode:
> http://support.microsoft.com/defaul...kb;en-us;894435
>
This solution came from an MVP naned Steve Foster ,,, credit where credit is
due
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
| Egbert Nierop \(MVP for IIS\) 2006-05-14, 3:55 am |
|
"Christopher Brandsdal" <christopher@valdres.no> wrote in message
news:%23V%23%23Q2adGHA.1436@TK2MSFTNGP05.phx.gbl...
> 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/defaul...kb;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/...&DisplayLang=en
>
> Once again; thanks alot Bob! I have learned a great deal about 32/64 bit
> software now ;-)
b.t.w. it's better to avoid the ODBC compatibility driver. Your connection
string also loads through ODBC and you can load ole db for access (jet) more
directly by using this string...
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Data\mymdb.mdb;Mode=ReadWrite|Share Deny None;
| |
|
|
|
|
|