Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    3

    Unanswered: Error with Cherry City MySQL OLEDB Driver

    Hi,
    I'm trting to crate a linked server in Microsoft SQL Studio Management Studio to my MYSQL server with the driver from Cherry City Software.
    I followed the guide 100%, but I get and strange error, anyone who can help me out here ?
    Guide: http://cherrycitysoftware.com/CCS/Pr...kedServer.aspx

    Error:
    TITLE: Microsoft SQL Server Management Studio
    ------------------------------
    "The linked server has been created but failed a connection test. Do you want to keep the linked server?"
    ------------------------------
    ADDITIONAL INFORMATION:
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    ------------------------------
    OLE DB provider 'OleMySql.MySqlSource' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode. (Microsoft SQL Server, Error: 7308)

    For help, click: http://go.microsoft.com/fwlink?ProdN...8&LinkId=20476
    ------------------------------
    BUTTONS:
    &Yes
    &No
    ------------------------------

    Jesper

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Try setting RPC and RPC OUT settings on the linked server to FALSE.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2010
    Posts
    1
    This issue was fixed in a new release, please go ahead to download the latest version

Posting Permissions

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