sql server (alternate): Connection to sql server 2000 -- sql server (alternate)

Re: Connection to sql server 2000

Danieltbt05 NO[at]SPAM gmail.com
2/1/2006 8:37:52 AM

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

Rgds
Daniel

[quoted text, click to view]

Re: Connection to sql server 2000

Danieltbt05 NO[at]SPAM gmail.com
2/1/2006 8:41:05 AM

ya correct but i not sure which language should i use. ADO, DAO or ODBC
? pls advise. Thanks

Re: Connection to sql server 2000

Danieltbt05 NO[at]SPAM gmail.com
2/1/2006 8:16:47 PM

Erland, if i want to build it into like VB do i have to use ASP or
others tools u mentioned ? Only ADO.net can be used in webpage ? DAO or
ADO cannot be used ? Anywhere can learn step by step of it whether
build into VB app. or webpage ? Thanks

Rgds
Daniel

Re: Connection to sql server 2000

Erland Sommarskog
2/1/2006 11:16:42 PM

(Danieltbt05@gmail.com) writes:
[quoted text, click to view]

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

Re: Connection to sql server 2000

Erland Sommarskog
2/2/2006 12:00:00 AM

(Danieltbt05@gmail.com) writes:
[quoted text, click to view]

As I said, this is not really the right place to ask question on how to
build web pages.

But, no, ADO .Net is not sufficient. ADO .Net - as well as ADO and DAO - is
a client API for access data sources. For building a web site, you can
use ASP. Net or ASP. I believe that they use some variation of VB script,
but exactly what this ASP thing is, I'm quite in the dark myself. I would
recommend you to look for newsgroups with "aspnet" in the name.

--
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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server (alternate) group.