Connecting to MySQL causes error Data source. It is compliant with the ODBC 3. I downloaded the last stable ODBC connector, version 2. NET connectors currently. Note that if your application is bit you will need the bit ODBC driver - a bit application on Windows cannot use a bit driver.
Make sure to install iODBC and OpenSSL, if not installed already. It supports ODBC Standard 3. If you use Homebrew they can easily be installed with: brew install libiodbc brew install openssl Bug Fixes. These fixes allow the ODBC connector to be built on OSX. It requires homebrew to supply cmake, unixodbc, openssl and the mariadb -connector-c, and then still some overrides on the CMake command line. To see if this problem regards only R or RODBC I tried to import the data with Excel using excel- odbc , mysql- odbc and maria- odbc (the last two using MSquery).
It requires a DSN to be created and some environment variables like PATH, ORACLE_HOME, TNS_ADMIN, etc. I have found it very har. It was missing the reference libodbcinst. The same script with UAT server name is not working in UAT server. When I checked the drivers tab in ODBC Data.
Hope the above information can be helpful. This is due to a missing or incorrect SQL Native Client driver. The Alteryx server is unable to run a workflow that runs properly on the user’s local machine where the workflow was created.