User-1236212839 posted
I am trying to create a imked server from SQL to a MYSql database on a remote server.
I have created a an ODBC connection called MYSQL using MySql ODBC 5.1 Driver to the remote host "testhost.com" using port 3306 for user "harry" with appropriate password to database testDB.
The ODBC connection works connects successfully.
The remote host has added my IP address 97.999.99.1 (this is just for this message it is not my real IP) to it's ist of valid IPs..
I create a linked server "TESTMYSQL" with Provider Microsoft OLE DB Provider for ODBC drivers, Product Name: MySql and data source "MYSQL"
The linked server gets the following error:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL".
OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "[MySQL][ODBC 5.1 Driver]Access denied for user 'harry'@'97.999.99.1' to database ' testDB". (Microsoft SQL Server, Error:
7303)
I have searched other responses for error 7303 but have not found one related to access denied.
Can anyone help?
Thanks