Skip navigation
KirstyAnderson
Currently Being Moderated

ASP Development for Dreamweaver - Access Database

May 17, 2012 10:44 AM

I am following a tutorial on the adobe site for how to connect to an Access database using Dreamweaver CS5.  It states that I cannot connect to Access unless I have changed my settings to enable 32 bit applications.  I am unable to find this function using Windows 7.

 
Replies
  • Currently Being Moderated
    May 17, 2012 11:06 AM   in reply to KirstyAnderson

    Are you following David Powers' tutorial?

     

    He explains it here

     

    Enabling connection to an Access database on 64-bit Windows

    http://www.adobe.com/devnet/dreamweaver/articles/setup_asp.html#articl econtentAdobe_numberedheader_1

     

    Any reason you're using Dreamweaver for ASP (or are you using ASP.NET?) development?

     

    Since it's a Microsoft proprietary technology, Adobe lost interest in ASP back around CS4. They left the tools there but don't develop or support them anymore.

     

    ASP developers are better off using Microsoft Expression Web.

     
    |
    Mark as:
  • Currently Being Moderated
    May 17, 2012 1:03 PM   in reply to KirstyAnderson

    KirstyAnderson wrote:

     

    really need a tutorial on how to connect to an Access database using this or MS Expression Web; any suggestions?

    Does the current tutorial you're following work for you?

     
    |
    Mark as:
  • Currently Being Moderated
    May 17, 2012 1:45 PM   in reply to KirstyAnderson

    I have Windows 7 Ultimate here and I just followed the tutorial. Works OK.

     

    Which flavour of Windows 7 are you running?

     

    Can you get to the IIS Manager?

     

    • Launch the Internet Information Services Manager by selecting Start > Control Panel > Administrative Tools > Internet Information Services (IIS) Manager.

     

    From the tutorial

     

    Enabling connection to an Access database on 64-bit Windows

    The Microsoft Access Driver is not available in a 64-bit version, so you need to use the 32-bit driver.

    1. Launch the Internet Information Services Manager by selecting Start > Control Panel > Administrative Tools > Internet Information Services (IIS) Manager. 
    2. In the Connections panel, select Application Pools, and select DefaultAppPool in the center panel. 
    3. In the Actions panel on the right, click the Advanced Settings link. 
    4. In the General section, set Enable 32-Bit Applications to True (see Figure 13), and click OK.
     
    |
    Mark as:
  • Currently Being Moderated
    May 17, 2012 1:55 PM   in reply to KirstyAnderson

    I'm guessing that you're running Windows 7 Home Premium?

     

    IIS is not installed by default on the Home versions of Windows 7.

     

    See

    http://technet.microsoft.com/en-us/library/cc731911.aspx

     

    See also Setting up an ASP application server

    http://www.adobe.com/devnet/dreamweaver/articles/setup_asp.html#articl econtentAdobe_numberedheader

     

    Do you have to use ASP (which needs IIS)?

     

    PHP, free and open source, is a much more popular choice for web developers these days and does not rely on IIS at all.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points