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.
Member
30 Points
135 Posts
Link Server error 7303
Jun 19, 2012 04:51 PM|harrytu@clearwire.net|LINK
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
Member
30 Points
135 Posts
Re: Link Server error 7303
Jun 22, 2012 01:16 AM|harrytu@clearwire.net|LINK
We solved the issue.
We needed to creat a new login for MySQL that was not a login on the host system
None
0 Points
1 Post
Re: Link Server error 7303
Sep 10, 2015 11:14 AM|HamzaOuahabi|LINK
Dear
Can you explain me how you solve this? I am encountering the same issue?
Regards