| <?xml version="1.0" encoding="UTF-8"?> |
| <!DOCTYPE html |
| PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html lang="en" xml:lang="en"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| <meta name="copyright" content="(C) Copyright 2005"/> |
| <meta name="DC.rights.owner" content="(C) Copyright 2005"/> |
| <meta name="DC.Type" content="task"/> |
| <meta name="DC.Title" content="Creating a Database Connection Profile"/> |
| <meta name="abstract" content="A connection profile contains the connection property information needed to connect to a database runtime instance."/> |
| <meta name="description" content="A connection profile contains the connection property information needed to connect to a database runtime instance."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700329696.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700372057.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700331243.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700332633.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700334258.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700343352.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700346509.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700347915.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700349493.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700350915.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700354259.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700357056.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700358681.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700331243.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700328274.html"/> |
| <meta name="DC.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\dtp\dtp\en\source\t_creating_a_database_connection_profile.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="task_71D2FC87350D4638B2A02018B1D4BD51"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:25:44]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700344899"/> |
| <meta name="DC.Language" content="en"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/commonltr.css"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/doc.css"/> |
| <title xmlns:xs="http://www.w3.org/2001/XMLSchema">Creating a Database Connection Profile</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700344899"><a name="asc1229700344899"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Creating a Database Connection Profile</h1> |
| |
| |
| |
| <div><p>A connection profile contains the connection property information |
| needed to connect to a database runtime instance. |
| </p> |
| |
| <div class="p" id="asc1229700344899__prereq_FFCD55A8E3BD4043BFB1ACFB82FF89F4"><a name="asc1229700344899__prereq_FFCD55A8E3BD4043BFB1ACFB82FF89F4"><!-- --></a><strong class="prereq-title">Prerequisites </strong> |
| <p>Switch to the Database Development perspective. Make sure that the database server is running before attempting to test the connection or to connect to the database server.</p> |
| |
| </div> |
| |
| <a name="asc1229700344899__steps_1F2CA60398B84C4E84F6D2E02DD0DE3F"><!-- --></a><ol id="asc1229700344899__steps_1F2CA60398B84C4E84F6D2E02DD0DE3F"> |
| <li class="stepexpand" id="asc1229700344899__step_BE1ECF2EE7BD446BB989BA52AE2CD657"><a name="asc1229700344899__step_BE1ECF2EE7BD446BB989BA52AE2CD657"><!-- --></a> |
| <span>In Data Source Explorer, right-click <span class="uicontrol">Databases</span> and select <span class="uicontrol">New</span>.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_B9B30093BA4C4AD897218BC7DB0B2F3F"><a name="asc1229700344899__step_B9B30093BA4C4AD897218BC7DB0B2F3F"><!-- --></a> |
| <span>(Optional) Filter the <span class="uicontrol">Connection Profile Types</span> list.</span> |
| |
| <p>For example, to list all databases that begin with the letter D, enter a <kbd class="userinput">d</kbd> in the text box. You can also enter a text string such as <kbd class="userinput">JDBC</kbd> or <kbd class="userinput">embedded</kbd> to filter the list.</p> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_8D8EE1F05FFF4F9CB2D1D372C309E853"><a name="asc1229700344899__step_8D8EE1F05FFF4F9CB2D1D372C309E853"><!-- --></a> |
| <span>Select a connection profile type.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_BB9D6433DE6348359BEC52944B0951F5"><a name="asc1229700344899__step_BB9D6433DE6348359BEC52944B0951F5"><!-- --></a> |
| <span>(Optional) Change the <span class="uicontrol">Name</span> from the system-provided default, and/or enter a <span class="uicontrol">Description</span>, and click |
| <span class="uicontrol">Next</span>.</span> |
| |
| <p>You must change the name if a connection profile already exists with the same name. </p> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_824BE749FDDD4C4BBB85312250176D77"><a name="asc1229700344899__step_824BE749FDDD4C4BBB85312250176D77"><!-- --></a> |
| <span>Indicate a driver definition.</span> |
| <a name="asc1229700344899__choices_E3E0D98ED58E40A7AB8AE2038B535602"><!-- --></a><ul id="asc1229700344899__choices_E3E0D98ED58E40A7AB8AE2038B535602"> |
| <li id="asc1229700344899__choice_BE215C10D45A4B718604B38046EB784B"><a name="asc1229700344899__choice_BE215C10D45A4B718604B38046EB784B"><!-- --></a>Select one from the list. If a driver definition does not exist for the database type you selected, you can create one.</li> |
| |
| <li id="asc1229700344899__choice_475B510DC6B6445AA4931C0748C40356"><a name="asc1229700344899__choice_475B510DC6B6445AA4931C0748C40356"><!-- --></a>Select <a name="asc1229700344899__image_E0FE08D2E7224CDB9AD903A6D6075E43"><!-- --></a><img id="asc1229700344899__image_E0FE08D2E7224CDB9AD903A6D6075E43" src="../image/asc1229700339040.image" alt="New Driver Definition button"/> |
| <span class="uicontrol">New Driver Definition</span> to create a new driver definition.</li> |
| |
| <li id="asc1229700344899__choice_FDDF9BC69631488299E4EF9007B10A65"><a name="asc1229700344899__choice_FDDF9BC69631488299E4EF9007B10A65"><!-- --></a>Select <a name="asc1229700344899__image_C199AA5378B14BA9B352F04717A83CA6"><!-- --></a><img id="asc1229700344899__image_C199AA5378B14BA9B352F04717A83CA6" src="../image/asc1229700340602.image" alt="Edit Driver Definition button"/> |
| <span class="uicontrol"> Edit Driver Definition</span> to edit an existing driver definition.</li> |
| |
| </ul> |
| |
| |
| <p>The Properties tabs populate with default template information for the selected driver. </p> |
| |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_653C7F72A3D646B09768FDD9658067F8"><a name="asc1229700344899__step_653C7F72A3D646B09768FDD9658067F8"><!-- --></a> |
| <span>(Optional) Add or modify the Properties information in the <span class="uicontrol">Connection</span> or <span class="uicontrol">Other Properties</span> tabs.</span> |
| <a name="asc1229700344899__substeps_F920DED692F44D5697A808C47242F1B2"><!-- --></a><ol type="a" id="asc1229700344899__substeps_F920DED692F44D5697A808C47242F1B2"> |
| <li id="asc1229700344899__substep_CD8E7E4F45984226977F1B5396EE7D21"><a name="asc1229700344899__substep_CD8E7E4F45984226977F1B5396EE7D21"><!-- --></a> |
| <span>Click <span class="uicontrol">Save Password</span> to save the password for the database server login.</span> |
| </li> |
| |
| <li id="asc1229700344899__substep_CD56D35FC37A4F5A98637CA58B2BE8BF"><a name="asc1229700344899__substep_CD56D35FC37A4F5A98637CA58B2BE8BF"><!-- --></a> |
| <span>Select <span class="uicontrol">Connect When the Wizard Completes</span> to connect to the database server once you finish defining this connection profile. </span> |
| </li> |
| |
| <li id="asc1229700344899__substep_1D910871244043CE9BA37C701B39AB8C"><a name="asc1229700344899__substep_1D910871244043CE9BA37C701B39AB8C"><!-- --></a> |
| <span>Select <span class="uicontrol">Connect Every Time the Workbench Is Started</span> to automatically connect to the database server using this connection profile when you launch Eclipse.</span> |
| </li> |
| |
| <li id="asc1229700344899__substep_CA4CD9DC32CE409FB98C0C7D3128CDBC"><a name="asc1229700344899__substep_CA4CD9DC32CE409FB98C0C7D3128CDBC"><!-- --></a> |
| <span>Click |
| <span class="uicontrol">Test Connection</span> to ping the |
| server and to verify that the connection profile is working.</span> |
| </li> |
| |
| </ol> |
| |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_1B040F2D89EF419B8D8FE2538BB0390D"><a name="asc1229700344899__step_1B040F2D89EF419B8D8FE2538BB0390D"><!-- --></a> |
| <span>(Optional) Click <span class="uicontrol">Next</span> to view Summary information.</span> |
| </li> |
| |
| <li class="stepexpand" id="asc1229700344899__step_FED69E6476034472A79717BB13A37144"><a name="asc1229700344899__step_FED69E6476034472A79717BB13A37144"><!-- --></a> |
| <span>Click <span class="uicontrol">Finish</span> to create the connection profile.</span> |
| </li> |
| |
| </ol> |
| |
| </div> |
| |
| <div><div class="relconcepts"><strong>Related concepts</strong><br/> |
| <div><a href="../../doc/html/asc1229700328274.html" title="The Data Source Explorer contains connection profile instances.">Data Source Explorer View</a></div> |
| </div> |
| <div class="reltasks"><strong>Related tasks</strong><br/> |
| <div><a href="../../doc/html/asc1229700329696.html" title="Set preferences for how nodes get displayed for Open Data Access, connection profiles and driver definitions.">Setting Connectivity Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700372057.html" title="Create a driver to connect to a specific database.">Creating a Driver Definition</a></div> |
| <div><a href="../../doc/html/asc1229700343352.html" title="A connection profile contains the connection property information needed to connect to a data source in your enterprise.">Creating a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700346509.html" title="If you modify the properties of a connection profile, you can refresh the connection profile to update its contents.">Refreshing a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700347915.html" title="You can rename a connection profile.">Renaming a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700349493.html" title="You can delete a connection profile.">Deleting a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700350915.html" title="Ping the data source/enterprise resource to test a connection profile.">Testing a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700354259.html" title="Import one or more connection profiles into the current workspace.">Importing a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700357056.html" title="Export one or more connection profiles to a text file.">Exporting a Connection Profile</a></div> |
| <div><a href="../../doc/html/asc1229700358681.html" title="Edit data source/enterprise resource configuration parameters for a specific connection profile.">Editing Connection Profile Properties</a></div> |
| </div> |
| <div class="relref"><strong>Related reference</strong><br/> |
| <div><a href="../../doc/html/asc1229700331243.html" title="Determines how connection profile information displays: grouped by schema or listed alphabetically with database object owner in parentheses next to the object name.">Database Connection Profile Preferences</a></div> |
| <div><a href="../../doc/html/asc1229700332633.html" title="Add, edit, or delete driver definitions for a specific database server. Connection profiles use driver definitions to establish database connections.">Driver Definitions</a></div> |
| <div><a href="../../doc/html/asc1229700334258.html" title="Set label decorations preferences to set the display format of objects appearing in the Database Development perspective.">Label Decorations Preferences</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |
