Post reply

How to retrieve sybase data from ms sql?

  • March 24, 2009 at 3:12 pm

    #94745

    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.

  • March 25, 2009 at 12:19 pm

    #966189

    I know nothing about Sybase, but... Does Sybase even use owners/schemas the same way SQL does? Does "dbo" mean anything to Sybase at all?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • March 26, 2009 at 9:46 am

    #966790

    Four-part name rule works for Sybase ASE 12.5 version. But it does not work when I used ASE 15. I do not know why.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply