Recommended SQL Interfaces

I am writing some ASP pages to interface with an MS SQL database (on a Win2k box). Does anyone have any recommendations on any tools that I can use to connect to the database and manage tables (create, drop, insert, etc)?

Thanks,
Anthony

Just use the standard ADODB

What's ADODB? How do I get it?

ADO = ActiveX Data Object
It is what ASP uses for database handling.
See http://msdn.microsoft.com/library/d...tml/aspatoz.asp
for more info

But I shouldn't need an ASP specific program should I? I have an MS SQL database installed on a server and I just want to access it so I can create, drop tables. Sorry, maybe I'm not making sense.

Your accessing the pages through ASP therefore you will need to do it in ASP.

Okay, maybe I'm on the wrong track, which is quite possible since I'm new to web development. I have developed applications before using Java and C, connecting to MySQL databases. My database in those situations (like this one) was installed on a server. I used a program called SQLFront that allowed me to connect to the database. I then created a table using the desired schema. I then wrote Java classes and C code that would connect to the database and access that table.

This is what I'm hoping to do now, but with an MS SQL database and eventually using ASP to access it. So I'm looking for a similar utility to first create and set up the table before I access it, load it with data and query it with ASP.

Does this make sense or am I off?

I don't know if there is a front end for SQL Server that you can get besides that which comes with SQL Server itself. You should be able to get the needed utitilties from the installation disk.
The program that comes with SQL Server is called "Enterprise Manager" and will allow you to do what you want.

Okay, thanks for all your quick responses. I might be back for more help once I start trying to connect via ASP. : )

Is this the ADODB provided for PHP (cause there seems to be LOTS of info out there on that)?

There is two different things.
One is the MS (which can be sometimes used in php) and the other is a database abstraction class which is excellent.