|
|
Posted by Sue on 10/01/07 06:21
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....
Navigation:
[Reply to this message]
|