Error opening cases

[dale....@gmail.com]

When I select opening cases I get the following error. I am not using
sqlexpress so I assume that this is hardwired into the
AdministrationManager.cs file. Will I need to download the source and
change this?

Error Message: Problems executing sql statement: SELECT [value],
[label] FROM LookupValues WHERE IDLookupTable=1 with connection:
server=.\sqlexpress;database=Sinergia;Integrated Security=true

at
Sinergia.Logic.AdministrationManager.ListEnumerationValues(CustomEnumeration
enumeration) in D:\Develop\net\Tiger\Sinergia\src\Projects\Logic
\AdministrationManager.cs:line 99 at
Sinergia.Logic.AdministrationManager.ListEnumerationValues(CaseFieldType
field) in D:\Develop\net\Tiger\Sinergia\src\Projects\Logic
\AdministrationManager.cs:line 57 at
Ticket_Management_Sample_1.InitCustomControls() in c:\Inetpub\wwwroot
\Sinergia\Web\restricted\controls\generated
\Ticket_Management_Sample_1.ascx.cs:line 56 at
Ticket_Management_Sample_1.Page_Load(Object sender, EventArgs e) in c:
\Inetpub\wwwroot\Sinergia\Web\restricted\controls\generated
\Ticket_Management_Sample_1.ascx.cs:line 34 at
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
o, Object t, EventArgs e) at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[dale....@gmail.com]

As Expected if I comment out the following from the
Ticket_Management_Sample_1.ascx file it works fine:

//DataTable dtLocation = adm.ListEnumerationValues(type);
//cmbLocation.DataValueField = "Value";
//cmbLocation.DataTextField = "Label";
//cmbLocation.DataSource = dtLocation;
//cmbLocation.DataBind();

On Mar 19, 10:15 am, "dale.har...@gmail.com" <dale.har...@gmail.com>
wrote:

[dale....@gmail.com]

From what I can work out the command Database db =
DatabaseFactory.CreateDatabase("Sinergia"); in AdminDataAccess.cs uses
the Enterpise
Library and takes its config settings from a app.config file which I
can't find. So I would need to recompile the source for this to work
correctly ... Or am I barking up the wrong tree?


On Mar 19, 12:58 pm, "dale.har...@gmail.com" <dale.har...@gmail.com>
wrote:

[dale....@gmail.com]

Ok this fixed it:

http://groups.google.com/group/sinergia-help-desk/browse_thread/thread/4428ff259790d6e2/06f4530e0bf7899f?lnk=gst&q=sqlexpress#06f4530e0bf7899f

The setting was hiding away in the database ...

On Mar 19, 1:38 pm, "dale.har...@gmail.com" <dale.har...@gmail.com>
wrote:

[gabouy]

exactly