XP 64 Bit, IIS and Access 2000

Discussion in 'Windows 64 Bit' started by gmcallis, Jun 3, 2005.

  1. gmcallis

    gmcallis Guest

    Any help with this is appreciated.

    I upgraded my pc to 64 bit motherboard, processor and XP 64 bit.

    When I try to access an Access 2000 database, using ASP on my local pc I
    receive an error "'800a0ea9' Provider is not specified and there is no
    designated default provider."

    The offending code is "strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
    Source=" & Server.MapPath("/db/sample.mdb")" It works fine on the net and the
    db is located under wwwroot/db/.

    I'm a newbie to IIS, but I'm pretty sure I have permissions correct.

    Thinking it's a driver issue I've downloaded the latest jet, but on instal
    this errors "This KB829558 is for a different hardware platform."

    Thinking it may be MDAC I downloaded MDAC_TYP.EXE, but this errors "This
    setup does not support installing on this operating system."

    My code works fine on the hosting server, so I don't feel it's the code.

    Cheers

    Graham McAllister
     
    gmcallis, Jun 3, 2005
    #1
    1. Advertisements

  2. gmcallis

    Monster Guest

    There is no 64bit Jet support, so access databases won't work in 64bit.
    You'll have to switch to 32bit
     
    Monster, Jun 4, 2005
    #2
    1. Advertisements

  3. gmcallis

    gmcallis Guest

    Does this mean if I want to run IIS with Access 2000 I need Win XP Pro, not
    Win XP Pro 64 bit?

    I'm suspect Microsoft is not supporting Access 2000 databases for online,
    instead preferring developers use SQL or mySql.

    Thanks for your input.

    Cheers

    Graham McAllister
     
    gmcallis, Jun 4, 2005
    #3
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.