Advertisement

01.17.2008 at 12:34PM PST, ID: 23091472
[x]
Attachment Details

Creating Data Connection - Visual Studio 2005 & SQL Express 2005

Asked by smaguire in Microsoft Visual C#.Net, SQL Server 2005

Tags: SQL Server Express 2005, C# 2005

hi,
I have a working solution, VS 2005 using C# where i save data through DataAdapters to MS SQL Server 2005 Full blown version. I needed to move my C# project into another machine with C# Express installed on it (the free edition by microsoft) and SQL Express 2005. now in machine1 (with the full version) everything is working great, with machine 2 i am having a hard time configuring the database to make it work with visual studio since the express edition uses a data file instead of the full .mdf database.

From my Data Explorer Tab (in C# Express version) i am trying to create a new Data Connection, I get the following error after providing the database file name:
Cannot open user default database. Login failed. Login failed for user 'WKDEV\Administrator'.

From SQL Express enterprise studio i was able to restore the database just fine. has anyone gone through this before?Start Free Trial
[+][-]01.17.2008 at 12:44PM PST, ID: 20685195

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.17.2008 at 12:53PM PST, ID: 20685283

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.17.2008 at 01:16PM PST, ID: 20685509

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Visual C#.Net, SQL Server 2005
Tags: SQL Server Express 2005, C# 2005
Sign Up Now!
Solution Provided By: ptjcb
Participating Experts: 1
Solution Grade: C
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628