To Set Up the ODBC Interface

Note: MicroStation supports only the 64 bit ODBC drivers. If you want to connect to a Microsoft Access database, make sure you have the 64 bit version of Microsoft Office installed.

Open the ODBC Data Source Administrator from Control Panel > Administrative Tools > ODBC Data Sources (64 bit)
Select the User or System tab depending on your requirements.
Select Add and select the ODBC driver for the database that contains your data. If using the example files, select Microsoft Access Driver.
Click Finish.
The data source dialog opens.
Define the data source name and optionally description. This is the name you will use in MicroStation's (Connect to Database dialog).

Use Select to locate the database to be accessed.

For the remaining settings, look at the table below for your specific database. Refer to your ODBC driver manual for specifics on other fields.

Database	Action
Access	Select the name of the MDB or ACCDB file.
Oracle	Provide the data source name, service name (created through the Oracle Client Configuration software), and User ID.
SQL Server	Follow the prompts in the dialog. At a minimum you should specify Name, Server, and Login/Password.