Skip to main content

Posts

Featured

Creating a Link Server to MYSQL from MSSQL

There might be situations where you need to apply CRUD  operations (
Create,Read,Update,Delete) on data residing in a MYSQL server database from SQL server. In order to do this you will need to create a link service from SQL server to MYSQL. The Steps are outlined below:

Steps:
1. Install the MYSQL ODBC driver on the server with the MSSQL server installation.
2. Enter details for the MYSQL ODBC settings.
3. Create a link service to MYSQL using SSMS ( SQL Server Management Studio)
4. You will need an user account on the mysql server which can perform CRUD operations
 along with enable remote connections to the MYSQL installation. (See Troubleshooting steps below)
4. Test the connection.


Install MYSQL ODBC Driver Download  (http://dev.mysql.com/downloads/connector/odbc/) and install the latest MYSQL ODBC driver from the MYSQL server site. Select the version which corresponds to your installation of MSSQL usually the 64bit version. Note This needs to be done on the server with the MSSQL installed…

Latest posts

How to pass a data table into a stored procedure as a Table Value Parameter (TVP) in SQL server 2008 and above.

Growing Log file issues - How to shrink a SQL server Log and data file.

Troubleshooting Database Mail: General steps

Method of grouping strings with XML

Alternative method of querying the calendar using the CTE method

How to Query SQL server for T-SQL Calendar using GetFullMonth using Pivot

Build a T-SQL Calendar using SQL Function GetFullMonth on MS SQL Server

Integrating MIGS eGate Payment gateway using C# for Oz businesses (Server-Hosted Payment method)