Solved

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

Posted on 2009-03-31
2
332 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Suggested Solutions

Title # Comments Views Activity
display data in text field from data base for updating 6 69
Replace Dates in query 14 55
Addition to SQL for dynamic fields 6 56
SSMS Imprt data from Excel 7 22
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

756 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