Connecting to BUDBC
MicroStation PowerDraft can interface with an external database through a Bentley Universal Database Connection (BUDBC) connection as an alternative to Oracle, OLE DB, and ODBC connections. BUDBC support opens the MicroStation PowerDraft database interface to Visual Basic for Applications (VBA) applications. BUDBC is part of the foundation for possible future support for multiple simultaneous database connections. The MS_LINKTYPE value for BUDBC linkages is BUDBC.
There are three types of BUDBC connections:
- OLE DB — This type of connection will take a connection string from a .UDL file.
- SQL Server — The connection string for this type of connection is as follows:
Data Source=[SQL SERVER name OR IP address]; User Id=[your username]; Password=[your password]
- Oracle — The connection string for this type of connection is as follows:
Password=[your password]; User ID=[your username];Data Source=[your datasource]