Hi,
I tried to install splendidCRM on my pc and got following error message when I compiled the project. My system is: XP sp2, VS2008 pro(9.0.21022.8), VS2005 team edition (8.0.50727.762), SQL2005. The system and all the applications are using the latest update batch.
Compiler Error Message: CS0103: The name 'Sql' does not exist in the current contextSource Error: Line 92: <asp:TableCell Width="30%" CssClass="dataLabel"><%= L10n.Term("Users.LBL_USER_NAME") %></asp:TableCell> Line 93: <asp:TableCell Width="70%"> Line 94: <asp:TextBox ID="txtUSER_NAME" size="20" style="width: 125px" Runat="server" /> <%= (Sql.IsEmptyString(Application["CONFIG.default_user_name"]) ? String.Empty : "(" + Sql.ToString(Application["CONFIG.default_user_name"]) + ")") %> Line 95: </asp:TableCell> Line 96: </asp:TableRow>Source File: c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx Line: 94
Line 92: <asp:TableCell Width="30%" CssClass="dataLabel"><%= L10n.Term("Users.LBL_USER_NAME") %></asp:TableCell> Line 93: <asp:TableCell Width="70%"> Line 94: <asp:TextBox ID="txtUSER_NAME" size="20" style="width: 125px" Runat="server" /> <%= (Sql.IsEmptyString(Application["CONFIG.default_user_name"]) ? String.Empty : "(" + Sql.ToString(Application["CONFIG.default_user_name"]) + ")") %> Line 95: </asp:TableCell> Line 96: </asp:TableRow>
C:\WINDOWS\system32> "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /t:library /utf8output /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\assembly\dl3\4d688b36\003e8a45_e11ac701\ICSharpCode.SharpZLib.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.ProcessingObjectModel\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.ProcessingObjectModel.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_listheader.ascx.b22bda47.iq2gyype.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.Common.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_286i1ei_.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\Microsoft.ReportViewer.WebForms\8.0.0.0__b03f5f7f11d50a3a\Microsoft.ReportViewer.WebForms.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Extensions\1.0.61025.0__31bf3856ad364e35\System.Web.Extensions.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel.Web\3.5.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\assembly\dl3\537fbc75\00f2e748_5437c801\MySql.Data.DLL" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_cyd6vmhn.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_global.asax.86-girkt.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\assembly\dl3\b3bea96f\002f5e01_5c00c801\AjaxControlToolkit.DLL" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\assembly\dl3\157323af\00e8e12e_dd1ac701\FredCK.FCKeditorV2.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\assembly\dl3\0c00e873\8b0fd1d7_6ab5c801\SplendidCRM.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.WorkflowServices\3.5.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /out:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.dll" /debug- /optimize+ /win32res:"c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\xpnxf6ff.res" /w:4 /nowarn:1659;1699;1701 "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.0.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.1.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.2.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.3.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.4.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.5.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.6.cs" "c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\splendidcrm5\06fd733c\fbc3a54\App_Web_xpnxf6ff.7.cs" Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433 for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727 Copyright (C) Microsoft Corporation 2001-2005. All rights reserved. c:\Program Files\SplendidCRM Software\Web Site\Users\EditView.ascx(64,36): error CS0246: The type or namespace name 'DynamicControl' could not be found (are you missing a using directive or an assembly reference?) c:\Program Files\SplendidCRM Software\Web Site\Users\EditView.ascx(65,36): error CS0246: The type or namespace name 'DynamicControl' could not be found (are you missing a using directive or an assembly reference?) c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx(94,102): error CS0103: The name 'Sql' does not exist in the current context c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx(94,184): error CS0103: The name 'Sql' does not exist in the current context c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx(100,121): error CS0103: The name 'Sql' does not exist in the current context c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx(100,202): error CS0103: The name 'Sql' does not exist in the current context c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx(147,17): error CS0103: The name 'Utils' does not exist in the current context c:\Program Files\SplendidCRM Software\Web Site\Users\LoginView.ascx(148,17): error CS0103: The name 'Utils' does not exist in the current context
I read one thread about the issue in the forum, but it didn't give out solution;
I tried to re reference the SplendidCRM.dll, couldn't solve the problem, but got warning messages say "the dll file conficts with 'xxx.cs' file in _code folder".
Is there any one can help me out?
Cheers,
Ron
Hi Ron,
I've had this error before as well - just trying to remeber how I fixed it.
I think it was something simple like enabling local and remote connections using tcp/ip only in the sql surface area configuration tool and running the SplendidConfigure utility again - but I can't remeber now exactly.
If you run SplendidConfigure test the database string and make sure you are actually connecting to the DB and these settings are reflected in web.config
Splendid Support will be online in a short while and will know for sure - I'm just hypothesising
I suspect that the issues is that the project was not opened as a Web Applications Project. Opening the SplendidCRM5.csproj file manually should solve your problem.
We have tested the latest build on VS 2008, so we are confident that you will be able to resolve the issue quickly.
Thanks for the feedback. I solved the problem. Since I did open the project file at the first time but not the website, so i don't think it is the reason. See below is the possible reasons:
1. turn on TCP/IP on SQL server (which is not the default setting) I happened to find a article talking about it on google. thanks spacecowboy for your suggestion too.
2. don't remove the source control component permenantly (haven't tried to do so and don't know if it is related)
It is working with vs2005 team edition now, haven't tried it with vs2008 since it always asks me to convert the project.
Anyway, it works, thanks for you guys!
In our tests, we opened the project in VS 2008, removed source control and converted the project. All worked as expected.
