800a0e7a Error using asp and access database

Discussion in 'Windows 64bit' started by =?Utf-8?B?aHlicmlkYXJ0?=, Jan 18, 2006.

  1. We'll searching has made me end up here and with no answers.

    I recently installed winxp 64bit pro and after setting my hp photosmar p1000
    to some random ass driver (brother PCL5e) that worked...then i moved on to
    installing programs and such and then to IIS.

    Everything installed fine and i setup permissions to my folders/files in IIS
    manager but when i pull up a page i get the following error.
    ---------
    ADODB.Connection error '800a0e7a'

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

    /tia/nav.asp, line 15
    ---------

    i've seen this posted on a few forums but no one can seem to answer the
    question, WHY???!!!!

    Why does it say that and when i goto to the odbc and try to configure the
    access driver i then get an error saying

    The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could not
    be found. Please reinstall the driver.

    Well am I missing something because the MDAC page on microsoft does not list
    any compatible updates or installs for x64 pro. Please can someone give me
    an answer to this?
     
    =?Utf-8?B?aHlicmlkYXJ0?=, Jan 18, 2006
    #1
    1. Advertising

  2. Hi,

    There are no 64bit versions of odbc available. With vs 2005 you
    can set the target cpu to x86 to get it to use the 32 bit drivers. I do not
    know of any work arounds for asp.

    Please vote for my suggestion that there be a 64 bit version of odbc
    http://lab.msdn.microsoft.com/produ...edbackid=a533f823-73a1-40e8-9380-d25b58ce8ae8

    Ken
    ----------------
    "hybridart" <> wrote in message
    news:...
    > We'll searching has made me end up here and with no answers.
    >
    > I recently installed winxp 64bit pro and after setting my hp photosmar
    > p1000
    > to some random ass driver (brother PCL5e) that worked...then i moved on to
    > installing programs and such and then to IIS.
    >
    > Everything installed fine and i setup permissions to my folders/files in
    > IIS
    > manager but when i pull up a page i get the following error.
    > ---------
    > ADODB.Connection error '800a0e7a'
    >
    > Provider cannot be found. It may not be properly installed.
    >
    > /tia/nav.asp, line 15
    > ---------
    >
    > i've seen this posted on a few forums but no one can seem to answer the
    > question, WHY???!!!!
    >
    > Why does it say that and when i goto to the odbc and try to configure the
    > access driver i then get an error saying
    >
    > The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could
    > not
    > be found. Please reinstall the driver.
    >
    > Well am I missing something because the MDAC page on microsoft does not
    > list
    > any compatible updates or installs for x64 pro. Please can someone give
    > me
    > an answer to this?
     
    Ken Tucker [MVP], Jan 18, 2006
    #2
    1. Advertising

  3. For ODBC, you need to use the 32-bit version. The following may help:
    From a post by Pascal Deliot:

    It's important to understand which kind of DSN you have. On an x64 system,
    you can create an ODBC connection(DSN) on the 32-bit side of the system or
    on the 64-bit side of the system.

    32-bit applications will only see ODBC connections created in the 32-bit
    side, and 64-bits applications will only see ODBC connections from the
    64-bit side. Each kind of application has is own registry.

    To setup DSN for 32-bit application you must use:
    %WINDIR%\SysWOW64\odbcad32.exe
    and for 64-bit application you must use:
    %WINDIR%\System32\odbcad32.exe

    --
    Charlie.
    http://msmvps.com/xperts64

    hybridart wrote:
    > We'll searching has made me end up here and with no answers.
    >
    > I recently installed winxp 64bit pro and after setting my hp photosmar
    > p1000 to some random ass driver (brother PCL5e) that worked...then i
    > moved on to installing programs and such and then to IIS.
    >
    > Everything installed fine and i setup permissions to my folders/files in
    > IIS manager but when i pull up a page i get the following error.
    > ---------
    > ADODB.Connection error '800a0e7a'
    >
    > Provider cannot be found. It may not be properly installed.
    >
    > /tia/nav.asp, line 15
    > ---------
    >
    > i've seen this posted on a few forums but no one can seem to answer the
    > question, WHY???!!!!
    >
    > Why does it say that and when i goto to the odbc and try to configure the
    > access driver i then get an error saying
    >
    > The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could
    > not be found. Please reinstall the driver.
    >
    > Well am I missing something because the MDAC page on microsoft does not
    > list any compatible updates or installs for x64 pro. Please can someone
    > give me an answer to this?
     
    Charlie Russel - MVP, Jan 18, 2006
    #3
  4. hi ken thanks for the reply...i voted for your suggestion!! Let's hope they
    do it someday!

    -Brandon

    "Ken Tucker [MVP]" wrote:

    > Hi,
    >
    > There are no 64bit versions of odbc available. With vs 2005 you
    > can set the target cpu to x86 to get it to use the 32 bit drivers. I do not
    > know of any work arounds for asp.
    >
    > Please vote for my suggestion that there be a 64 bit version of odbc
    > http://lab.msdn.microsoft.com/produ...edbackid=a533f823-73a1-40e8-9380-d25b58ce8ae8
    >
    > Ken
    > ----------------
    > "hybridart" <> wrote in message
    > news:...
    > > We'll searching has made me end up here and with no answers.
    > >
    > > I recently installed winxp 64bit pro and after setting my hp photosmar
    > > p1000
    > > to some random ass driver (brother PCL5e) that worked...then i moved on to
    > > installing programs and such and then to IIS.
    > >
    > > Everything installed fine and i setup permissions to my folders/files in
    > > IIS
    > > manager but when i pull up a page i get the following error.
    > > ---------
    > > ADODB.Connection error '800a0e7a'
    > >
    > > Provider cannot be found. It may not be properly installed.
    > >
    > > /tia/nav.asp, line 15
    > > ---------
    > >
    > > i've seen this posted on a few forums but no one can seem to answer the
    > > question, WHY???!!!!
    > >
    > > Why does it say that and when i goto to the odbc and try to configure the
    > > access driver i then get an error saying
    > >
    > > The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could
    > > not
    > > be found. Please reinstall the driver.
    > >
    > > Well am I missing something because the MDAC page on microsoft does not
    > > list
    > > any compatible updates or installs for x64 pro. Please can someone give
    > > me
    > > an answer to this?

    >
    >
    >
     
    =?Utf-8?B?aHlicmlkYXJ0?=, Jan 19, 2006
    #4
  5. hey charlie thank you for the reply, your suggestion seems to do the trick.
    now i just need to configure it so it works like it use to. i'm glad to have
    you guys help on this newsgroup!

    "Charlie Russel - MVP" wrote:

    > For ODBC, you need to use the 32-bit version. The following may help:
    > From a post by Pascal Deliot:
    >
    > It's important to understand which kind of DSN you have. On an x64 system,
    > you can create an ODBC connection(DSN) on the 32-bit side of the system or
    > on the 64-bit side of the system.
    >
    > 32-bit applications will only see ODBC connections created in the 32-bit
    > side, and 64-bits applications will only see ODBC connections from the
    > 64-bit side. Each kind of application has is own registry.
    >
    > To setup DSN for 32-bit application you must use:
    > %WINDIR%\SysWOW64\odbcad32.exe
    > and for 64-bit application you must use:
    > %WINDIR%\System32\odbcad32.exe
    >
    > --
    > Charlie.
    > http://msmvps.com/xperts64
    >
    > hybridart wrote:
    > > We'll searching has made me end up here and with no answers.
    > >
    > > I recently installed winxp 64bit pro and after setting my hp photosmar
    > > p1000 to some random ass driver (brother PCL5e) that worked...then i
    > > moved on to installing programs and such and then to IIS.
    > >
    > > Everything installed fine and i setup permissions to my folders/files in
    > > IIS manager but when i pull up a page i get the following error.
    > > ---------
    > > ADODB.Connection error '800a0e7a'
    > >
    > > Provider cannot be found. It may not be properly installed.
    > >
    > > /tia/nav.asp, line 15
    > > ---------
    > >
    > > i've seen this posted on a few forums but no one can seem to answer the
    > > question, WHY???!!!!
    > >
    > > Why does it say that and when i goto to the odbc and try to configure the
    > > access driver i then get an error saying
    > >
    > > The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could
    > > not be found. Please reinstall the driver.
    > >
    > > Well am I missing something because the MDAC page on microsoft does not
    > > list any compatible updates or installs for x64 pro. Please can someone
    > > give me an answer to this?

    >
    >
    >
     
    =?Utf-8?B?aHlicmlkYXJ0?=, Jan 19, 2006
    #5
  6. so i typed what you wrote and the odbc window opens and i can configure the
    access driver but if i goto start control panel it opens the same window but
    wont allow me to configure any drivers....

    and when i check the site i'm testing i still get the same error.

    can you help me set my iis and odbc up so my old stuff works on x64? thanks
    man!

    "Charlie Russel - MVP" wrote:

    > For ODBC, you need to use the 32-bit version. The following may help:
    > From a post by Pascal Deliot:
    >
    > It's important to understand which kind of DSN you have. On an x64 system,
    > you can create an ODBC connection(DSN) on the 32-bit side of the system or
    > on the 64-bit side of the system.
    >
    > 32-bit applications will only see ODBC connections created in the 32-bit
    > side, and 64-bits applications will only see ODBC connections from the
    > 64-bit side. Each kind of application has is own registry.
    >
    > To setup DSN for 32-bit application you must use:
    > %WINDIR%\SysWOW64\odbcad32.exe
    > and for 64-bit application you must use:
    > %WINDIR%\System32\odbcad32.exe
    >
    > --
    > Charlie.
    > http://msmvps.com/xperts64
    >
    > hybridart wrote:
    > > We'll searching has made me end up here and with no answers.
    > >
    > > I recently installed winxp 64bit pro and after setting my hp photosmar
    > > p1000 to some random ass driver (brother PCL5e) that worked...then i
    > > moved on to installing programs and such and then to IIS.
    > >
    > > Everything installed fine and i setup permissions to my folders/files in
    > > IIS manager but when i pull up a page i get the following error.
    > > ---------
    > > ADODB.Connection error '800a0e7a'
    > >
    > > Provider cannot be found. It may not be properly installed.
    > >
    > > /tia/nav.asp, line 15
    > > ---------
    > >
    > > i've seen this posted on a few forums but no one can seem to answer the
    > > question, WHY???!!!!
    > >
    > > Why does it say that and when i goto to the odbc and try to configure the
    > > access driver i then get an error saying
    > >
    > > The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could
    > > not be found. Please reinstall the driver.
    > >
    > > Well am I missing something because the MDAC page on microsoft does not
    > > list any compatible updates or installs for x64 pro. Please can someone
    > > give me an answer to this?

    >
    >
    >
     
    =?Utf-8?B?aHlicmlkYXJ0?=, Jan 19, 2006
    #6
  7. No help here - I don't use ODBC for anything. But I knew Pascal knew his
    stuff, and he seems to have resolved it for most folks, so I saved his
    message. You're probably better off asking over on a NG that covers ODBC
    issues.

    --
    Charlie.
    http://msmvps.com/xperts64

    hybridart wrote:
    > so i typed what you wrote and the odbc window opens and i can configure
    > the access driver but if i goto start control panel it opens the same
    > window but wont allow me to configure any drivers....
    >
    > and when i check the site i'm testing i still get the same error.
    >
    > can you help me set my iis and odbc up so my old stuff works on x64?
    > thanks man!
    >
    > "Charlie Russel - MVP" wrote:
    >
    >> For ODBC, you need to use the 32-bit version. The following may help:
    >> From a post by Pascal Deliot:
    >>
    >> It's important to understand which kind of DSN you have. On an x64
    >> system, you can create an ODBC connection(DSN) on the 32-bit side of the
    >> system or on the 64-bit side of the system.
    >>
    >> 32-bit applications will only see ODBC connections created in the 32-bit
    >> side, and 64-bits applications will only see ODBC connections from the
    >> 64-bit side. Each kind of application has is own registry.
    >>
    >> To setup DSN for 32-bit application you must use:
    >> %WINDIR%\SysWOW64\odbcad32.exe
    >> and for 64-bit application you must use:
    >> %WINDIR%\System32\odbcad32.exe
    >>
    >> --
    >> Charlie.
    >> http://msmvps.com/xperts64
    >>
    >> hybridart wrote:
    >>> We'll searching has made me end up here and with no answers.
    >>>
    >>> I recently installed winxp 64bit pro and after setting my hp photosmar
    >>> p1000 to some random ass driver (brother PCL5e) that worked...then i
    >>> moved on to installing programs and such and then to IIS.
    >>>
    >>> Everything installed fine and i setup permissions to my folders/files in
    >>> IIS manager but when i pull up a page i get the following error.
    >>> ---------
    >>> ADODB.Connection error '800a0e7a'
    >>>
    >>> Provider cannot be found. It may not be properly installed.
    >>>
    >>> /tia/nav.asp, line 15
    >>> ---------
    >>>
    >>> i've seen this posted on a few forums but no one can seem to answer the
    >>> question, WHY???!!!!
    >>>
    >>> Why does it say that and when i goto to the odbc and try to configure
    >>> the access driver i then get an error saying
    >>>
    >>> The setup routines for Microsoft Access Driver (*.mdb) ODBC driver could
    >>> not be found. Please reinstall the driver.
    >>>
    >>> Well am I missing something because the MDAC page on microsoft does not
    >>> list any compatible updates or installs for x64 pro. Please can someone
    >>> give me an answer to this?
     
    Charlie Russel - MVP, Jan 19, 2006
    #7
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guy Cox
    Replies:
    1
    Views:
    1,435
    sharon
    Jul 9, 2003
  2. Fluker
    Replies:
    0
    Views:
    1,093
    Fluker
    Jul 9, 2003
  3. hbizta
    Replies:
    1
    Views:
    2,019
    sunzy
    Aug 20, 2010
  4. DataBase DataBase DataBase DataBase

    , Sep 26, 2012, in forum: Computer Information
    Replies:
    0
    Views:
    1,179
  5. Database Database Database Database

    , Sep 27, 2012, in forum: Computer Information
    Replies:
    0
    Views:
    1,023
Loading...

Share This Page