New Database in FP (FrontPage 2002)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote