Solved

Need to connect to a SQL Express DB

Posted on 2010-11-14
3
312 Views
Last Modified: 2012-06-27
Hi
I have tried setting up a DSN to a user in my DB and then specifying the DSN in the connection string but to no avail.  I need my Active Server pages to work on my laptop (with Windows 2003) for a presentation only so I'm not worried about security and as it's getting close to my presentation I urgently need the simplest way to connect to the DB and run the pages.  Any ideas would be greatly appreciated.
0
Comment
Question by:Lorna70
3 Comments
 
LVL 25

Accepted Solution

by:
Rouchie earned 125 total points
ID: 34131973
Are you receiving any error messages?  

On this page...
http://www.hosting.com/support/vps/windows/expressdsn
steps 1-8 should certainly get you started.
0
 
LVL 28

Assisted Solution

by:sybe
sybe earned 125 total points
ID: 34135781
http://www.connectionstrings.com/

For datasource you need to use "Data Source=your_computer_name_here\sqlexpress"


0
 

Author Closing Comment

by:Lorna70
ID: 34165453
Only given a B because a limited amount of information was given.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

786 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