Post reply

Linked server

  • June 7, 2010 at 5:52 am

    #225358

    Hi,

    I am trying to set up a link to an MySQL server and am using the following query:

    exec sp_addlinkedserver

    @server='MSQLREVIEW',

    @srvproduct='MySQL',

    @provider='MSDASQL',

    @datasrc='MSQLREVIEW',

    @provstr='DATABASE=review;DSN=MSQLREVIEW;OPTION=0;PWD=;SERVER=server4;UID=root'

    but after i have run this and try to run a linked query i get the following error:

    ---------------------------

    Microsoft Development Environment

    ---------------------------

    An error occurred while executing the query.

    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MSQLREVIEW".

    ---------------------------

    OK

    ---------------------------

    any ideas what i am doing wrong? thanks in advance for any/all help. 🙂

  • June 7, 2010 at 6:22 am

    #1177044

    I think Jim Dillon has posted the definitive way to create a linked server to MySQL here:

    http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

    he posted some really good instructions, and there's a lot of sharp questions on the follup of the psot to answer any other questions...did you see that post yet?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 7, 2010 at 6:33 am

    #1177048

    Thank you, sorry for being a n00b. its working now i followed those instructions.

    thanks again

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply