Signing up

[Uncle Joe]

Am prepared to sign on with alentus.com
as my FP2003 hosting service. alentus.com
offers a solid monthly package, but its
database server support is pricey. I like
its support of FP and PHP:

Its SQL server ($15 a month paid quarterly)
for 50 MB

Its MySQL server ($20 paid quarterly)
for 100 MB

Right now, all I know about databases
is how to create a MySQL database
using cPanel on 2mhost.com's website.
Can a SQL database be subdivided into
multiple tables serving radically different
functions?

My current hosting service, 2mhost.com,
includes 99 MySQL databases in the
monthly charge. This seems reasonable,
although I haven't been able to get a
straight answer out of them about the
size limitations of the 99 MySQL databases.
They did say that the 99 MySQL databases
didn't come out of my 1300 MB allotment.

 

[Jon Spivey]

Hi,
This probably depends on your knowledge, SQL Server is quite a high end
product and as such needs some knowledge to use, you'd also need Enterprise
Manager to manage it - cheapest version is about 50 bucks. The reason for
the price difference is that while mysql is free SQL Server is very
expensive for the host.

If you're looking to use databases how about MS Access? It's not as powerful
as sql server but you can use it with the FP wizards and it should certainly
be enough to get you started.

 

[Uncle Joe]

Thanks, Jon. I'm almost ready to pull the trigger on
a new hosting service, and want to set everything up
in the beginning. My Access 2000 app is ancient
so I don't know how well it would coexist with FP2003..

My current hosting service is not FP2003 friendly. They
strongly urge customers to not install FP extensions because
doing so can damage crucial files on the server. If I recall
correctly, they specifically mentioned .htaccess.

Hadn't heard about Enterprise Manager. Think I'm
going with MySQL. Have mapped out the DB fields
I need. Originally, had thought of building 70 MySQL
databases but the kind folks here in the forum
convinced me that I could build the new forum app
with one database and a couple of web pages.

It will be a tremendous learning curve me to employ
databases, FrontPage, and PHP but I'm looking
forward to it.

If I could just create/register a great new domain
name, I'd be coding tomorrow.

 

[Rob Giordano \(Crash\)]

I run a couple of forums on Access, of course I don't have hundreds of users
on line at once, but I haven't had any problems with the db...mostly me
mucking things up a bit.

I use a portal/forum software called SooP it's free and they've got
incredible support forum ( http://www.soopportal.ORG ) - lots of
customization possible and easy to use.

Why reinvent the wheel?...unless you're really into the ASP challenge of
writing your own



| Thanks, Jon. I'm almost ready to pull the trigger on
| a new hosting service, and want to set everything up
| in the beginning. My Access 2000 app is ancient
| so I don't know how well it would coexist with FP2003..
|
| My current hosting service is not FP2003 friendly. They
| strongly urge customers to not install FP extensions because
| doing so can damage crucial files on the server. If I recall
| correctly, they specifically mentioned .htaccess.
|
| Hadn't heard about Enterprise Manager. Think I'm
| going with MySQL. Have mapped out the DB fields
| I need. Originally, had thought of building 70 MySQL
| databases but the kind folks here in the forum
| convinced me that I could build the new forum app
| with one database and a couple of web pages.
|
| It will be a tremendous learning curve me to employ
| databases, FrontPage, and PHP but I'm looking
| forward to it.
|
| If I could just create/register a great new domain
| name, I'd be coding tomorrow.
|
| | > Hi,
| > This probably depends on your knowledge, SQL Server is quite a high
| > end product and as such needs some knowledge to use, you'd also need
| > Enterprise Manager to manage it - cheapest version is about 50
| > bucks. The reason for the price difference is that while mysql is
| > free SQL Server is very expensive for the host.
| >
| > If you're looking to use databases how about MS Access? It's not as
| > powerful as sql server but you can use it with the FP wizards and it
| > should certainly be enough to get you started.
| >
| > --
| > Cheers,
| > Jon
| > Microsoft MVP
| >
| > | >> Am prepared to sign on with alentus.com
| >> as my FP2003 hosting service. alentus.com
| >> offers a solid monthly package, but its
| >> database server support is pricey. I like
| >> its support of FP and PHP:
| >>
| >> Its SQL server ($15 a month paid quarterly)
| >> for 50 MB
| >>
| >> Its MySQL server ($20 paid quarterly)
| >> for 100 MB
| >>
| >> Right now, all I know about databases
| >> is how to create a MySQL database
| >> using cPanel on 2mhost.com's website.
| >> Can a SQL database be subdivided into
| >> multiple tables serving radically different
| >> functions?
| >>
| >> My current hosting service, 2mhost.com,
| >> includes 99 MySQL databases in the
| >> monthly charge. This seems reasonable,
| >> although I haven't been able to get a
| >> straight answer out of them about the
| >> size limitations of the 99 MySQL databases.
| >> They did say that the 99 MySQL databases
| >> didn't come out of my 1300 MB allotment.
| >>
| >>
| >
| >
|
|

 

[Uncle Joe]

I visited SooP. Nice. Thanks for the tip. I may
resort to it or IkonBoard at a later date if I fall
flat on my face. I have been contributing to
Atlanta Constitution online opinion forums
(produced/managed using Movable Type) for
years, and have developed concrete goals
for a large politically-based forum driven by
powerful, fast databases.

http://www.ajc.com/opinion/content/custom/blogs/opiniontalk/

The problem with using Movable Type is that
all its templates are two-column based. I,
and many more people, want three column
templates.

I know it seems counter-productive to pass
on pre-packaged solutions, but I am driven
by a need to regain my former programming
capabilities. I was systems engineering mgr.
for Honeywell's Atlanta Region in 1979-82,
and Project Manager for IBM's Hospital
Patient Management System in 1982-86.
All these projects used COBOL programming
software, and the HPMS was driven by IBM
DB2 databases. Had many other programming
and online documentation projects (RoboHelp)'
as well.

Now, I find myself back in novice territory.
So much to learn, and my capacity to learn
isn't what it was about in 1967 when I first
started as an IBM programmer during
Vietnam.

At this time, I'm conflicted about all the software
I have available to me. Have glanced at PHP,
and it looks comfortable to me. Planned to
use FrontPage 2003 to design the project.
Haven't spent enough time with SQL and
..asp yet. Have been thinking of using PHP
and MySQL database, and building comprehensive
comment entry form.

Got the news this week that my aorta heart
valve is failing, and that I'll need it replaced
by a mechanical valve. My brother-in-law
just had a heart valve replacement and spent
7.5 straight months in the hospital. I want
to accomplish my project before I kick
the bucket. I can train my sisters to
operate my forum if I don't make it.

I just want to try to put the project
together on my own. If I can't, I'll
resort to a pre-packaged solution.
I think there's a pent-up demand
for what I want to do.