Connection to sql server 2000

Hi, I've created database in sql server 2000 but how to i link it to
webpage for user to use as front end application ? Pls advise. Thanks

Rgds
DanielYou have to do some coding in the coding language of your choice.

-jens Suessmeyer.|||What language/ platform are you using?

--
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
<Danieltbt05@.gmail.com> wrote in message
news:1138725750.293962.191770@.g49g2000cwa.googlegr oups.com...
> Hi, I've created database in sql server 2000 but how to i link it to
> webpage for user to use as front end application ? Pls advise. Thanks
> Rgds
> Daniel|||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

Jack Vamvas wrote:
> What language/ platform are you using?
> --
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> <Danieltbt05@.gmail.com> wrote in message
> news:1138725750.293962.191770@.g49g2000cwa.googlegr oups.com...
> > Hi, I've created database in sql server 2000 but how to i link it to
> > webpage for user to use as front end application ? Pls advise. Thanks
> > Rgds
> > Daniel|||ya correct but i not sure which language should i use. ADO, DAO or ODBC
? pls advise. Thanks|||(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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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|||(Danieltbt05@.gmail.com) writes:
> 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

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/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx