Re: Database Error : System.Data.SqlClient.SqlException: SQL Server does not exist or access denied

  •  07-29-2004, 8:14 AM

    Re: Database Error : System.Data.SqlClient.SqlException: SQL Server does not exist or access denied

    Hi Adam & Lijian,

    Thank you so much for the point out. It was the Norton AV script block that caused the problem. I tested on three computers and the results are follow:
    1. Norton AV installed, script block on = can't work
    2. Norton AV installed, script block off = can't work
    3. Norton AV not installed = works normally. However, sometime the chat windows will hang if three connecting retries were attempted
     
    I just installed the ASP.Net Forum v.2 and worked properly. Then I tried to use the CuteChat config wizard to integrate it with the ASPNF2. It all worked fine until I click "Next" on the "Setup the web.config" page. The errors as follow:
     

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.NullReferenceException: Object reference not set to an instance of an object.
       at CuteChatConfig.Pages.CtrlWebConfig.DoNext()
       at CuteChatConfig.PagesContext.DoNext()
       at CuteChatConfig.SetupForm.btnNext_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
    ----------------------------------------
    CuteChatConfig
        Assembly Version: 1.0.0.0
        Win32 Version: 1.0.0.0
        CodeBase: file:///C:/Program%20Files/CuteSoft/CuteChat/CuteChatConfig.exe
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
    ----------------------------------------
    System
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
    ----------------------------------------
    System.Data
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
    ----------------------------------------
    System.EnterpriseServices
        Assembly Version: 1.0.5000.0
        Win32 Version: 1.1.4322.573
        CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just in time (JIT) debugging, the config file for this
    application or machine (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the machine
    rather than being handled by this dialog.

     
    I couldn't proceed from here onwards. So I skipped the Web.Config setup and proceed on.
    The next thing I did was to open the "web.config" file in the ASPNF2 root directory and changed the following in red:
     
    1. Configuration\CuteChat\Providers@defaultProvider="AspNetForums"
    2. Configuration\CuteChat\Providers\Provider : name="AspNetForums" sqlDataProviderType="CuteChat.AspNetForums2Lib.AspNetForumsSqlDataProvider,CuteChat.AspNetForums2Lib" userIdentityAdapterType="CuteChat.AspNetForums2Lib.SqlServerUserIdentityAdapter,CuteChat.AspNetForums2Lib"
     
    At first it displayed just like the one in your demo. but ever since I clicked the CHAT button on the forum, it becomes like:
     
     

    Server Error in '/Forums' Application.

    Compilation Error

    Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

    Compiler Error Message: CS0006: Metadata file 'c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net files\forums\d15f8608\8cfd220d\assembly\dl2\27af836e\00b450cd_6872c401\cutechat.dll' could not be found

    Source Error:

    [No relevant source lines]

    Source File:    Line: 0



     


    Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
     
    Now that everytime I access the forum page, it goes straight to this error. Can you advise me on this one?
     
    Thank you in advance. Wish to hear from you soon.
     
    Best regards,
     
    Rgain
     
View Complete Thread