Lets talk remote mySQL connections...

Discussion in 'Server Operation' started by FFH, Sep 18, 2017.

  1. FFH

    FFH Member

    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.

Share This Page