Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Unanswered: SQL 2005 to MYSQL 4.1

    I have a SQL Server 2005 and am trying to create an OPENDATASOURCE with MYSQL.
    I downloaded the MYSQL 3.51 driver and installed it on the SQL Server, but am unable to connect. I keep getting
    the OLE DB provider "MySQLProv" has not been registered.

    Any help would be greatly appreciated.
    Thanks
    Susan

  2. #2
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    If you're connecting to a remote (on another computer than your own) instance of SQL Server, check if the driver is installed on that machine.

Posting Permissions

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