AutoCAD Ctrl+6 Shortcut :DBConnect Manager

If you need a clear, step-by-step guide to using the Ctrl+6 shortcut in AutoCAD, this article explains what the shortcut does, how to use it, why it may sometimes fail, and practical alternatives and fixes. It is written for beginners and optimized to help you find answers quickly.

What the CTRL+6 shortcut does

• Ctrl+6 opens the dbConnect Manager in AutoCAD (the Windows dialog that manages external database connections and data links).
• The DBConnect Manager is used to create, edit, test, and remove database connections (for ODBC, SQL Server, Oracle, SDF, etc., depending on your AutoCAD product and installed modules).
• Note: DBConnect Manager is typically available in AutoCAD products with GIS/Map features (for example AutoCAD Map 3D, or AutoCAD with Map functionality enabled). Vanilla AutoCAD may not include DBConnect.

Where and when to use DBConnect Manager

• Use it when you need to:
  • Link attribute values or table data to External databases.
  • Import or synchronize tabular data with drawing objects.
  • Manage ODBC/DB connections used by map and data tools.
• Common workflows:
  • Creating a connection to a company SQL database to attach attribute tables.
  • Linking an Excel or CSV file through an ODBC or data-link workflow (if available).
  • Preparing data for thematic mapping or automated attribute population.

How to use Ctrl+6 (step-by-step)

1. Make sure you are using an AutoCAD version that supports DBConnect (e.g., AutoCAD Map 3D or an AutoCAD product with Map tools).
2. Open the drawing where you want to use external data. Save your work before making connections.
3. Press Ctrl+6 on your keyboard.
   • Alternative: Type DBCONNECT at the command line and press Enter (if the command exists in your installation).
4. The DBConnect Manager window opens. Typical panes include a list of existing connections and controls to create or edit connections.
5. To create a new connection:
   • Click New (or Create Connection).
   • Choose the connection type (ODBC, SQL Server, Oracle, SDF, etc.) from the available options.
   • Enter connection details: server, database name, username, password, and any required driver settings.
   • Test the connection using the Test button to verify credentials and network access.
6. Once the connection is created, you can:
   • Preview tables and fields.
   • Attach a table to the drawing or link data to objects or attributes.
   • Configure queries or filters to import only the necessary records.
7. Use the Import or Attach buttons to bring the data into the drawing. Choose whether to create a table object, populate attributes, or create links that can be refreshed.
8. Save and close the DBConnect Manager. If you created live links, use the refresh options when the source data changes.

Alternative commands and methods

• DATALINK (Data link Manager): Use this to link Excel spreadsheets and other tabular data in many AutoCAD versions. Command: type DATALINK.
• TABLE > From Data Link: Create a table from a linked data source (Excel, CSV).
• DATAEXTRACTION: Extract drawing object properties and create tables or external files (useful if you want internal drawing data).
• external references (XREF): For attaching other DWG files; not for database record links but useful for different workflows.
• If DBConnect is not available in your AutoCAD edition, consider using Map 3D functionality or exporting your data to a supported format (CSV/Excel) and using DATALINK.

Common reasons Ctrl+6 doesn’t work and how to fix them

• Reason: Your AutoCAD edition does not include DBConnect (e.g., plain AutoCAD).

  • Fix: Install/enable Map features (AutoCAD Map 3D) or use DATALINK / CSV import workflows.

• Reason: Shortcut is disabled, changed, or overridden by another program.

  • Fix: Reassign the shortcut in CUI (Customize user interface) or use the DBCONNECT command.

• Reason: Command alias is missing or command not found.

  • Fix: Type DBCONNECT or DATALINK at the command line. If not found, load the required Map module or application menu.

• Reason: DBConnect window opened off-screen (multi-monitor or resolution change).

  • Fix: Use Alt+Tab to select the window, then press Alt+Space → Move, and use arrow keys to bring it back. Or temporarily change display settings to find it.

• Reason: Keyboard or hardware issue.

  • Fix: Test other Ctrl shortcuts (Ctrl+S, Ctrl+C). If they fail, check keyboard, try another keyboard, or use on-screen keyboard.

• Reason: Profile or workspace issue (custom workspace removed shortcuts).

  • Fix: Reset workspace or switch to a Default workspace. Reapply a saved profile if needed.

• Reason: Missing ODBC/DB drivers or network/permission issues when connecting.

  • Fix: Install correct 32/64-bit ODBC drivers, check firewall, ensure credentials are valid, and test connection outside AutoCAD (e.g., ODBC Data Source Administrator).

• Reason: Dialog blocked by a modal command or an error is preventing UI interaction.

  • Fix: Cancel current command (Esc), save, restart AutoCAD, and try again.

Practical tips and best practices

• Always save your drawing before creating or attaching database connections.
• Use Test in the DBConnect Manager to verify credentials and driver compatibility.
• Keep a backup of your drawing and connection settings before making major changes.
• Prefer read-only connections if you only need to display or reference data.
• If you need repeated access, create named connections and save them in your profile for reuse.
• For Excel links, check whether DATALINK is a simpler option for your workflow.
• When sharing drawings, ensure coworkers have the same ODBC drivers and access rights to avoid broken links.
• Document connection details (server, database, user) in a project metadata file for team use.

FAQ

How can I open DBConnect Manager if Ctrl+6 does nothing?

Type DBCONNECT at the command line (if available). If the command is not recognized, you likely don’t have the Map/DBConnect module installed in your AutoCAD edition—use DATALINK or install Map 3D features.

Is DBConnect Manager available in standard AutoCAD?

Not always. DBConnect is commonly available in AutoCAD Map 3D and products with GIS/data features. Standard AutoCAD may not include it.

What’s the difference between DBConnect and Data Link (DATALINK)?

DBConnect manages database connections (ODBC/SQL/Oracle/etc.) and live DB links. DATALINK is typically used to link spreadsheet-like sources (Excel/CSV) into tables. Choose based on your source type and product capabilities.

My DBConnect dialog is off-screen — how do I retrieve it?

Select the window (Alt+Tab), press Alt+Space, choose Move, and use arrow keys to bring it onto the screen. Alternatively, change display resolution temporarily or reset workspace.

Can I automate refreshing DB connections?

Yes — DBConnect and Data Link workflows often include refresh options. In scripts or LISP routines you may trigger refresh commands; check your AutoCAD product documentation for exact command names and API support.

What drivers do I need for DBConnect to work?

You need the correct ODBC/OLE DB drivers for your database and the matching 32-bit/64-bit version for your AutoCAD installation. Install drivers from the database vendor and configure system DSNs if required.

How do I reassign Ctrl+6 if another program captures it?

Open the CUI (Customize User Interface) in AutoCAD, find the keyboard shortcuts, and assign Ctrl+6 to the DBCONNECT command or create a new macro. Save and apply the workspace.

Will DBConnect alter my source database?

By default, DBConnect is used to read or link data into drawings. Writing back or modifying the source depends on the connection type and actions you perform. Use read-only connections for safety unless you explicitly intend to update the database.