I have a requirement for an external mySQL connection from our Windows SBS server. I have installed the appropriate ODBC drivers (both 32bit and 64bit) and setup the DSN's. With the 32bit drivers I can connect, read data and run queries no problems at all but the Winautomation software we are using doesn't support 32bit ODBC drivers. So I installed the 64bit drivers and can get a successful connection but cannot read any of the tables or run a query causing the software to laugh at me (Figuratively). The windows server is 64bit, the ISPconfig 3 server is 64bit (Debian 8.8), ODBC drivers are 64bit and MariaDB is 64bit. So I am confused why I can run a query with the 32bit ODBC drivers successfully but not the 64bit drivers. What am I missing? Any help greatly appreciated.
