Solved

Using SQL 2005 database with asp

Posted on 2007-04-11
2
165 Views
Last Modified: 2010-03-19
Using SQL 2005

When using access.mbd with an asp website I usually create a database within the web site directory and then create a connection so that the pages can use the database.
I am wanting to use sql 2005 and I am not sure where the database should be placed or how and whether a connection is created.

Can anyone please offer some advice on this, I am finding it difficult to get this from the books I have.

Thanks
John
0
Comment
Question by:johnhardy
2 Comments
 
LVL 11

Accepted Solution

by:
dready earned 500 total points
ID: 18889274
It doesnt matter where you put your sql server. It might be on the same server, or on another machine. You connect to the database using a connectionstring, something like:
connectionstring = "Server=myServer\myInstance;uid=sa;pwd=myPassword;database=myDB"

0
 

Author Comment

by:johnhardy
ID: 18889720
Thank You
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question