Classic ASP Discussion - ASP : SQL Help Question!

Print Page | Close Window

ASP : SQL Help Question!

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=16255
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP : SQL Help Question!

Posted By: xavier
Subject: ASP : SQL Help Question!
Date Posted: 18 August 2005 at 6:31pm

Ok, you want to create a guestbook application with an SQL server and not MS ACCESS DB.

You already have your asp enabled web space.

After setting up your SQL server on your web space you named it �GBOOKSQL�

Here is the question �

How do you create new tables in �GBOOKSQL�
How do you make �GBOOKSQL� display and accept new records
How do u edit and update records in �GBOOKSQL�
How safe is �GBOOKSQL�
And how fast is �GBOOKSQL� because a SQL server is said to be larger than access db i.e. can take more data.

I will be grateful if you guys can help or still better if there�s a tutorial you can refer me to.

Thanks

-------------
onError GoTo Hell

Replies:

Posted By: michael
Date Posted: 18 August 2005 at 10:02pm

Assuming GBOOKSQL is your Database Name?

You create a table the very same way as in access. Thus it might be more convenient to use a GUI tool like Enterprise Manager. You can download a trial of MSSQL Server and just install Enterprise Manager, if your host allows that. Most hosts offer a web-based way to manage your SQL Server. Check with them.

AS for dispalying and updating records, well I suggest you read some tutorials as there is not much difference as to using Access, short of using Stored Procedures though.

SQL Server can only be as secure as the underlying OS. So it all depends how the whole env. is setup.

How fast? This depends too. How many hits, does the Guestbook have? How many records etc.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: dpyers
Date Posted: 19 August 2005 at 1:09am

Most of the axamples you'll find for administrating MSSQL will reference Enterprise Manager. There are alternatives though.

DbaMgr2K is a desktop app for admin'ing SQL Server. Need vb6 run time dll's - http:// http://www.asql.biz/DbaMgr/DownLoad2k.shtm - www.asql.biz/DbaMgr/DownLoad2k.shtm

TableEditoR is a handdy littl asp web application for doing the same. Also a neat little too for creating access db's quickly. - http:// http://www.2enetworx.com/dev/projects/tableeditor.asp - www.2enetworx.com/dev/projects/tableeditor.asp

There's also a couple of .net web apps around that'll tdo the same thing. A lot of hosts include them in your package.

http://w3schools.com - w3schools.com is a good place to start with sql.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: xavier
Date Posted: 19 August 2005 at 8:07pm

thankx guyz

much appreciated

-------------
onError GoTo Hell