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' )
![mysql management studio tutorial mysql management studio tutorial](https://docs.microsoft.com/en-us/sql/ssms/tutorials/media/scripting-ssms/backupdb.png)
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.
MYSQL MANAGEMENT STUDIO TUTORIAL INSTALL
MYSQL MANAGEMENT STUDIO TUTORIAL DOWNLOAD
![mysql management studio tutorial mysql management studio tutorial](https://www.mssqltips.com/tipimages2/2542_image001.png)
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.
![mysql management studio tutorial mysql management studio tutorial](https://ozanecare.com/wp-content/uploads/2020/03/1.MysqlVS.png)
The following article refers to an earlier less direct solution. Use the MySQL ODBC driver to connect MySQL to SQL Server.