Maple Professional
Maple Academic
Maple Student Edition
Maple Personal Edition
Maple Player
Maple Player for iPad
MapleSim Professional
MapleSim Academic
Maple T.A. - Testing & Assessment
Maple T.A. MAA Placement Test Suite
Möbius - Online Courseware
Machine Design / Industrial Automation
Aerospace
Vehicle Engineering
Robotics
Power Industries
System Simulation and Analysis
Model development for HIL
Plant Modeling for Control Design
Robotics/Motion Control/Mechatronics
Other Application Areas
Mathematics Education
Engineering Education
High Schools & Two-Year Colleges
Testing & Assessment
Students
Financial Modeling
Operations Research
High Performance Computing
Physics
Live Webinars
Recorded Webinars
Upcoming Events
MaplePrimes
Maplesoft Blog
Maplesoft Membership
Maple Ambassador Program
MapleCloud
Technical Whitepapers
E-Mail Newsletters
Maple Books
Math Matters
Application Center
MapleSim Model Gallery
User Case Studies
Exploring Engineering Fundamentals
Teaching Concepts with Maple
Maplesoft Welcome Center
Teacher Resource Center
Student Help Center
Database[ConnectionBuilder] - launch Connection Builder Assistant
Calling Sequence
ConnectionBuilder( opts )
Database( opts )
Parameters
opts
-
(optional) equation of the form filename=file
Description
The ConnectionBuilder command opens a Assistant to help you create a database connection. You can enter driver and connection parameters in the interface. The parameters correspond to the arguments you can specify for the LoadDriver and OpenConnection commands. The Assistant opens a connection to the specified database.
You can also use the Database package name as a top-level command to launch the Connection Builder Assistant.
If a connection is successfully established by the Assistant, it returns an expression sequence of length 2. The first element is the driver module and the second is the connection module.
To facilitate specifying the files required for the connection, the Assistant allows you to search the file system.
The Connection Builder Assistant can also load and save connection settings to files. These files are compatible with those used by the Save and LoadConnection commands.
It is recommended that you save connection settings. This allows you to easily re-establish connections.
Each connection stored in a file is associated with an identifier. This identifier allows multiple connections to be stored in a single file. To specify the identifier for connection settings, use the Connection combination box.
The ConnectionBuilder command accepts the optional filename=file equation, which allows you to specify the connection file (as a string) to use when opening the Assistant. If not specified, the Assistant opens $HOME/maple/toolbox/Database/data/default.con, where $HOME is the value returned by kernelopts( homedir ). If this file does not exist, no file is loaded.
If a file is successfully loaded, the connection with the identifier default is displayed by default. If no connection has the identifier default, the Assistant displays the connection properties for the connection with the alphabetically first identifier.
For more detailed information, see the Help menu in the Connection Builder Assistant.
Examples
The Connection Builder Assistant can be opened either by using the top-level Database command, as shown below, or by calling Database:-ConnectionBuilder.
Show the results.
Perform a more complex SELECT and convert the output to a Maple table.
Perform another SELECT and convert the output to a Maple Array.
See Also
Database, Database[Connection][ExecuteQuery], Database[Connection][Save], Database[Driver], Database[Driver][OpenConnection], Database[LoadConnection], Database[LoadDriver], Database[usage]
Download Help Document