hmLoadTopic({
hmKeywords:"Configuring,Configuring ODBC Data Source for a List,ODBC,ODBC System Data Source",
hmTitle:"Configuring an ODBC Data Source for a Mailing List",
hmDescription:"To use an ODBC accessible database with a mailing list:",
hmPrevLink:"ml_odbc.html",
hmNextLink:"ml_odbc_creating_a_new_system_data.html",
hmParentLink:"ml_odbc.html",
hmBreadCrumbs:"Setup Menu &gt; <a href=\"ml_mailing_lists.html\">Mailing List Manager<\/a> &gt; Mailing List Editor &gt; <a href=\"ml_odbc.html\">ODBC<\/a>",
hmTitlePath:"Setup Menu > Mailing List Manager > Mailing List Editor > ODBC > Configuring an ODBC Data Source",
hmHeader:"<h1 class=\"p_Heading1\" style=\"page-break-after: avoid;\"><span class=\"f_Heading1\">Configuring an ODBC Data Source for a Mailing List<\/span><\/h1>\n\r",
hmBody:"<p class=\"p_BodyText\"><span class=\"f_BodyText\">To use an ODBC accessible database with a mailing list:<\/span><\/p>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 0.5000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">1.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">On the <a href=\"ml_odbc.html\" class=\"topiclink\">ODBC screen<\/a> of the Mailing List editor, click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Connect to new ODBC source<\/span><span class=\"f_ControlIndent\"> to open the ODBC Selector Wizard.<\/span><\/td><\/tr><\/table><\/div>\n\r<p style=\"margin: 0.3125rem 0.5625rem 1.0000rem 1.5000rem;\"><img style=\"margin:0;width:24.1875rem;height:19.3125rem;border:none\" src=\".\/images\/account-database_odbc-selector-wizard-01.png\"\/><\/p>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 1.0000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">2.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">Select the <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">data source<\/span><span class=\"f_ControlIndent\"> that you wish to use for the list. If there is not a compatible data source listed, click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">New DSN<\/span><span class=\"f_ControlIndent\"> and then follow the instructions listed under, <\/span><span class=\"f_DialogSectionHeading\"><a href=\"ml_odbc_creating_a_new_system_data.html\" class=\"topiclink\">Creating a New ODBC Data Source<\/a><\/span><span class=\"f_ControlIndent\">.<\/span><\/td><\/tr><\/table><\/div>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 1.0000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">3.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">If required, enter the data source\'s <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Logon<\/span><span class=\"f_ControlIndent\"> and <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Password<\/span><span class=\"f_ControlIndent\">.<\/span><\/td><\/tr><\/table><\/div>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 1.0000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">4.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">Click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Next<\/span><span class=\"f_ControlIndent\">.<\/span><\/td><\/tr><\/table><\/div>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 0.5000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">5.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">The data source must contain at least one table with fields for email addresses and names. If the data source contains one or more qualifying tables, choose the desired table and click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Next<\/span><span class=\"f_ControlIndent\">. Otherwise, click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Cancel<\/span><span class=\"f_ControlIndent\"> to exit the ODBC Selector Wizard and then use your database application to add a table to the relevant database before continuing.<\/span><\/td><\/tr><\/table><\/div>\n\r<p style=\"margin: 0.3125rem 0.5625rem 1.0000rem 1.5000rem;\"><img style=\"margin:0;width:24.1875rem;height:19.3125rem;border:none\" src=\".\/images\/mailing-list_odbc-wizard-02-select-table.png\"\/><\/p>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 0.5000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">6.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">Use the drop-down list boxes to designate the table fields that will correspond to <\/span><span style=\"font-family: Arial,Helvetica,sans-serif; font-weight: bold; color: #010100;\">email address<\/span><span class=\"f_ControlIndent\">, <\/span><span style=\"font-family: Arial,Helvetica,sans-serif; font-weight: bold; color: #010100;\">first name<\/span><span class=\"f_ControlIndent\">, and <\/span><span style=\"font-family: Arial,Helvetica,sans-serif; font-weight: bold; color: #010100;\">last name<\/span><span class=\"f_ControlIndent\">. Click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Next<\/span><span class=\"f_ControlIndent\">.<\/span><\/td><\/tr><\/table><\/div>\n\r<p style=\"margin: 0.3125rem 0.5625rem 1.0000rem 1.5000rem;\"><img style=\"margin:0;width:24.1875rem;height:19.3125rem;border:none\" src=\".\/images\/mailing-list_odbc-wizard-03-map-table-columns.png\"\/><\/p>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 0.5000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">7.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">The ODBC Selector Wizard will construct an SQL query statement based on your selections in <\/span><span style=\"font-family: Arial,Helvetica,sans-serif; font-weight: bold; color: #010100;\">Step 6<\/span><span class=\"f_ControlIndent\">. MDaemon will use it to retrieve normal list member data from your database. You can edit this statement as desired, and include other query statements in the remaining controls to cause members to receive messages in Digest mode, and to designate members as Read Only or Post Only. A <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Test<\/span><span class=\"f_ControlIndent\"> button is provided beside each control so that you can test your query statements to make sure they retrieve the proper data. When you are finished configuring your query statements, click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Next<\/span><span class=\"f_ControlIndent\">.<\/span><\/td><\/tr><\/table><\/div>\n\r<p style=\"margin: 0.3125rem 0.5625rem 1.0000rem 1.5000rem;\"><img style=\"margin:0;width:24.1875rem;height:19.3125rem;border:none\" src=\".\/images\/mailing-list_odbc-wizard-04-query-statements.png\"\/><\/p>\n\r<div style=\"text-align: left; text-indent: 0; padding: 0 0 0 0; margin: 0 0 1.0000rem 1.5625rem;\"><table style=\"border:none;border-spacing:0;padding:0;line-height: normal;\"><tr style=\"vertical-align:baseline\"><td style=\"border:none;padding:0;width:1.4375rem\"><span class=\"f_ControlIndent\">8.<\/span><\/td><td style=\"border:none;padding:0\"><span class=\"f_ControlIndent\">Click <\/span><span style=\"font-family: \'Microsoft Sans Serif\'; font-weight: bold; color: #010100;\">Finish<\/span><span class=\"f_ControlIndent\">.<\/span><\/td><\/tr><\/table><\/div>\n\r<p class=\"p_SeeAlso\" style=\"page-break-after: avoid; border-right: none; border-bottom: none; border-left: none;\"><span class=\"f_SeeAlso\">See:<\/span><\/p>\n\r<p class=\"p_SeeAlsoLinks\" style=\"page-break-after: avoid;\"><span class=\"f_SeeAlsoLinks\"><a href=\"ml_odbc.html\" class=\"topiclink\">Mailing List Editor » ODBC<\/a><\/span><\/p>\n\r<p class=\"p_SeeAlsoLinks\" style=\"page-break-after: avoid;\"><span class=\"f_SeeAlsoLinks\"><a href=\"ml_odbc_creating_a_new_system_data.html\" class=\"topiclink\">Creating a New ODBC Data Source<\/a><\/span><\/p>\n\r<p class=\"p_ControlIndent\"><span class=\"f_ControlIndent\">&nbsp;<\/span><\/p>\n\r"
})
