web database question - Microsoft SQL Server

Sue

Hi, we are thinking of installing sql server as a backend to our
website.

Q.1. What is the best way to do this - should we host the database on
the same IIS server where the website is hosted, or would it be better
to put the database on a server on it's own, separate from the IIS
server?

Q.2. Also what is the best way for clients to connect to the database
for querying purposes - will I be able to install client versions of
sql server on their machines so they can connect for querying purposes
only, (cannot create tables etc), or will it be better if the clients
have sql server express installed locally and connect to the server
sql through odbc?

Q.3. When connecting to a sql server database through odbc, using ms
access or sql server express, what happens when queries are run or
updates are made - does the original database on the server get
updated or only the local copy on the client? Also will the client
always have the most recent data?

Sorry, for all the questions, thank you very much for replying. I have
used DB2 in a client server environment but am new to sql server....

Oct 1 '07 #1

Subscribe Reply

1435

Jack Vamvas

What sort of traffic , will you be getting?

q1. You can put the db on the same box as IIS , but if you have separate
boxes , and you
envisage throughput will be significant , then separating them is a good
idea.
Is a RAID array available?
q2. Isn't the website going to be the client end for querying?
If that is the case , then there is no need to have SQL Server Tools or
express installed on the client machines.
They would just use the web front end as the querying mechanism. On the
other hand , if there is a further requirement to
allow developers (for example ) to query the db directly, thn just install
SQL Server express and give them a User who is defined
as only having SELECT permissions

q3. If the main depository is the main SQL db , and you connected via a
client such as SQL Server express , then if you ran
an UPDATE on the main depository and that user had UPDATE permissions then
the main db would be updated

--

Jack Vamvas
_______________ _______________ _____
Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL

"Sue" <se*****@hotmai l.comwrote in message
news:11******** **************@ 22g2000hsm.goog legroups.com...

Hi, we are thinking of installing sql server as a backend to our
website.

Q.1. What is the best way to do this - should we host the database on
the same IIS server where the website is hosted, or would it be better
to put the database on a server on it's own, separate from the IIS
server?

Q.2. Also what is the best way for clients to connect to the database
for querying purposes - will I be able to install client versions of
sql server on their machines so they can connect for querying purposes
only, (cannot create tables etc), or will it be better if the clients
have sql server express installed locally and connect to the server
sql through odbc?

Q.3. When connecting to a sql server database through odbc, using ms
access or sql server express, what happens when queries are run or
updates are made - does the original database on the server get
updated or only the local copy on the client? Also will the client
always have the most recent data?

Sorry, for all the questions, thank you very much for replying. I have
used DB2 in a client server environment but am new to sql server....

Oct 1 '07 #2

Erland Sommarskog

Sue (se*****@hotmai l.com) writes:

Q.1. What is the best way to do this - should we host the database on
the same IIS server where the website is hosted, or would it be better
to put the database on a server on it's own, separate from the IIS
server?

Install on a separate box if you can. Else IIS and SQL Server will
compete for memory. There is also a security aspect.

Q.2. Also what is the best way for clients to connect to the database
for querying purposes - will I be able to install client versions of
sql server on their machines so they can connect for querying purposes
only, (cannot create tables etc), or will it be better if the clients
have sql server express installed locally and connect to the server
sql through odbc?

What clients? Didn't you say this was for a web site? Then I would
assume that client connect over the web.

It's difficult to answer this question, without knowing what the
requirements are.

Q.3. When connecting to a sql server database through odbc, using ms
access or sql server express, what happens when queries are run or
updates are made - does the original database on the server get
updated or only the local copy on the client? Also will the client
always have the most recent data?

If they update the local database, they update the local database. If
they update the central database, they update the central database. You
can set up replication, to distribute updates, but again, without
knowing what the requirements are for your possible, it's impossible to
give a useful answer.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.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

Oct 1 '07 #3

Similar topics

6069

Specify port no to connect to Informix Database through ODBC

by: Lee | last post by:

Hi, I'm developing a socket program to connect to Informix database through the ODBC. In here i called my socket program as "tap" . My tap will listen for data from unix through port 1070. After checking of the data, tap will then insert the data to the informix database. I know we can point the tap to one specified port in Informix database through the services file. My question is how should i know to which port my tap program send out...

C / C++

3645

Designing a database within a database... design question storing data...

by: Dave | last post by:

I have a system that basically stores a database within a database (I'm sure lots have you have done this before in some form or another). At the end of the day, I'm storing the actual data generically in a column of type nvarchar(4000), but I want to add support for unlimited text. I want to do this in a smart fashion. Right now I am leaning towards putting 2 nullable Value fields: ValueLong ntext nullable ValueShort nvarchar(4000)...

Microsoft SQL Server

7391

'Pure' client-side javscript database?

by: cjl | last post by:

Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure client-side javascript. I forgot to bookmark it, and now I can't find it. Anyone?

Javascript

3443

Novice question: how to make changes in an Access database

by: ronwer | last post by:

Hello, The title doesn't completely cover the question I have, but it's a bit more complicated problem we have. We are using a database, based on Acces, but developed by a third party developer who sells it under his own name. So, functionally it's a very specific database for a specific purpose. Now we want to make certain changes in this database, but for reasons of

Microsoft Access / VBA

2569

flat file vs sql database

by: Inspector | last post by:

I'm hoping I might be able to pick someone's brain out there. Our company is currently running an inhouse application in which data is being stored in SQL. Included in this data are thousands (over 100,000) of .jpg images. I am starting to run out of disk space and a developer suggested that we take the images out of SQL and put them in a file. In doing they indicated we could recover the SQL database faster if needed, we could also...

ASP.NET

3587

Database design question

by: MP | last post by:

Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this one data field - but i'm not sure) :-) Background info:

Microsoft Access / VBA

1591

Where do I put my Database relations... at DATABASE level or in PROGRAM LEVEL?

by: mesut | last post by:

Mybe it's a stupid question but : I'm starting to learn VB.NET. I have some basic skills. I'm from Mainframe world and I have same question to make my DATABASES (tables and relation) I would like to make ask my question by example. Let's say I'm a sales company I'm selling products to customers. Okay? I have these tables (databases) and fields and I have these questions. I have created these tables in VB.NET Database Connections IDE...

ASP.NET

4856

Making a database connection global

by: Terry Jolly | last post by:

Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection string in the web.config. I created a class with a static database connection and the class opens and closes the database.

ASP.NET

4726

Really need help ASAP with ASP, looping, inserting from database SP

by: clinttoris | last post by:

Hello, If someone could help me it would be appreciated as I am not having much luck. I'm struggling with my asp code and have some questions relating to asp and oracle database. First question. I have a web survey that I am working on and have successfully dynamically taken the info from a database, displayed it on the screen and then taken the users answers and inserted them into a

ASP / Active Server Pages

2335

PHP Database Class Instantiation

by: Slant | last post by:

Here's a question that most will have different answers to. I'm just dying to find a solution that seems halfway automated!! There really are two seperate issues which might be answered by the same answer. Web App: - constants.php begin - define("DB_HOST", "locahost"); .... to include the standard connection info define("DB_NAME", "mydatabase");

PHP

9719

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10620

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10369

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

6877

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5546

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5682

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4329

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3851

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3008

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General