Learning about Project Tracker and Connection Strings

Learning about Project Tracker and Connection Strings

Old forum URL: forums.lhotka.net/forums/t/11841.aspx

DaveWaldron posted on Friday, February 15, 2013

Okay, I admit it!

I have avoided asking for help for years! Smile I now have to bow and ask for the Gods to rain enlightenment!  I have project tracker working as configured. ( this is the 4.5.10 download)  but I can't figure out how to switch from the (LocalDB)  VS2012 to SQLExpress 2012. That's the only change I want to make now.  Help me obi wan(s).

 

BTW:  This is my first post ever!   So be gentle!  Big Smile

JonnyBee replied on Saturday, February 16, 2013

Did you install SqlServer 2012 Express Tools?

If so use SqlServer Management Studio to browse for available servers and find the instance name. 

DaveWaldron replied on Saturday, February 16, 2013

Yes, I use sql and sql express all the time.  In fact I am pretty good at that stuff.  I just don't understand the connection strings and how to convert them to using the .\SQLExpress  instance that is installed and working on my development box.  I have copied the two database .MDF files to a different location and attached them to SQLExpress.

Just can't figure out how to modify these two entries:

 

<

 

 

 

 

Lot of extra stuff here because of ... entity framework?

Thanks for your help.

add name="PTrackerEntities" connectionString="metadata=res://*/PTracker.csdl|res://*/PTracker.ssdl|res://*/PTracker.msl;provider=System.Data.SqlClient;provider connection string='Data Source=(LocalDB)\v11.0;attachdbfilename=|DataDirectory|PTracker.mdf;integrated security=True;multipleactiveresultsets=True;App=EntityFramework'" providerName="System.Data.EntityClient" />

<a

 

 

dd name="ApplicationServices" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|aspnetdb.mdf;Integrated Security=True;Connect Timeout=30" providerName="System.Data.SqlClient" />

DaveWaldron replied on Saturday, February 16, 2013

OK, I was making it too complex.  Turns out the connectionstrings are like these two when connecting  to SQLExpress.

 

 

<

 

 

 

add name="PTrackerEntities" connectionString="metadata=res://*/PTracker.csdl|res://*/PTracker.ssdl|res://*/PTracker.msl;provider=System.Data.SqlClient;provider connection string='Data Source=.\SQLExpress;Initial Catalog=PTRACKER.MDF;Integrated Security=True;multipleactiveresultsets=True;App=EntityFramework'" providerName="System.Data.EntityClient"

/>

<

 

 

 

add name="ApplicationServices" connectionString="Data Source=.\SQLExpress;Initial Catalog=ASPNETDB.MDF;Integrated Security=True;Connect Timeout=30" providerName="System.Data.SqlClient"

/>

Thanks for helping me get my brain engage again.

tiago replied on Saturday, February 16, 2013

Hi Dave,

Assuming that you know how to configure and run SQL Express, all you should have to do is to open the web.config file on the WcfAppServer project and edit the connection strings, replacing

(LocalDB)\v11.0

by

.\SQLEXPRESS

Furthermore, insert in the connection string somewhere

user instance=True;

for instance, just after integrated security=True;

 

This should do the trick and I tested it with other samples (ActionExtenderSample).

The point is I can't run PTracker using either LocalDB or SQLEXPRESS. I mean it runs, but I can't login or display any data on the UI.

<Edit>

Forgot to say I'm running SQL Server 2008 as User Instance was deprecated on SQL Server 2012.

</Edit>

Copyright (c) Marimer LLC