Re: Working with a hosted MS SQL Server database

My ISP allows me to register my own database in Enterprise manager.

www.hostbasket.com


"Jack" <mrcodedit@xxxxxxxxxxxxx> wrote in message
news:1156002030.550198.270080@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
First off, I want to say that I am not an Expert on working with SQL
Server -- especially the ones running on web servers.

Here is my problem:

I want to be able to work with or manage an SQL Server 2000 database
hosted with an ISP. Sounds easy enough...for some. The ISP I currently
have doesn't have any SQL Servers, and this to my surprise I am sorry
to say -- it supports only MS Access. I know that there are other types
of databases out there like mySQL, but I really want to stick with SQL
Server.

The reason I must work with an "industrial" type of database is that,
like a lot of people who have put up with an MS Access database on
their website and who now expect, like I do, at least a couple of
hundred, if not a couple of thousand concurrent users to hit a button
at the same time, I must use a database other than MS Access that can
take and manage a lot of hits. An asp page will open an ado connection,
do a simple SELECT query on a single table in the SQL Server database,
(no joins, no inserts, etc), do very light html output, and close the
connection. Very quick. I suspect it is possible that a couple of
hundred surfers around the world will hit that asp page button at about
the same time, and I don't want any one of them to be left hanging or
to get an error page in their browsers, or to suffer any of the
troubles associated with an Access database under these circumstances.

I, the webmaster, will be doing some minor database work, but I will be
doing it frequently, so I need the right tools: I will be adding,
editing, or deleting records and other minor work.

If I trust the sources I have read, this "remote-control" work is
accomplished with Enterprise Manager.
The good thing is that I have Enterprise Manager: I have VB6.0
Enterprise, and with it came SQL Server 7.0. The problem is, or so I
was told, that my Enterprise Manager will not work with a SQL Server
2000 database on a host. And I don't think there exists too many ISPs
that still have SQL Server 7.0 running. So I am out of luck.

So what are my options? How does a webmaster work with a SQL Server
2000 database on a host anyway? Where does one learn how to do that?

1) Should I "upgrade" from SQL Server 7.0 to SQL Server 2000? If so, I
would really appreciate an answer as to *how* or *Where* I buy the
upgrade to do what I need to do, if any. Is it affordable? Am I in over
my head with costs and expertise? Is it easy to upgrade?

2) If I forget about upgrading to SQL Server 2000, perhaps I can do
what seems to work for a lot of webmasters and DBAs: run an asp page
that will create tables, fields, inserts etc. I can do that, but I
doubt it's the easiest way.

So before I commit to a new ISP, I need to make sure that I will have
the tools I need. Thank you in advance for your professional expertise.



.

Quantcast