Support forums » Products » Cute Live Support » Re: Issues with Connection String

Issues with Connection String

Last post 02-24-2007, 10:59 PM by drewid. 11 replies.
Sort Posts: Previous Next

  •  02-06-2007, 10:57 PM 26478

    Issues with Connection String

    Reply Quote
    I really like the product, but I am having two significant issues:
     
    Environment:  Existing Asp.Net 2.0 website; with SQL Server Express Database.
     
    1)  I am getting the following error when I am trying to add in the button to the page:
     
    System.Exception: Missing appSetting:CuteChat.SqlClient.ConnectionString
     
    However, I do have a value there, but what does it need to be set to because my connection string is a very different format?
     
    Also the name for the key of "ConnectionString" is REALLY bad, because a site of any size probably combines 2-10 different components, features, functionality that all require connection strings.  Can I change this name and if so, where do I?
     
    2)  I am was getting the following error when I tried to set up the install as instructed in the deployment guide.  The app seems not to be compatible with Visual Studio 2005 and the built in browser viewing/testing.  When I launch the app it would only work if the CuteSoft_Client directory was at the top level directory, thus killing the concept of trying to isolate all of the cutelivesupport code in a sub directory.
     
    Any help on either/both of these issues would be greatly appreciated
     
    Thanks

  •  02-07-2007, 7:31 AM 26490 in reply to 26478

    Re: Issues with Connection String

    Reply Quote
    drewid,
     
    >>Can I change this name and if so, where do I?
     
    Yes. Please open Global.asax.cs file and change the following code:

    return System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  02-09-2007, 3:46 PM 26577 in reply to 26490

    Re: Issues with Connection String

    Reply Quote
    The following is my structure for the ASP.net site, which I would assume would be pretty standard:
     
    Web.config at the main level of the site.
    The CuteSoft_Client is a folder under the main level.
    I have renamed the entry in AppSettings in the web.config at the root website level to "clsConnectionString" and have updated this in the global.asax.cs file in the CuteSoft_Client folder as instructed.
     
    I still get the following error:
     
    Missing appSetting:CuteChat.SqlClient.ConnectionString
     
    Line 22: var ImageURL='<%= CuteSoft.Chat.ChatApi.HasReadyOperators()/*HasOnlineOperators()*/?URL_live_help_online_image:URL_live_help_offline_image %>';
     
    Any idea on what changes I need to make?  Do I have to change the folder structure.  Also, do I have to call the folder CuteSoft_Client?
     
    It is unusable until this is solved.
     
    Thanks

  •  02-09-2007, 3:50 PM 26578 in reply to 26577

    Re: Issues with Connection String

    Reply Quote
    Does this need to be in AppSettings or can it just be a connection string in the web.config - I am using SQLExpress and am not sure how the value needs to be constructed to meet the needs of cls.

  •  02-09-2007, 3:56 PM 26579 in reply to 26578

    Re: Issues with Connection String

    Reply Quote
    It's just a connection string and it must be included in AppSettings section.
     

     <appSettings>
      <add key="ConnectionString" value="********" />
     </appSettings>

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  02-09-2007, 4:20 PM 26582 in reply to 26579

    Re: Issues with Connection String

    Reply Quote
    Thanks but what about my questions regarding the structure?  It does not seem to be picking up the value?  I have it set in the web.config at the root level, and in the global.asax.cs file in the cutesoft_files directory.  What needs to change?

  •  02-09-2007, 4:26 PM 26584 in reply to 26582

    Re: Issues with Connection String

    Reply Quote
    I copied the global.asax and global.asax.cs to the root directory and now get a different error (I guess it fixed the previous one)...
     
    ConnectionStringProvider : CuteSoft.Chat.DefaultConnectionStringProvider return null
     
    Line 22: var ImageURL='<%= CuteSoft.Chat.ChatApi.HasReadyOperators()/*HasOnlineOperators()*/?URL_live_help_online_image:URL_live_help_offline_image %>';

  •  02-12-2007, 2:03 PM 26639 in reply to 26584

    Re: Issues with Connection String

    Reply Quote
    Any comments/suggestions?  I really want to get this up and running.
     
    Thanks

  •  02-12-2007, 3:13 PM 26642 in reply to 26584

    Re: Issues with Connection String

    Reply Quote
    drewid:
    I copied the global.asax and global.asax.cs to the root directory and now get a different error (I guess it fixed the previous one)...
     
    ConnectionStringProvider : CuteSoft.Chat.DefaultConnectionStringProvider return null
     
    Line 22: var ImageURL='<%= CuteSoft.Chat.ChatApi.HasReadyOperators()/*HasOnlineOperators()*/?URL_live_help_online_image:URL_live_help_offline_image %>';
     
     
    I think you may forget recompile your project when copying global.asax.cs file.
     
    It should be very easy.
     
    I suggest you find an ASP.NET developer close to you and help you debug the project.  It's very hard for us to debug your project without seeing it.
     
     

    asp.net Chat http://cutesoft.net/ASP.NET+Chat/default.aspx
    Web Messenger: http://cutesoft.net/Web-Messenger/default.aspx
    asp.net wysiwyg editor: http://cutesoft.net/ASP.NET+WYSIWYG+Editor/default.aspx
    asp wysiwyg html editor: http://cutesoft.net/ASP
    asp.net Image Gallery: http://cutesoft.net/ASP.NET+Image+Gallery/default.aspx
    Live Support: http://cutesoft.net/live-support/default.aspx

  •  02-12-2007, 4:32 PM 26648 in reply to 26642

    Re: Issues with Connection String

    Reply Quote
    I have given all of the basic information regarding the project.  If there is anything else required I can send that output.  I am trying to do what I think should be a very basic thing - run the livesupport application as part of an existing website.
     
    I have a visual studio 2005 web application project.  I have included the livesupport folder in the project because I need the information for the web.config file information.
     
    I have rebuilt the solution and am getting no errors.
     
    I was hoping for better answers because I do not think this is a non-standard issue.
     
    Please help!

    Server Error in '/xyz' Application.

    ConnectionStringProvider : CuteSoft.Chat.DefaultConnectionStringProvider return null

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Exception: ConnectionStringProvider : CuteSoft.Chat.DefaultConnectionStringProvider return null

    Source Error: 

    Line 20: var _liveHelpDialogFeature = "status=1,width=500,height=400,resizable=1";
            Line 21:
            Line 22: var ImageURL='<%= CuteSoft.Chat.ChatApi.HasReadyOperators()/*HasOnlineOperators()*/?URL_live_help_online_image:URL_live_help_offline_image %>';
            Line 23:
            Line 24: ImageURL= "<img  title=\"support chat\" src=\""+ImageURL+"\"width=\"141\" height=\"41\" border=0>";

    Source File: x:\Visual Studio 2005\Websites\xyz\CuteSoft_Client\CuteChat\Support-Image-Button.js.aspx    Line: 22

    Stack Trace: 

    [Exception: ConnectionStringProvider : CuteSoft.Chat.DefaultConnectionStringProvider return null]
            CuteSoft.Chat.ConnectionStringProvider.b(QueryConfiguration A_0, UserIdentity A_1) +126
            a0.a(String[] A_0, String& A_1) +132
            a0..ctor(UserIdentity identity) +424
            CuteSoft.Chat.ChatContextScope..ctor(Boolean ignoreIdentity) +218
            CuteSoft.Chat.ChatApiImpl.DoHasReadyOperators() +68
            CuteSoft.Chat.ChatApiImpl.HasReadyOperators() +57
            ASP.cutesoft_client_cutechat_support_image_button_js1_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in X:\Visual Studio 2005\Websites\xyz\CuteSoft_Client\CuteChat\Support-Image-Button.js.aspx:22
            System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +98
            System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
            System.Web.UI.Page.Render(HtmlTextWriter writer) +27
            System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
            System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +169
            System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
            System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7362

  •  02-20-2007, 5:12 AM 26819 in reply to 26648

    Re: Issues with Connection String

    Reply Quote
    Guys, are you using C# or VB.NET ?
     
    Is the website using the original structure of Visual Studio 2005 or WAP (Web Application Proyect) ?
     
    I am using the original structure of Visual Studio 2005 and VB.NET and I was dealing with this error for a long time.
     
    But I could solve it, linking the cutechat global.asax.cs file to my global.asax the following way:
     

    <%@ Application Language="VB" Inherits="LiveSupportWeb.Global" %>

     
    Something is for sure, those error messages are for problems with the global.asax

  •  02-24-2007, 10:59 PM 26946 in reply to 26819

    Re: Issues with Connection String

    Reply Quote
    VB.Net.  Thank you very much for the suggestion.  I will investigate and get back about this.
     
    Thanks!
View as RSS news feed in XML