Not able to create MS SQL Server Linked server

cse_king2

• August 30, 2016 05:09

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

  • August 30, 2016 17:26

  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.

  0
• 

  cse_king2

  • August 31, 2016 02:57

  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.

  0
• 

  cse_king2

  • September 01, 2016 06:38

  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 ->

  0
• 

  cPanelMichael

  • September 01, 2016 14:32

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

  0

Please sign in to leave a comment.