Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Link SQL Server (x64) to MySQL with ODBC Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 4:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:55 AM
Points: 2, Visits: 2
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
Post #1455401
Posted Wednesday, May 22, 2013 4:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:55 AM
Points: 2, Visits: 2
I fixed it
Post #1455421
Posted Tuesday, September 10, 2013 12:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 12:19 AM
Points: 1, Visits: 0
hay i have the same issue what had you done with this issue? plz do let me know
Post #1493001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse