To find out which version of SQL Server you have, connect to your SQL Server instance, and then run this SQL statement: select SERVERPROPERTY ( 'edition' ) The version of ODBC Administrator that you need to run depends on whether you have a 32-bit or a 64-bit version of SQL Server. There are two versions of ODBC Administrator on this platform. (On older versions of Windows, the Control Panel applet that launches ODBC Administrator is labelled Data Sources.) To run ODBC Administrator on 32-bit Windows, open Administrative Tools in Control Panel, and then open Data Sources ( ODBC). How you run ODBC Administrator depends on whether your version of Windows is 32-bit or 64-bit: You configure ODBC data sources in ODBC Administrator, which is included with Windows.
An ODBC data source stores the connection details for the target database.
Install and license the ODBC-JDBC Gateway on the Windows machine where SQL Server / Java / the MySQL JDBC driver are installed.įor installation instructions, see the ODBC-JDBC Gateway documentation.īefore you can use the ODBC-JDBC Gateway to connect your ODBC application to MySQL, you need to configure a System ODBC data source.You need version 2.4.9 or later, which is not currently available from the Easysoft web site. Note If you intend using SSIS, please contact the Easysoft support team () for pre-release version of the ODBC-JDBC Gateway.
Download the Windows ODBC-JDBC Gateway.Installing and Licensing the ODBC-JDBC Gateway To the JDBC driver the ODBC-JDBC Gateway is a Java application. To the application, the ODBC-JDBC Gateway is an ODBC driver. The ODBC-JDBC Gateway connects an application that uses ODBC to a database that uses JDBC. SQL Server can use an ODBC driver, a different piece of database middleware, to access external data. SQL Server is not written in Java however and does not provide a way for a linked server to access a database by using JDBC. MySQL's JDBC driver allows Java applications to access data stored in MySQL. A JDBC driver allows a Java application to access external data. One such connector is the MySQL Connector/J, which is a piece of database middleware known as a JDBC driver. MySQL provide several connectors to enable client applications to access MySQL databases. Integrate MySQL with SQL Server by using SQL Server Integration Services (SSIS).Use a linked server to work with MySQL data, just as if you were working with data stored in a SQL Server table.Use the ODBC-JDBC Gateway to connect Microsoft SQL Server to MySQL and: The following article refers to an earlier less direct solution. Use the MySQL ODBC driver to connect MySQL to SQL Server.