SQL Server linked Server to SYBASE Advantage Database

Posted on 2011-10-27
Last Modified: 2012-05-12
Hi Experts
We are trying to create a SQL linked server between SQL server 2008 express and Advantage databse server.
We can successfully create the linked server within SQL server but do not seem to be able to see any tables in the direcroty we specify that in the linked server properties.
Any advice greatly received
Question by:cancuk
    LVL 8

    Accepted Solution

    Are you trying to see the tables using MS SQL object browser?  Because there is a good chance that won't work - it has to do with the capabilities of the Sybase drivers.  A better test is to attempt to query a table via the linked server and see if you can do that successfully.

    Author Closing Comment

    Many thanks, this has helped out tremendously

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now