• Session Debug and Logging Database Commands

     

    Session Debug:

    Session Debug has been in MicroStation since the MicroStation Database connections were introduced.  This handy command gives you insight into the SQL that is being generated from MicroStation or the MicroStation Database API.  It is probably the first and foremost tool for investigating Database connectivity or SQL Syntax issues.

    The Session Debug command is part of the Database MDL app…

  • Orphaned User Migrating from SQL Server 2000 to 2005

     

    In SQL Servers 2005 the concept of a schema has been added to the database.  ProjectWise V8i handles the schema as part of the qualifying the object names in the database.  In earlier versions of ProjectWise the additional schema layer can be handled as long as the schema name is the same as the user name and more so the login name.

    Many times with SQL Server databases the database is left to be owned by the System…

  • 32 Bit Database Connectivity on a 64 Bit OS

    As I've begun migrating to 64 bit Operating Systems, one thing that catches me off guard the most is setting up and using the proper ODBC drivers and OLEDB providers.  The key to getting the right one configured is to remember that if you are using a 32 bit application you want to use the 32 bit version of the ODBC driver and 32 bit version of the OLEDB provider.  If you are using a 64 bit application than you want to use…