Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
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…

604 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