2012
Table Of Contents
- Contents
- Get Information
- The User Interface
- Tools in the Application Window
- Other Tool Locations
- Access the Classic Menu Bar
- Toolbars
- Status Bars
- Keytips
- The Command Line Window
- Shortcut Menus
- Tool Palettes
- DesignCenter
- Content Explorer
- Overview of Content Explorer
- Understand the Relationship between Content Explorer and Content Service
- Understand the Content Explorer Window
- Understand How Content Is Indexed
- Understand Watched Folders
- Manage Content Sources
- Basic Searching with Content Explorer
- Advanced Searching with Content Explorer
- Manage Saved Searches in Content Explorer
- Browse Folders with Content Explorer
- Filter Results in Content Explorer
- Sort and Group Results in Content Explorer
- Customize the View in Content Explorer
- Perform Tasks with Files in Content Explorer
- Perform Tasks with Objects in Content Explorer
- Streamline Searches with User-Created Properties in Content Explorer
- Troubleshooting Content Explorer
- Customize the Drawing Environment
- Start and Save Drawings
- Control the Drawing Views
- Change Views
- Use Viewing Tools
- Display Multiple Views in Model Space
- Organize Drawings and Layouts
- Create Single-View Drawings (Model Space)
- Create Multiple-View Drawing Layouts (Paper Space)
- Work with Sheets in a Sheet Set
- Create and Modify Objects
- Control the Properties of Objects
- Work with Object Properties
- Work with Layers
- Work with Colors
- Work with Linetypes
- Control Lineweights
- Control the Display Properties of Certain Objects
- Use Precision Tools
- Create Objects
- Select and Modify Objects
- Select Objects
- Correct Mistakes
- Erase Objects
- Cut, Copy, and Paste with the Clipboard
- Modify Objects
- Add Constraints to Geometry
- Control the Properties of Objects
- Define and Reference Blocks
- Work with Blocks
- Create and Modify Blocks
- Add Behaviors to Blocks (Dynamic Blocks)
- Overview of Dynamic Blocks
- Quick Start to Creating Dynamic Blocks
- Create and Edit Dynamic Blocks
- Add Constraints to Dynamic Blocks
- Add Action Parameters to Dynamic Blocks
- Work with 3D Models
- Create 3D Models
- Overview of 3D Modeling
- Create Solids and Surfaces from Lines and Curves
- Create Solids
- Create Surfaces
- Create Meshes
- Create Wireframe Models
- Add 3D Thickness to Objects
- Modify 3D Models
- Overview of Modifying 3D Objects
- Use Gizmos to Modify Objects
- Use Grips to Modify Solids and Surfaces
- Modify 3D Subobjects
- Work with Complex 3D Solids and Surfaces
- Modify the Properties of 3D Solids, Surfaces, and Meshes
- Modify Surfaces
- Modify Mesh Objects
- Modify 3D Solids and Surfaces Using Inventor Fusion
- Create Sections and Drawings from 3D Models
- Create Drawings from 3D Models
- Create Drawings from AutoCAD and Inventor 3D Models
- Create Drawings from Other 3D CAD Models
- Work with Sections
- Create a Flattened View
- Create Drawings from 3D Models
- Create 3D Models
- Annotate Drawings
- Work with Annotations
- Hatches, Fills, and Wipeouts
- Notes and Labels
- Tables
- Dimensions and Tolerances
- Understand Basic Concepts of Dimensioning
- Use Dimension Styles
- Set the Scale for Dimensions
- Create Dimensions
- Modify Existing Dimensions
- Add Geometric Tolerances
- Plot and Publish Drawings
- Specify Settings for Plotting and Publishing
- Save Plot Settings as Named Page Setups
- Reuse Named Page Setups
- Specify Page Setup Settings
- Select a Printer or Plotter for a Layout
- Select a Paper Size for a Layout
- Determine the Drawing Orientation of a Layout
- Set the Plot Area of a Layout
- Adjust the Plot Offset of a Layout
- Set the Plot Scale for a Layout
- Set the Lineweight Scale for a Layout
- Select a Plot Style Table for a Layout
- Set Shaded Viewport and Plot Options for a Layout
- Other Ways to Create Page Setups
- Use Named Page Setups with Sheet Sets
- Print or Plot Drawings
- Overview of Plotting
- Use a Page Setup to Specify Plot Settings
- Select a Printer or Plotter
- Specify the Area to Plot
- Set Paper Size
- Position the Drawing on the Paper
- Control How Objects Are Plotted
- Preview a Plot
- Plot Files to Other Formats
- Publish Drawings
- Specify Settings for Plotting and Publishing
- Share Data Between Files
- Reference Other Drawing Files
- Link and Embed Data (OLE)
- Work with Data in Other Formats
- Convert Drawing File Formats
- Import Other File Formats
- Import Autodesk 3ds MAX Files
- Import FBX Files
- Import 3D Point Cloud Files
- Import ACIS SAT Files
- Convert DXF and DXB Files to DWG Format
- Import MicroStation DGN Files
- Import IGES Files
- Import STEP Files
- Import Pro/ENGINEER Files
- Import Rhino Files
- Import CATIA Files
- Import SolidWorks Files
- Import JT Files
- Import UGS NX Files
- Import Parasolid Files
- Insert WMF Files
- Attach Files as Underlays
- Attach Raster Image Files
- Export Drawings to Other File Formats
- Use Drawings from Different Versions and Applications
- Extract Data from Drawings and Spreadsheets
- Access External Databases
- Overview of Using External Databases
- Access a Database from Within Drawings
- Link Database Records to Graphical Objects
- Use Labels to Display Database Information in the Drawing
- Use Queries to Filter Database Information
- Share Link and Label Templates and Queries with Other Users
- Work with Links in Files from Earlier Releases
- Manage Files with Autodesk Vault
- Collaborate with Others
- Protect and Sign Drawings
- Use the Internet for Collaboration
- Get Started with Internet Access
- Add Hyperlinks to a Drawing
- Work with Drawing Files over the Internet
- Review and Markup Files with Design Review
- Use the Publish to Web Wizard to Create Web Pages
- Use Autodesk Seek to Add and Share Drawings
- Use Markups for Design Review
- Render Drawings
- Draw 2D Isometric Views
- Add Lighting to Your Model
- Materials and Textures
- Render 3D Objects for Realism
- Glossary
- Index
Access a Database from Within Drawings
When you have configured a data source, you can view and edit its records
from within a drawing file.
Configure a Database for Use with Drawing Files
The configuration process involves creating a new data source that points to
a collection of data and provides information about the drivers necessary to
access it.
Before you can access an external database from within the program, you must
configure it using the Microsoft ODBC (Open Database Connectivity) and
OLE DB programs. Using ODBC and OLE DB, the program can utilize data
from other applications, regardless of the format that it's stored in or the
database platform on which it is created.
A data source may be either an individual database table or a collection of
them stored in an environment, catalog, or schema. Environments, catalogs, and
schemas are hierarchical database elements used by most database management
systems that help you organize your data. They are in many ways analogous
to a Windows-based directory structure: you can think of the environment as
a folder that holds additional subdirectories of catalogs. Catalogs in turn
contain additional subdirectories of schemas. Each schema is a collection of
database tables.
The configuration process varies slightly for different database systems. For
example, server-based databases such as Oracle and Microsoft SQL Server
require that you enter a valid user name and password and specify the network
location where the database is located. File-based systems such as Microsoft
Access and dBASE III do not require this information. Because of these
variations, it is not possible to provide a generic configuration procedure that
works for all databases. Individual procedures for configuring all the databases
that the program supports are provided in the Configure External Databases.
You should also refer to the documentation for your particular database system
and the Microsoft Help files for ODBC and OLE DB for additional information.
The connectivity feature supports the following external applications:
■ Microsoft Access
■ dBASE
■ Microsoft Excel
■ Oracle
Access a Database from Within Drawings | 2005