Solved

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

Posted on 2008-10-06
2
277 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 64
C# rename a class and update all references efficiently 6 55
Removing Version of .NET in Windows 10 17 130
Datagridview column resizing 8 28
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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

751 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