Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

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;


0
16spam16
Asked:
16spam16
1 Solution
 
Daniel WilsonCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now