Posted by Erland Sommarskog on 02/02/06 01:16

(Danieltbt05@gmail.com) writes:
> Now using SQL Server 2000 on win2003 and using QA/enterprise manager
> to connect in intranet now. Is it normal for user to connect to sql
> server using QA or enterprise manager ? I mean do you consider it user
> friendly ? So i intend to design it to become a webpage for end user to
> view the data. I've been using DAO or ADO quite some time ago. is it ok
> ? what abt ODBC ? what do you recommend ? pls advise. thanks

End-users normally don't use tools like Query Analyzer or Enterprise
Manager, but rather they access the database through an application
or a web page.

If I understand things right, you are looking into the latter. There
are several tools on the market: ASP, ASP .Net, Cold Fusion, and
probably more. I don't know any of them myself. Once you've chosen
a tool for your web site, then you have more or less also settled on
a client API. For ASP that would be ADO, for ASP .Net that would
be ADO .Net. (Which is very different from ADO, and also a lot better.)

I don't know if DAO can connect to SQL Server, but anyway that's really
old stuff that you should not use.

Sorry if the answer is not crystal clear, but this is not really the
best newsgrop to ask questions about building a web site.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]