Jim Singelis
asked on
Trouble creating Linked mySQL Server
I am having trouble creating a linked Server.
I set a system ODBC to a mySQL server in the ODBC Data Source Administrator. It test ok.
But I can't figure out to make it a linked server in the Management Studio. I have:
PROVIDER: MediaCatalogDB OLE DB Provider.
DATASOURCE: myODBCname
What's PRODUCT NAME?
ERROR:
Cannot initialize the data source object of OLE DB provider "MediaCatalogDB" for linked server "myTest".
I set a system ODBC to a mySQL server in the ODBC Data Source Administrator. It test ok.
But I can't figure out to make it a linked server in the Management Studio. I have:
PROVIDER: MediaCatalogDB OLE DB Provider.
DATASOURCE: myODBCname
What's PRODUCT NAME?
ERROR:
Cannot initialize the data source object of OLE DB provider "MediaCatalogDB" for linked server "myTest".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Does your SELECT statements across tables works out.
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/8853b1d7-bf6b-4628-a3c5-07974225d125/
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/8853b1d7-bf6b-4628-a3c5-07974225d125/
ASKER
I just figured out what's wrong (dummy me).
I created the ODBC on my local machine, but I want the linked server on the machine in our office. I'm working from home. Is there anyway to do it without an odbc?
Jim
I created the ODBC on my local machine, but I want the linked server on the machine in our office. I'm working from home. Is there anyway to do it without an odbc?
Jim
Yes.. you can..
If you are using SQL Server 2000 SP3 or above, then try this one and this works fine
http://msdn.microsoft.com/en-us/library/aa276850(SQL.80).aspx
If you are using SQL Server 2000 SP3 or above, then try this one and this works fine
http://msdn.microsoft.com/en-us/library/aa276850(SQL.80).aspx
ASKER
What I need to do is port tables to a mySQL database. OpenRowSet seems to be only for SELECT... But I did some looking around and found OpenDataSource which might do the trick.
Thanks form your help
Thanks form your help
ASKER
The OLEDB provider "MSDASQL" has not been registered.