Not able to create MS SQL Server Linked server

[cse_king2]

I am trying to create MS SQL Server Linked server to connect web MYSQL . I have given access to my static IP address in "Remote MYSQL".

I have choosen following option in MS SQL Server Linked server

Provider: Microsoft OLE DB Provider for ODBC Drivers

Product name: MySQL

Data Source: MySQL ( I don't know what I should give here hence I have given MysQL)

Provider String: DRIVER={MySQL ODBC 5.5 Driver};SERVER=Shared IP address Mention in CPanel;PORT=3306;DATABASE=database name; USER=user;PASSWORD=password;

When I try to connect using above obtion I am getting error as "Not able to connect"

When executed below command in my CMD
telnet "Shared IP address Mention in CPanel" 3306

I am getting following message:
[Removed]


Kindly help me how to solve this issue?

 

[cPanelMichael]

Hello,

You will likely need to install the following PDO Driver in order for your PHP scripts to connect to the remote database server:

PHP: ODBC and DB2 (PDO) - Manual

The following thread should help:

How to add pdo_odbc (unixODBC flavor) to raw opts? Static vs Shared build issue

Thank you.

 

[cse_king2]

Hi @Michael,
I am not trying to call remote mysql from my php script. I am trying to connect cpanal mysql to desktop installed ms sql serverver through linked server option.

 

[cse_king2]

I have reolved this issue.
I have followed following steps
1.Given client IP address in Remote MySQL
2.Installed "MySQL Connector/ODBC 5.1" in Client Meachine by following this tutorial -> ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
3)Created Temp table in Client Meachine & given full permission by following this tutorial -> https://support.microsoft.com/en-us/kb/814398
4)I have created linked server by following this tutorial -> ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
5) Along with above step while creating linked server I have given "provider string" values like (SERVER=IP address of CPANEL;PORT=3306; DATABASE=database_name;USER= database_user;PASSWORD= database_password;" along with product name & source name while creating linked server.

 

[cPanelMichael]

I'm happy to see you were able to address the issue. Thank you for updating us with the outcome.