SQL Server 2005 Linked server problem

Posted on 2007-07-27
Last Modified: 2008-01-09
I've loaded the MERANT Progress Drive 4.0 on my SQL Server (2005). The SQL Server is in a clustered environment. I set up a data source and the connection is successful when I use the "Test Connection" button.  However, when I try to create a linked server I get
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "VANTAGE52".
OLE DB provider "MSDASQL" for linked server "VANTAGE52" returned message "Specified driver could not be loaded due to system error  126 (DataDirect 4.0 Progress).". (Microsoft SQL Server, Error: 7303)

For help, click:
The reason I think it's a SQL Server problem, is because I have a local copy of SQL Server 2005 with the same driver and the same linked server works fine.
Thanks for any help.
Question by:ChadMarsh
    LVL 8

    Accepted Solution

    Solution to the similar problem here...
    LVL 2

    Author Comment

    I'm starting to think it's related to Windows Server 2003. Thanks for the reply.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Suggested Solutions

    In this article I will describe the Backup & Restore 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.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now