{"id":4733,"date":"2013-03-06T08:21:33","date_gmt":"2013-03-06T07:21:33","guid":{"rendered":"https:\/\/ingmarverheij.com\/?p=4733"},"modified":"2013-04-25T08:36:36","modified_gmt":"2013-04-25T06:36:36","slug":"res-software-on-mysql","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/res-software-on-mysql\/","title":{"rendered":"RES software on MySQL"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"\" style=\"float: right; margin: 0px 0px 0px 5px; display: inline\" alt=\"MySQL\" align=\"right\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/MySQL-logo.png\" width=\"110\" height=\"57\" \/>If you want to use <a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\">MySQL<\/a> as a data source for your RES software you might encounter some difficulties connecting to the database (Data source name not found and no default driver specified).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\" style=\"float: right; margin: 0px 0px 0px 5px; display: inline\" alt=\"RES software\" align=\"right\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-software.jpg\" width=\"100\" height=\"49\" \/>RES software supports \u201dMySQL 5.0 or higher x86\/x64\u201d as a database platform, in order to connect to the database environment you need to meet the following database requirements:<\/p>\n<ul>\n<li>MySQL DBA credentials <\/li>\n<li>MYSQL ODBC Driver on the database server and on all Agents <\/li>\n<\/ul>\n<p>The database requirements clearly state you need to install the MySQL ODBC Driver, but which version or architecture you need is not mentioned. Here\u2019s a quick overview of the required drivers.<\/p>\n<p><!--more--><\/p>\n<h1>Error message<\/h1>\n<p>If you don\u2019t install the proper ODBC driver you will encounter an error message similar to the following:<\/p>\n<p><em>Failed to connect to database: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified<\/em><\/p>\n<p><em><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-Automation-Manager-Console.png\"><img loading=\"lazy\" decoding=\"async\" title=\"RES Automation Manager Console\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Data source name not found and no default driver specified\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-Automation-Manager-Console_thumb.png\" width=\"250\" height=\"49\" \/><\/a><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-Workspace-Manager-Console.png\"><img loading=\"lazy\" decoding=\"async\" title=\"RES Workspace Manager Console\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Data source name not found and no default driver specified\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-Workspace-Manager-Console_thumb.png\" width=\"182\" height=\"49\" \/><\/a><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-Workspace-Manager-Relay-Server.png\"><img loading=\"lazy\" decoding=\"async\" title=\"RES Workspace Manager Relay Server\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Data source name not found and no default driver specified\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/RES-Workspace-Manager-Relay-Server_thumb.png\" width=\"127\" height=\"49\" \/><\/a><\/em><\/p>\n<p>&#160;<\/p>\n<p>&#160;<\/p>\n<h1>Troubleshooting<\/h1>\n<p>With <a href=\"https:\/\/technet.microsoft.com\/en-us\/sysinternals\/bb896645.aspx\" target=\"_blank\">Sysinternals Process Monitor<\/a> it is fairly easy to determine why the product is unable to find the proper ODBC driver:<\/p>\n<p><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/Sysinternals-Process-Monitor.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Sysinternals Process Monitor\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBCINST.INI\\MySQL ODBC 5.1 Driver\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/Sysinternals-Process-Monitor_thumb.png\" width=\"604\" height=\"87\" \/><\/a><\/p>\n<p><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/HKEY_LOCAL_MACHINE-SOFTWARE-ODBC-ODBCINST.INI-MySQL-ODBC-5.1-Driver.png\"><img loading=\"lazy\" decoding=\"async\" title=\"\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: right; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"HKEY_LOCAL_MACHINE\\SOFTWARE\\ODBC\\ODBCINST.INI\\MySQL ODBC 5.1 Driver\" align=\"right\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/03\/HKEY_LOCAL_MACHINE-SOFTWARE-ODBC-ODBCINST.INI-MySQL-ODBC-5.1-Driver_thumb.png\" width=\"135\" height=\"79\" \/><\/a>The software is looking for two versions of the ODBC driver in the \u201cODBCINST.INI\u201d registry key:<\/p>\n<ul>\n<li>5.1 \u2013 HKLM\\SOFTWARE\\ODBC\\ODBCINST.INI\\MySQL ODBC 5.1 Driver <\/li>\n<li>3.51 \u2013 HKLM\\SOFTWARE\\ODBC\\ODBCINST.INI\\MySQL ODBC 3.51 Driver <\/li>\n<\/ul>\n<p>In this example I\u2019ve tested with the 64-bit version of the <a href=\"https:\/\/resguru.com\/technote-library\/rg046-all-about-the-wm-relay-server-2\/\" target=\"_blank\">relay server<\/a> of RES Workspace Manager. If you run an 32-bit application the driver is located in the HKLM\\SOFTWARE\\Wow6432Node\\ODBC\\ODBCINST.INI registry key.<\/p>\n<p>&#160;<\/p>\n<p>&#160;<\/p>\n<h1>Tested drivers<\/h1>\n<p>Depending on the software component you\u2019re running you need the x86 or the x64 ODBC driver. Some products work with the latest available version (5.2.4 at the moment of writing&#160; while other only work with the 5.1 version. Below you will find a table with the tested versions.<\/p>\n<p><strong>Update 25-4-2013<\/strong>: <a href=\"https:\/\/nl.linkedin.com\/in\/bendalmeijer\/\" target=\"_blank\">Ben Dalmeijer<\/a> informed me that only the ANSI version of the 5.2.4 ODBC driver is supported.<\/p>\n<p>As you can see the <strong>5.1.12 version <\/strong>works for all products.<\/p>\n<table cellspacing=\"0\" cellpadding=\"1\" width=\"600\" border=\"1\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"233\"><strong>Product<\/strong><\/td>\n<td valign=\"top\" width=\"171\"><strong>Component<\/strong><\/td>\n<td valign=\"top\" width=\"194\"><strong>MySQL ODBC driver<\/strong><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"233\">RES Automation Manager 2012 SR3<\/td>\n<td valign=\"top\" width=\"171\">Console<\/td>\n<td valign=\"top\" width=\"194\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411764\" target=\"_blank\">5.2.4 (x86, 32-bit)<\/a> \u2013 ANSI only          <br \/><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411741\" target=\"_blank\">5.1.12 (x86, 32-bit)<\/a>           <\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"233\">\n<p align=\"center\">\u201c<\/p>\n<\/td>\n<td valign=\"top\" width=\"171\">Service<\/td>\n<td valign=\"top\" width=\"194\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411764\" target=\"_blank\">5.2.4 (x86, 32-bit)<\/a> \u2013 ANSI only          <br \/><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411741\" target=\"_blank\">5.1.12 (x86, 32-bit)            <br \/><\/a><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"233\">RES Workspace Manager 2012 SR2<\/td>\n<td valign=\"top\" width=\"171\">Console<\/td>\n<td valign=\"top\" width=\"194\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411764\" target=\"_blank\">5.2.4 (x86, 32-bit)<\/a> \u2013 ANSI only          <br \/><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411741\" target=\"_blank\">5.1.12 (x86, 32-bit)            <br \/><\/a><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"233\">\n<p align=\"center\">\u201c<\/p>\n<\/td>\n<td valign=\"top\" width=\"171\">Service<\/td>\n<td valign=\"top\" width=\"194\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411764\" target=\"_blank\">5.2.4 (x86, 32-bit)<\/a> \u2013 ANSI only          <br \/><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411741\" target=\"_blank\">5.1.12 (x86, 32-bit)<\/a>           <\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"233\">\n<p align=\"center\">\u201c<\/p>\n<\/td>\n<td valign=\"top\" width=\"171\">Relay server (x86)<\/td>\n<td valign=\"top\" width=\"194\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411741\" target=\"_blank\">5.1.12 (x86, 32-bit)<\/a>           <\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"233\">\n<p align=\"center\">\u201c<\/p>\n<\/td>\n<td valign=\"top\" width=\"171\">Relay server (x64)<\/td>\n<td valign=\"top\" width=\"194\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mirror.php?id=411736\" target=\"_blank\">5.1.12 (x64, 64-bit)            <br \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>If you want to use MySQL as a data source for your RES software you might encounter some difficulties connecting to the database (Data source name not found and no default driver specified). RES software supports \u201dMySQL 5.0 or higher x86\/x64\u201d as a database platform, in order to connect to the database environment you need [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[290],"tags":[543,541,540,542,372],"class_list":["post-4733","post","type-post","status-publish","format-standard","hentry","category-workspace-management","tag-automation-maanger","tag-datasource","tag-mysql","tag-odbc","tag-workspace-manager"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/4733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=4733"}],"version-history":[{"count":7,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/4733\/revisions"}],"predecessor-version":[{"id":4852,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/4733\/revisions\/4852"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=4733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=4733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=4733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}