?
Solved

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

Posted on 2009-03-31
2
Medium Priority
?
335 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 2000 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

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…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

771 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