Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Error on backup - ODBC connection
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • -Project Management - Promis.e
        • -Backup and Restore Project - Project Management - Promis.e
          • Backup Project
          • Backup Your Data
          • Error - DB_Restore_BlkInfo on project restore
          • Error - Project was created in database version
          • Error - There are error during restore, rebuild this project to fix it
          • Error - Unable to restore project, project's database version is newer
          • Error on backup - ExecuteSQL error...Syntax error in INSERT INTO Device_Partnumber
          • Error on backup - ODBC connection
          • Error on Backup - The field is too small
          • Error on Backup - You still have page(s) active belong to the project
          • Error on Backup and Restore: System cannot find the file specified
          • Error on project restore - index outside bounds of array
          • Install SQL Server Management Studio
          • Moving Projects
          • Restore Project
          • Restore Sample Projects
          • Submittal Bill Of Materials (SBOM)
        • +BOM Explorer - Project Management - Promis.e
        • +Project Manager - Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

     
     Questions about this article, topic, or product? Click here. 

    Error on backup - ODBC connection

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.140
      Environment: N\A
      Area: Project Management
      Subarea: Backup and Restore Project

    Error or Warning Message

    An error occurs when trying to make a backup of a project

    Internal Error
    Error Message: ODBC--connection to '{SQL Server}SERVERNAME\BENTLEYECAD' failed.
    TargetSite: Void CreateLinkedExternalTable(System.String, System.Collections.Generic.List`1[System.String], System.Collections.Generic.List`1[System.Collections.Generic.Dictionary`2[System.String,System.Object]])
    DeclaringType: MDBProxy.ConnectionManager
    Attributes: internal
    MemberType: Method

    Steps to Resolve

    Reboot the workstation

    First, restart the workstation being used to restore the backup then try restoring the backup again.

    Check the SQL password

    The error message can occur when using SQL Server Authentication and the password on the Setup dialog is incorrect. Normally a "login failed" message is returned when leaving Setup if the password is incorrect. However, leading or trailing spaces added to the Password field, often inadvertently, are trimmed and ignored by the software, which then functions normally except for when attempting to create a project backup. In this situation project backups can be restored, but backups cannot be created.

    1. Verify the correct password is specified on Setup > Project Database.

    Check ODBC

    The message may indicate a problem outside of the software with the Windows ODBC connection to SQL Server.

    The ODBC connection can be tested with the following process:

    1. For 32-bit Promis.e/Substation on a 64-bit operating system, run \Windows\SysWOW64\odbcad32.exe
      For 32-bit Promis.e/Substation on a 32-bit system or for 64-bit Promis.e, run Control Panel > Administrative Tools > Data Sources (ODBC).
    2. Click the Add button.
    3. Select the "SQL Server" driver, click Finish.
    4. Give the data source a name and specify the SQL server Promis.e/Bentley Substation is using (as seen in the Project Database area of the Setup dialog) for the Server field. Click Next.
    5. Choose "Windows NT authentication" or "SQL Server authentication" to match what is used on Setup, click Next.
    6. After clicking Finish, click the Test Data Source button.. If there is no problem with the connection, it will return "TESTS COMPLETED SUCCESSFULLY!"

    If the test does not complete successfully or cannot be completed, contact your IT department.

      Original Author: Matt_P


    P/S: 38614, 500000065264

    Keywords: TFS 219290

    • Backup and Restore Project
    • promis.e
    • Migrated
    • error message
    • Bentley Substation
    • en
    • Project Management
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Thu, May 28 2015 3:12 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Fri, Apr 3 2020 6:50 AM
    • Revisions: 8
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies