Connection to sql server 2000

Danieltbt05

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

Jan 31 '06 #1

Subscribe Post Reply

1470

Jens

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

-jens Suessmeyer.

Jan 31 '06 #2

Jack Vamvas

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
<Da*********@gmail.com> wrote in message
news:11**********************@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

Feb 1 '06 #3

Danieltbt05

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
<Da*********@gmail.com> wrote in message
news:11**********************@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

Feb 1 '06 #4

Danieltbt05

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

Feb 1 '06 #5

Erland Sommarskog

(Da*********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Feb 1 '06 #6

Danieltbt05

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

Feb 2 '06 #7

Erland Sommarskog

(Da*********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Feb 2 '06 #8

by: Jesper Carstensen | last post by:

We are running an ASP application. That is fairly simple. It selects from one table (15.000 records), and updates into another table. But when we execute the ASP script, it reports the...

Microsoft SQL Server

Connection Object in ASP.NET

by: Keith Norris | last post by:

I cannot successfully create a connection object in a web form. In the page_load event I try the following code: Dim sConnection As String = "server=MIDATLANTICUS;" & _ database=Pubs;integrated...

ASP.NET

Help me in Specifying Connection string to SQL server 2000 running on remote machine

by: vighnesh | last post by:

Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used...

ASP.NET

SQL server connection problem

by: Danieltbt05 | last post by:

just installed SQL server 2000 and using my client , i can't locate the server. I used SQL query analyzer to search but no servers were found. Error message is as below Server : Msg17,level...

Microsoft SQL Server

MSDE 2000 Connection String

by: hfk0 | last post by:

Hi, I have a simple asp.net application running ok on my WinXP development server with SQL Server Express 2005 installed locally. After moving to the live server (Win 2000 server with MSDE 2000...

ASP.NET

Help: database connection string for different instances?

by: Hongbo | last post by:

Hi, I have a test server with Windows 2003 Standard Server. SQL Server 2000 Standard Edition was installed earlier as default instance. My ASP.Net web site works fine with the connection...

ASP.NET

ASP.NET 2.0 and connection to remote SQL 2000 server

by: Mitya Mitriev | last post by:

Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine. Then I installed application on production...

ASP.NET

SQL Server 2000/ASP.NET 2.0 Connection String: Works with Cassini, not with IIS 5.1

by: OJ | last post by:

Hi, I am at a loss here, I have a c# asp.net website which connects to a remote SQL Server 2000 db via a connection string. If I set the website up in the filesystem and use the inbuilt cassini...

ASP.NET

ASP.NET 2.0/SQL Server 2000 Connection Problem.

by: Vikram S | last post by:

Hi All, I have an ASP.NET 2.0 web application on a web server and a separate machine for SQL Server 2000 Database. I am using a Connectionstring based on Sql Authentication to connect to the...

ASP.NET

SQL Server 2000 - OLE DB string connection

by: borisding | last post by:

Hi all, I have recently migrated ASP application from Windows server 2000 to 2003. But failed to connect to SQL Server 2000. (Both sql server and application are on the same server) I keep...

ASP / Active Server Pages

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics