Solved

Error creating a Linked Server (OLEDB) for Sybase from SQL Server 2006 64bit

Posted on 2009-03-31
2
333 Views
Last Modified: 2012-05-06
We are moving our databases (Sybase 12.5.03 & SQL Server 2000 EE 32bit) as part of this we'll be upgrading SQL Server to 2005 EE,  to a new host, running Windows Server 2003 R2 Enterprise 64bit.

The problem is on the new host I can't get the linked server to work because the Provider (Sybase.ASEOLEDBProvider) is not being registered with SQL Server. I have run the Sybase OLE Configuration Manager version 2.7 and it appears to work. I have rebooted to see if that helps but it doesn't want to work ?

The is a copy of the error message attached,

Andy
033109-Errors.docx
0
Comment
Question by:IDCSSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 500 total points
ID: 24033120
My guess is that the Sybase.ASEOLEDBProvider you are trying to use is 32 bit and you are trying to use SQL Server 64 bit.

Are you going to the 64 bit versions of both Sybase and SQL Server?
Does the ASEOLEDBProvider come in the flavor you need?

Regards,
Bill
0
 

Author Closing Comment

by:IDCSSupport
ID: 31565026
thanks
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
restore master and user database in sybase ase 2 104
Analysis of table use 7 67
How can i use WITH CTE for checking exist value? 3 63
SQL query 7 43
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …

740 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