Solved

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

Posted on 2008-10-06
2
274 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

777 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