Connection string for Cute Live Support with Access

Last post 09-28-2007, 1:30 AM by duffner.claus-stefan@koepfer.com. 2 replies.
Sort Posts: Previous Next
  •  09-27-2007, 4:02 AM 33860

    Connection string for Cute Live Support with Access

    Hi,
     
    I have installed cute live support and the CuteChat integration and the Cute Chat and Web Messenger Access Database .
    I have changed the CDQ.config under CuteSoft_Client\CuteChat\CDQ .
     
    If I open the default.aspx and login the first Time, I receive the .net-error below.
     
    I use the following connection-string in the web.config:
    <add key="ConnectionString" value="c:\inetpub\wwwroot\koepfer\cutelive\data\Access_CuteChat.mdb;connection reset=false;;Application Name=SupportWeb"/>
     
    The IUser has full acces to the Access_CuteChat.mdb.
     
    What can I do?
     
    Best regards,
    Claus-Stefan
    ----------------------

    Serverfehler in der Anwendung /cutelive.

    Schlüsselwort wird nicht unterstützt: 'c:\inetpub\wwwroot\koepfer\cutelive\data\access_cutechat.mdb;connection reset'.

    Beschreibung: Unbehandelte Ausnahme beim Ausführen der aktuellen Webanforderung. Überprüfen Sie die Stapelüberwachung, um weitere Informationen über diesen Fehler anzuzeigen und festzustellen, wo der Fehler im Code verursacht wurde.

    Ausnahmedetails: System.ArgumentException: Schlüsselwort wird nicht unterstützt: 'c:\inetpub\wwwroot\koepfer\cutelive\data\access_cutechat.mdb;connection reset'.

    Quellfehler:

    Zeile 64: 		string password=LoginPassword.Text;
                Zeile 65:
                Zeile 66: 		DataTable table=SQL.ExecuteDataSet("SELECT * FROM MyUsers WHERE LoginName=@p0",loginname).Tables[0];
                Zeile 67: 		if(table.Rows.Count==0)
                Zeile 68: 		{

    Quelldatei: c:\Inetpub\wwwroot\CuteLiveSupport\web\Login.aspx    Zeile: 66

    Stapelüberwachung:

    [ArgumentException: Schlüsselwort wird nicht unterstützt: 'c:\inetpub\wwwroot\koepfer\cutelive\data\access_cutechat.mdb;connection reset'.]
                System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +1409890
                System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +102
                System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +52
                System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24
                System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +125
                System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +56
                System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4
                System.Data.SqlClient.SqlConnection..ctor(String connectionString) +21
                LiveSupportWeb.SQL.CreateConnection() in C:\Documents and Settings\HP_Administrator\My Documents\Visual Studio 2005\Projects\LiveSupportWeb\LiveSupportWeb\SQL.cs:30
                LiveSupportWeb.SQL.CreateCommand(String commandtext, Object[] parameters) in C:\Documents and Settings\HP_Administrator\My Documents\Visual Studio 2005\Projects\LiveSupportWeb\LiveSupportWeb\SQL.cs:41
                LiveSupportWeb.SQL.ExecuteDataSet(String commandtext, Object[] parameters) in C:\Documents and Settings\HP_Administrator\My Documents\Visual Studio 2005\Projects\LiveSupportWeb\LiveSupportWeb\SQL.cs:76
                ASP.login_aspx.LoginButton_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\CuteLiveSupport\web\Login.aspx:66
                System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
                System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
                System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
                System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
                System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
                System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
                


    Versionsinformationen: Microsoft .NET Framework-Version:2.0.50727.832; ASP.NET-Version:2.0.50727.832
  •  09-27-2007, 9:34 AM 33868 in reply to 33860

    Re: Connection string for Cute Live Support with Access

    Claus,
     
    The open source project, Cute Live support web supports SQL Server only.
     
     

    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

  •  09-28-2007, 1:30 AM 33891 in reply to 33868

    Re: Connection string for Cute Live Support with Access

    Hi Adam,

    in the requirements of Cute Live Support is written:

    Database: SQL Server 2000, SQL Server 2005, Oracle, MSDE or Access

    So Access should work?

    Best regards,
    Claus-Stefan

View as RSS news feed in XML