+ Post New Thread
Results 1 to 1 of 1
MIS Systems Thread, Attaching FMS Database in Technical; Hi, I'm experiencing an error when trying to attach the FMS database for FMSSQL. I've tried both attaching it to ...
  1. #1

    Join Date
    Jan 2006
    Posts
    12
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Attaching FMS Database

    Hi,

    I'm experiencing an error when trying to attach the FMS database for FMSSQL.

    I've tried both attaching it to an already existing 2005 Express instance and also using the install wizard for FMS to create a new instance and then attach it.

    The error I receive is:

    A severe error occured on the current command. The results, if any, should be discarded. Please check your configuration. (usefull isn't it?)

    I Also recieve the following on occations:

    Ad hoc update to system catalogs is not supported.
    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Data.SqlClient.SqlException: Ad hoc update to system catalogs is not supported.
    at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
    at System.Data.SqlClient.SqlCommand.ExecuteScalar()
    at DbAttach.dbHelper.setDatabaseCompatabilityToSQL200 5()
    at DbAttach.dbHelper.attachSQLDatabaseRequest(String databaseName, String sourceFile)
    at DbAttach.InterfaceModeForm.buttonAttach_Click(Obje ct 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(MouseEventAr gs 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(M essage& 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.2407
    CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll
    ----------------------------------------
    DbAttach
    Assembly Version: 1.8.2.0
    Win32 Version: 1.8.2.0
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/MSSQL.1/MSSQL/Binn/DbAttach.exe
    ----------------------------------------
    System.Windows.Forms
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2365
    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.2407
    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.2327
    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.2365
    CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
    ----------------------------------------
    System.EnterpriseServices
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2326
    CodeBase: file:///c:/windows/assembly/gac/system.enterpriseservices/1.0.5000.0__b03f5f7f11d50a3a/system.enterpriseservices.dll
    ----------------------------------------
    System.Xml
    Assembly Version: 1.0.5000.0
    Win32 Version: 1.1.4322.2371
    CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.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.






    This is driving me mad. I've tried everything I can think of and nothing is working.

    Thanks in advance,

    Mike
    Last edited by mloveless; 3rd June 2008 at 04:43 PM. Reason: additional error message



SHARE:
+ Post New Thread

Similar Threads

  1. Help with Access Database
    By LozWesson in forum Group Project
    Replies: 7
    Last Post: 11th July 2012, 04:33 PM
  2. Database Convertor
    By limbo in forum Downloads
    Replies: 3
    Last Post: 14th November 2007, 04:34 PM
  3. HELP!!!! - Database
    By lalalalalalalalalalala in forum How do you do....it?
    Replies: 1
    Last Post: 21st March 2007, 10:03 PM
  4. Replies: 4
    Last Post: 28th February 2007, 10:37 AM
  5. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 10th January 2007, 12:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •