Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2001
    Location
    Kennesaw, Georgia, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New Database in FP (FrontPage 2002)

    Hello to all Loungers,
    First I would like to say that it has been two years since I last used the Lounge. (I had a computer crash and lost everything including my favorite links, for the life of me I could not remember the URL for this forum, I am so glad to be back). These forums are the BEST ON THE NET.
    My question for any FrontPage user is this:
    I have been a Dreamweaver user for years. I have recently started to create a database on my web host. The hosting I currently use is a unix host with only mySQL database available. (It does allow FP extensions). I have had trouble developing PHP files to access the mySQL database, and thought I would give FP a try. I created a network connection using FP to my current webhost. I would like to know what direction to follow:
    1. Can I access a mySQL database using FP? (The "insert database" menu feature in FP is currently greyed out)
    2. Can I use my local version of MS Access to create a database and just upload the .mdb file to my current server (Unix base w/FP extensions)
    3. Will I have to upgrade to a Windows based server to utilize FP database services (such as ASP)?
    I would appreciate any suggestions on these questions.
    Thanks again,
    --Tim
    tim_stimple@bellsouth.net

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: New Database in FP (FrontPage 2002)

    I've only ever used FP's buiilt-in database connectivity with MDB files. In peering at the code generated by FP 2000, it seemed to use ASP/ADO hidden away in the global.asa file (this is from memory...).

    For efficiency reasons, I started writing my own ASP/ADO code when I wanted to access SQL Server directly. ASP is a Microsoft technology, but there is an ASP plug-in for Apache (I believe) from someone like Chilisoft (??). So you might be able to use ASP. If not, you'll probably not find FP to be a very helpful development environment. More like just a WYSIWYG HTML editor.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    Cincinnati, Ohio, USA
    Posts
    7,089
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New Database in FP (FrontPage 2002)

    I have found Frontpage wanting when it comes to working with databases. Jefferson's perspective fits right with mine: it is a WYSIWYG editor, and it excels at that. If you use native Frontpage technologies, such as ASP, you will need a host that supports ASP. Commonly these are IIS servers and cost more in terms of hosting fees (the Microsoft tax).

    I was once heavily dependent upon IIS servers and I loathed every minute of it. You can do the same thing without all the extra expense and without limiting your choices, as Frontpage does.

    Dreamweaver MX may be something for you to check into if you want to create data-driven websites. It is very powerful and flexible when it comes to data sources. It is more of a coder's tool than Frontpage is, but I find its code is also much cleaner.
    -Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •