Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: Linked server to a MySQL database

    Hi,

    I've installed MyODBC-3.51.06 and succsesfully created 2 odbc sources to the MySQL database with the ODBC data source administrator. One is a User DSN, the other a system DSN (Q1: what's the difference?) The test in that applet perfoms positively.

    Running a dataimport of the tables using the import data option in enterprise manager does work as well.

    Now for the part that gives me trouble. I would like to create a linked server using enterprise manager of SQL server 2000 (SQL 8.00.194) but I'm totaly stuck there. So Q2: how to get this set up?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    First of all, apply SP3 to your SQL service. Second, select MS OLE DB Provider for ODBC Drivers. In Product name put MSDASQL, in Data Source put the name of your System DSN (the difference is that User DSN will be available only for the user that created it), in Provider String put the connection string, etc.

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Is applying SP3 a prerequisite for this to work? (Since at the moment this is not an option)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •