To set up a Data Source Name (DSN) for your ODBC data store, you add a DSN in Windows. The configuration options you specify depend on the type of ODBC data store you use. The login ID and password you enter when setting up your DSN are used only for defining the DSN, and not when you connect with the ODBC provider through FDO.
For ODBC, AutoCAD Map 3D supports point geometry, with X, Y, and optionally, Z columns for defining points. Although the default column names are X, Y, and Z, when you select the columns to represent these points, you must override the defaults. Because this information is stored in the map file itself, if you perform the same steps in another map, you will need to override the settings again.