Solved

Help with Connection string for my ASP.net app SQL Server Express 2005 and ASP.net 2008

Posted on 2008-10-06
2
272 Views
Last Modified: 2010-04-21
I have I ASP.net in Visual Studio 2008.  I want to use SQL Server Express 2005 as my Backend.

I cant seem to get the connectionstring right.

Here is what I can provide

SQL Server Express is running on my Local Machine..

Server Name=WORK5\SQLEXPRESS
Database Name=MyDB
Id like to use Windows Authentication


I cant seem to get it working.

This is what I have thus far:
DRIVER=SQLOLEDB;UID = Work5; Trusted_Connection = Yes; DATABASE = MyDB; WSID = WORK5; APP=Microsoft Data Access Components Server = WORK5;


0
Comment
Question by:16spam16
2 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 50 total points
ID: 22653847
Provider=SQLNCLI;Server=WORK5\SQLEXPRESS;Database=myDB;Trusted_Connection=yes;

http://www.connectionstrings.com/?carrier=sqlserver2005
0
 
LVL 1

Author Closing Comment

by:16spam16
ID: 31503578
I already had found the answer prior to you answering it, but thank you for the quick response.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

706 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now