locked
mysql provider not displayed in data source RRS feed

  • Question

  • Have a new installation of windows 2008 server 64bit and sql server 2008 enterprise 64bit.

    Trying to import data from a mysql ODBC system DSN.

    I have installed the MYsql ODBC connector (64bit ).

    When trying to import data the mysql provider is not listed under "data source" .

    I have also tried creating an SSIS package but have the same problem there.

    Any Ideas? I have it working on a sql 2000 server just fine.

    Thanks,

    Dan-
    Tuesday, April 28, 2009 6:22 PM

Answers

  • Got it. I was just having some weird ODBC Connector driver issues. Once I added the DSN with the correct driver to both control panels, my connection was avalible in SSIS. Package is built and works perfect.

    Thanks for your help!

    -dan
    • Marked as answer by Todd McDermid Thursday, April 30, 2009 5:23 PM
    Thursday, April 30, 2009 5:42 AM

All replies

  • BIDS runs in 32-bit mode, so it can only see 32-bit ODBC DSNs.  At runtime, SSIS will attempt to use a 32- or 64-bit driver depending on whether it's being executed in 32- or 64-bit mode.  Do you have a 32-bit ODBC DSN for that connection?  You should just have to make them the same name, and you should be fine.
    Todd McDermid's Blog
    Tuesday, April 28, 2009 6:47 PM
  • I dont have a 32bit DSN created because the OS didnt list the 32bit driver when creating the DSN.

    Tuesday, April 28, 2009 7:01 PM
  • You need to create the DSN using the 32-bit ODBC Control Panel applet.
    Todd McDermid's Blog
    Tuesday, April 28, 2009 7:04 PM
  • I now have a DSN created in both 32 bit and 64 bit ODBC contol panels.

    Still not listed in SQL, I have also tried selecting import / export 32 and import / export 64 from the programs menu and does not show there either.

    Tuesday, April 28, 2009 8:28 PM
  • Sorry, man.  I'm out of ideas then!
    Todd McDermid's Blog
    • Marked as answer by Todd McDermid Thursday, April 30, 2009 5:22 PM
    • Unmarked as answer by Todd McDermid Thursday, April 30, 2009 5:22 PM
    Wednesday, April 29, 2009 5:33 PM
  • Got it. I was just having some weird ODBC Connector driver issues. Once I added the DSN with the correct driver to both control panels, my connection was avalible in SSIS. Package is built and works perfect.

    Thanks for your help!

    -dan
    • Marked as answer by Todd McDermid Thursday, April 30, 2009 5:23 PM
    Thursday, April 30, 2009 5:42 AM