Solved

Using SQL 2005 database with asp

Posted on 2007-04-11
2
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

732 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