?
Solved

SQL Server 2005 Linked server problem

Posted on 2007-07-27
2
Medium Priority
?
1,329 Views
Last Modified: 2008-01-09
Hello,
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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3152&EvtSrc=MSSQLServer&EvtID=7303&LinkId=20476
***************
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.
Chad
0
Comment
Question by:ChadMarsh
2 Comments
 
LVL 8

Accepted Solution

by:
jawahar_prasad earned 2000 total points
ID: 19583664
Solution to the similar problem here...

http://www.expertsforge.com/Applications/Tutorial-133.asp
0
 
LVL 2

Author Comment

by:ChadMarsh
ID: 19612160
I'm starting to think it's related to Windows Server 2003. Thanks for the reply.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 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