Index:
- What general database enhancements have been made to MicroStation/J?
- What databases are supported in MicroStation/J?
- Have there been any enhancements to Visual SQL Query Builder?
- Has anything changed with the way I connect to my database in MicroStation/J?
- Can I still use the MicroStation 95 and MicroStation SE database tools?
- Is Personal Oracle supported?
Answer: The ODBC database server has been rewritten to take advantage of the Microsoft ODBC drivers. These drivers have improved the database functionality in a number of areas:
- Added ability to use Access Memo data type with Visual SQL Query Builder (VSQL).
- Enhanced decimal precision of VSQL and SQL window
- ODBC server will now support the full date/time format
- Enhanced date handling through the SQL and VSQL database interface
- MicroStation's ODBC server now fully supports Microsoft ODBC drivers with Xbase databases
- Improved memory management for database connection to ODBC databases
- MicroStation's ODBC driver now supports file data sources in addition to user data sources
- MicroStation's ODBC server now supports SQL Server 6.5 with Microsoft ODBC drivers
Answer: The following charts outline MicroStation/J database support by platform.
Supported Databases
| MicroStation/J |
ORACLE |
ORACLE FORMS |
RIS |
Informix |
Informix Forms |
Sybase |
| Windows NT 4.0 |
MicroStation/J v7.0: 7.3.4
MicroStation/J v7.1: 8.0.4/7.3.4
MicroStation/J v07.01.05.03: 9.x *** |
MicroStation/J v7.0: 4.5
MicroStation/J v7.1: N/A |
5.3 |
N/A |
N/A |
System 10/11 |
| Windows 95 |
MicroStation/J v7.0: 7.3.4
MicroStation/J v7.1: 8.0.4/7.3.4
MicroStation/J v07.01.05.03: 9.x *** |
MicroStation/J v7.0: 4.5
MicroStation/J v7.1: N/A |
N/A |
N/A |
N/A |
N/A |
| Windows 98 |
MicroStation/J v7.0: N/A **
MicroStation/J v7.1: 8.0.4
MicroStation/J v07.01.05.03: 9.x *** |
N/A ** |
N/A |
N/A |
N/A |
N/A |
| Windows 2000 |
MicroStation/J v07.01.01.57 and higher: 8.00.04
MicroStation/J v07.01.05.03: 9.x ***
| N/A** |
N/A |
N/A |
N/A |
N/A |
| Windows XP |
MicroStation/J v07.01.05.03: 9.x ***
| N/A** |
N/A |
N/A |
N/A |
N/A |
ODBC Supported Connections
| MicroStation/J |
ODBC/
Oracle |
ODBC/
XBASE |
ODBC/
SQLServer
V6.5x |
ODBC/
Access
7.0/97* |
ODBC/
Informix |
ODBC/
Sybase |
| Windows NT 4 |
MicroStation/J v7.0:
Intersolv 3.01
Microsoft 2.73.XX
Oracle 2.05.XX
MicroStation/J v7.1:
Oracle ODBC 8.00.04 |
MicroStation/J v7.0:
Intersolv 3.01
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 4.00.4202.00 |
MicroStation/J v7.0:
Intersolv 3.01
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 3.70.06.90 |
MicroStation/J v7.0:
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 4.00.4202.00 |
Intersolv 2.11 |
Intersolv 3.01 |
| Windows 95 |
MicroStation/J v7.0:
Intersolv 2.11
Microsoft 2.73.XX
Oracle 2.05.XX
MicroStation/J v7.1:
Oracle ODBC 8.00.04 |
MicroStation/J v7.0:
Intersolv 3.01
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 4.00.4202.00 |
MicroStation/J v7.0:
Intersolv 3.01
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 3.70.06.90 |
MicroStation/J v7.0:
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 4.00.4202.00 |
Intersolv 2.11 |
Intersolv 3.01 |
| Windows 98 |
MicroStation/J v7.0: N/A **
MicroStation/J v7.1: 8.00.04 |
MicroStation/J v7.0:
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 4.00.4202.00 |
MicroStation/J v7.0:
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 3.70.06.90 |
MicroStation/J v7.0:
Microsoft 3.51.XX
MicroStation/J v7.1:
Microsoft 4.00.4202.00 |
Microsoft 3.51.XX |
Microsoft 3.51.XX |
| Windows 2000 |
MicroStation/J v07.01.01.57 and higher: 8.00.04 |
MicroStation/J v07.01.01.57 and higher: MicroSoft ODBC 4.00.4403.02 |
MicroStation/J v07.01.01.57 and higher: SQL Server driver 3.70.08.20 |
MicroStation/J v07.01.01.57 and higher: Microsoft ODBC 4.00.4403.02 |
MicroStation/J v07.01.01.57 and higher: Microsoft ODBC 4.00.4403.02 |
MicroStation/J v07.01.01.57 and higher: Microsoft ODBC 4.00.4403.02 |
* Access 2.0 is no longer supported with ODBC.
** Oracle will only support Windows 98 with Oracle 8. MicroStation/J v7.0 is not supported with Oracle 8.
*** Where OS is applicable per Oracle.
Visual SQL Query Builder forms now supports forms review using saved VSQL forms. To create a form in VSQL:
- Open VSQL through the Settings > Database > Query Builder dialog.
- Create a query and execute the query.
- When the form is displayed, choose Forms > Save As and save the form to the default directory.
- The form name must be entered into the MSCATALOG Screenform column. Access the MSCATALOG through Settings > Database > Setup.
- Locate the table that the form was generated from in the MSCATALOG tables list. Click on the table name to highlight it. Add the form name to the MSCATALOG in the Screen Form area, including the .RSC extension.
- Click OK on the MSCATALOG dialog.
- The final step is to activate the screen forms by choosing Settings > Database > Dialog, and selecting Text Screen in the Forms menu and keying in VSQL REVIEW. Alternately, a button may be created, using this keyin, to active the forms when reviewing an element.
Answer: The connection dialog and the connection process from MicroStation 95 and MicroStation SE remains the same in MicroStation/J.
Answer: Yes. All of the tools available in MicroStation 95 and and MicroStation SE are included with MicroStation/J. Continued enhancements have been made to the Visual SQL Query Builder application, available through the Settings > Database menu (only after a database connection has been established).
Answer: While Personal Oracle may work in some instances, we cannot guarantee performance and it is not supported.
6172