Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
MicroStation
  • Product Communities
  • More
MicroStation
MicroStation Wiki Inability to connect to database from ProjectWise Managed Workspace session: _USTN_DATABASE
    • Sign in

    • -MicroStation Wiki
      • +Learning Tips
      • -MicroStation
        • +3D Printing - MicroStation
        • +Animation - MicroStation
        • +Archive / Backup - MicroStation
        • +Base Geometry - MicroStation
        • +Batch Processing - MicroStation
        • +CONNECT Advisor - MicroStation
        • CONNECT Integration - MicroStation
        • +CONNECTION Client
        • +Cells - MicroStation
        • +Change Tracking - MicroStation
        • +Configuration - MicroStation
        • +Coordinate Systems - MicroStation
        • +Curves - MicroStation
        • +Custom Linestyles - MicroStation
        • +DGN - MicroStation
        • +DWG - MicroStation
        • -Database - MicroStation
          • +Access - Database - MicroStation
          • -General - Database - MicroStation
            • Inability to connect to database from ProjectWise Managed Workspace session: _USTN_DATABASE
            • MicroStation CONNECT Supported Databases
            • MicroStation V8 2004 Supported Databases [FAQ]
            • MicroStation V8 XM Supported Databases [FAQ]
            • MicroStation V8i Supported Databases [FAQ]
            • Unable to Fill a Shape 'Type 6' that has DMRS Linkages
            • Unleashing Database Linkages In MicroStation [CS]
            • Verify Linkages dialog appears every time I start MicroStation
            • Working With Displayable Attributes [CS]
          • Informix - Database - MicroStation
          • +ODBC - Database - MicroStation
          • +Oracle - Database - MicroStation
          • RIS - Database - MicroStation
          • Sybase - Database - MicroStation
          • +VSQL - Database - MicroStation
          • Xbase - Database - MicroStation
        • +Detailing Symbols - MicroStation
        • +Dimensions - MicroStation
        • +Documentation & Help - MicroStation
        • +Drawing Aids - MicroStation
        • +Exception - MicroStation
        • +FAQ - MicroStation
        • +Feature Based Solids Modeling - MicroStation
        • +File Access - MicroStation
        • +GUI - MicroStation
        • +General - MicroStation
        • +Graphics Display - MicroStation
        • +Groups - MicroStation
        • +Hardware / Input Devices - MicroStation
        • +Import/Export - MicroStation
        • +Installation - MicroStation
        • +Interchange - MicroStation
        • +Interference - MicroStation
        • +Internationalization - MicroStation
        • +Levels - MicroStation
        • +Licensing - MicroStation
        • +Manipulation - MicroStation
        • +Markup / Redline - MicroStation
        • +Measure - MicroStation
        • +Mesh - MicroStation
        • +Models - MicroStation
        • +Multi-Lines - MicroStation
        • +OLE - MicroStation
        • +Other - MicroStation
        • +Parametrics - MicroStation
        • +Patterning - MicroStation
        • +Point Cloud - MicroStation
        • +Printing - MicroStation
        • +Programming - MicroStation
        • +Project Navigation - MicroStation
        • +Properties - MicroStation
        • +RSS Feeds - MicroStation
        • +Reference - MicroStation
        • +Security - MicroStation
        • +Selection - MicroStation
        • +Settings - MicroStation
        • +Sheet Composition - MicroStation
        • +Solids - MicroStation
        • +Standards - MicroStation
        • +Surfaces - MicroStation
        • +Tables - MicroStation
        • +Text - MicroStation
        • +UI Customization - MicroStation
        • +Units - MicroStation
        • +View - MicroStation
        • +Visualization - MicroStation
        • Welcome Page - MicroStation
        • +Accreditation - MicroStation
        • +i.Models - MicroStation
        • +ProjectWise Integration
        • +Raster - MicroStation
    • +Administration Wiki
    • +Annotations Wiki
    • +Bentley View Wiki
    • +MicroStation PowerDraft
    • +Programming Wiki
    • +Visualization Wiki

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

    Inability to connect to database from ProjectWise Managed Workspace session: _USTN_DATABASE

      Product(s): MicroStation; ProjectWise
      Version(s): 10.xx.xx.xx
      Environment: N\A
      Area: Database; Managed Workspaces / Worksets
      Subarea: N\A

    Problem

    When MicroStation is launched from ProjectWise in the context of Managed Workspaces (Worksets) attempts to connect to a database via the MicroStation non-graphical database interface may fail.

    Solution

    Common expressions of the failure are, but not limited to:

    Inability to Browse for Data Source from within the Connect to Database dialog:

    Connect to Database dialog

    An unresponsive DB= statement:

    Under normal operation, when the connection type is set we should see the message:  Database: NONE

     After setting the connection type and executing a DB= command, we should likewise see Database: NONE  (if invalid), or the connection details, or the next step in the connection process (e.g. password dialog).

    A failing session will likely display:

    Illegal type in MS_LINKTYPE

    and

    Database server is not active

    Key-in, Messages example

    Failures expressed as above are an indicator that dbconmgr is unable to locate the requisite configuration variables.

    During normal operation, definition of these variables occurs when the connection type is set.

    e.g.

    dbconmgr odbc      (loads values from odbc.cfg)
    dbconmgr oracle   (loads values from oracle.cfg)

    before database connection type is set, variables are undefined :

    before setting database type

    and e.g. after executing dbconmgr odbc :

    after setting database connection type

    In a default desktop MicroStation installation, these configuration files are defined by the variable:

      _USTN_DATABASE

    Directory containing MicroStation database configuration files.  (_USTN_DATABASE)

     as

    $(MSDIR)config\database\

     * To check for the variable definition within a session of MicroStation, _USTN_DISPLAYALLCFGVARS must be set to 1

    If set, all configuration variables (including those of the format _USTN_xxx) will be displayed.  (_USTN_DISPLAYALLCFGVARS)

    Edit Configuration Variable: _USTN_DATABASE

    If your Managed Workspace session of MicroStation is missing the _USTN_DATABASE definition and failing to connect, you will need to account for the variable within your Managed Workspace:

    Configuration Block definition - ProjectWise Administrator

      Original Author: Nelson Hobdell
    • MS_LINKTYPE
    • Managed Workspaces
    • database server is not active
    • ProjectWise Administrator
    • database linkages
    • _USTN_DISPLAYALLCFGVARS
    • _USTN_DATABASE
    • Illegal type in MS_LINKTYPE
    • Share
    • History
    • More
    • Cancel
    • Nelson Hobdell Created by Bentley Colleague Nelson Hobdell
    • When: Wed, Dec 8 2021 9:47 PM
    • Nelson Hobdell Last revision by Bentley Colleague Nelson Hobdell
    • When: Mon, Dec 13 2021 10:47 AM
    • Revisions: 5
    • 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

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