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

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;


LVL 1
16spam16Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Daniel WilsonConnect With a Mentor Commented:
Provider=SQLNCLI;Server=WORK5\SQLEXPRESS;Database=myDB;Trusted_Connection=yes;

http://www.connectionstrings.com/?carrier=sqlserver2005
0
 
16spam16Author Commented:
I already had found the answer prior to you answering it, but thank you for the quick response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.