Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009

    Unanswered: How to retrieve sybase data from ms sql?

    I have built a linked server on MS 2005 to Sybase ASE 12.5 server. I tested the connection successfully. I can use OPENQUERY to retrieve data on Sybase from MS SQL 2005.

    But I cannot use four-part name to retrieve data from Sybase, such as
    SELECT * FROM sybaseServer.SybaseDB.dbo.myTable
    The error is as below:

    The OLE DB provider "ASEOLEDB" for linked server "sybaseServer" reported an error. The provider did not give any information about the error.
    Msg 7312, Level 16, State 1, Line 1
    Invalid use of schema or catalog for OLE DB provider "ASEOLEDB" for linked server "sybaseServer". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

    Any idea?
    Any input will be greatly appreciated.

  2. #2
    Join Date
    Mar 2009
    sounds like you are using a driver that is not compatible with the sybase catalogue. MS SQL 2005 and Sybase 12.5 do differ, the branch started in sybase 11.5 and microsoft 6.5...

    try using a Data Direct ODBC driver on the SQL Server side.


  3. #3
    Join Date
    Mar 2007

    sql server to sybase via linked

    turn on 'Allow inprocess' ..
    radio button needs to be set at the linked servers/providers/ASEOLEDB tree

    right click on the ASEOLEDB provider and you will get the dialog ..

    no gurantees, but if you haven't checked it, it won;t work.

    I have mine working, but still get metadata errors on some tables, others are fine.. I think the MS SQL Server 2005 driver being used, is not fully compatible with ASE 15.

  4. #4
    Join Date
    Mar 2009
    It is checked. No use. Many thanks.

Posting Permissions

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