CuteChatConfig.exe cant connect to my new host dabase

Last post 12-05-2005, 7:03 PM by belcherman. 8 replies.
Sort Posts: Previous Next
  •  07-17-2005, 12:57 AM 8806

    CuteChatConfig.exe cant connect to my new host dabase

    I just change of hosting, but when I try to install the module cutechat for DNN31, I get an error from the cutechatconfig.exe saying that SQL server does not exist but I am using the same connection string that is in web.config in my DNN31.
    My hosting tech support says that is the connection string but I try in diferent hosts and it works.
    Any Idea?
    My hosting is godaddy.com
  •  07-17-2005, 1:38 AM 8807 in reply to 8806

    Re: CuteChatConfig.exe cant connect to my new host dabase

    I just talked again with my hosting's tech support, and they told me that their SQL server wont accept remote connections.
    So my question now is, is ther any other way of doing what the cutechateconfig.exe does manually?
    I can access my database throuhg their sql manager
  •  07-21-2005, 9:25 AM 8928 in reply to 8807

    Re: CuteChatConfig.exe cant connect to my new host dabase

    puma:
     
    If the server reject the remote connections , does the server provide another way to execute sql-script ?

    you could direct set the config by sql :

    DELETE Chat_Config
    INSERT Chat_Config (ConfigName,ConfigValue) VALUES (N'DataProvider',N'MyDataProvider,MyAssembly')
     
    Regards , Terry .
  •  07-22-2005, 4:39 PM 8994 in reply to 8928

    Re: CuteChatConfig.exe cant connect to my new host dabase

     
    Terry
    Thanks for your response.
    Yes I can user their SQL manaager to execute scripts. Actually that is the way I executed the SQL script cutechat2.sql.
    But can you tell how can I execute a SQL script that do the same thing of importing the file import-this.xml with the CuteChatConfig.exe program.
    What would be the steps to do that.
     
    Thanks
  •  11-04-2005, 9:22 AM 12261 in reply to 8928

    Re: CuteChatConfig.exe cant connect to my new host dabase

    Terry;
     
    I'm able to add these fields directly into the tables using emterprise manager but want to know if what I'm supposed to enter is exactly what you show on your sample. I am a bit confused about the DataProvider and MyDataProvider values listed.
     
    If you can help with this I would be very greatful.
     
    Thaks,
  •  11-04-2005, 11:39 AM 12272 in reply to 12261

    Re: CuteChatConfig.exe cant connect to my new host dabase

    For example, if you are using the standalone project, you Chat_Config table should contains the following values (you can find it from the import-this.xml).

    ConfigName
     
    ConfigValue
     Announcement
     
    Welcome to Cute Chat
    ChannelSkins
     
    Normal,MacWhite,MacBlue,Royale,Indigo,Classic
    DataProviderType
     
    SamplePortal.CuteChatIntegration.DataProvider,Sampleportal
    Description 
     
    config for sample portal

     
    DELETE Chat_Config
    INSERT Chat_Config (ConfigName,ConfigValue) VALUES (N'Announcement',N'Welcome to Cute Chat')
    INSERT Chat_Config (ConfigName,ConfigValue) VALUES (N'ChannelSkins',N'Normal,MacWhite,MacBlue,Royale,Indigo,Classic')
    INSERT Chat_Config (ConfigName,ConfigValue) VALUES (N'DataProviderType',N'SamplePortal.CuteChatIntegration.DataProvider,Sampleportal')
    INSERT Chat_Config (ConfigName,ConfigValue) VALUES (N'Description',N'config for sample portal')

      

    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

  •  11-04-2005, 7:03 PM 12288 in reply to 12272

    Re: CuteChatConfig.exe cant connect to my new host dabase

    Thanks for clearing that up for me. Can you help me with this error;
     

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Only elements allowed

    Source Error:

    Line 5:  		<add key="ConnectionString" value="server=(local);database=SamplePortal;uid=sa;pwd=" />
    Line 6:  		<add key="OnlineTimeout" value="300" />
    Line 7:  		<add key="CuteChat.SqlClient.ConnectionString" value="server=(local);database=SamplePortal;uid=sa;pwd=;connection reset=false;;Application Name=SamplePortal" />-->
    Line 8:  	</appSettings>
    Line 9:      

    Source File: C:\downloads\CuteChatstandalone\Web\web.config    Line: 7


    Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.203
     
    Thanks again for your help. These darn errors make it very hard to try this application. I sure hope you can clear this error for me since I can't make heads or tails of it.
     
    Jaime
  •  11-04-2005, 7:15 PM 12289 in reply to 12288

    Re: CuteChatConfig.exe cant connect to my new host dabase

    <add key="CuteChat.SqlClient.ConnectionString" value="server=(local);database=SamplePortal;uid=sa;pwd=;connection reset=false;;Application Name=SamplePortal" />-->
     
    Should be:
     
    <add key="CuteChat.SqlClient.ConnectionString" value="server=(local);database=SamplePortal;uid=sa;pwd=;connection reset=false;;Application Name=SamplePortal" />

    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

  •  12-05-2005, 7:03 PM 13438 in reply to 8806

    Re: CuteChatConfig.exe cant connect to my new host dabase

     puma wrote:
    I just change of hosting, but when I try to install the module cutechat for DNN31, I get an error from the cutechatconfig.exe saying that SQL server does not exist but I am using the same connection string that is in web.config in my DNN31.
    My hosting tech support says that is the connection string but I try in diferent hosts and it works.
    Any Idea?
    My hosting is godaddy.com




    I am having the same issue as this guy was except it is not for DNN31. I have remote connections on and the database exists and the user has all the rights available. I have terminal services access to the machine and sql server management studio full access and admin so I know as I see it there and I set it up. I have tried the string with many different administrator accounts also and the same error happens

    Example
    server=(local)\portal;database=SamplePortal;uid=cutechat;pwd=chat


    Gives the error
    System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
View as RSS news feed in XML