May 22, 2013 at 4:05 am
Hi Guys,
Was wondering if you can please help, I am connecting our x64 2008r2 SQL Server to MySQL using ODBC.
I have the ODBC set up and connection successful, but when i configure the "Linked Servers" i get this :-
TITLE: Microsoft SQL Server Management Studio
------------------------------
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------
ADDITIONAL INFORMATION:
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 "WORDPRESS".
OLE DB provider "MSDASQL" for linked server "WORDPRESS" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)
Thanks for your Help 🙂
May 22, 2013 at 4:55 am
I fixed it
September 10, 2013 at 12:20 am
hay i have the same issue what had you done with this issue? plz do let me know
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply