Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2008-09-18 : 16:08:17
|
| Any suggestions on what drivers / software I can get to establish a linked server from SQL Server 2005 (64 bit) to a Sybase ASE 12.5 (32 bit) database?I have gotten a configuration working using SQL Server 2005 (32 bit) to Sybase ASE 12.5 (32 bit) by using:- SQL Servers OLEDB 32 bit provider for ODBC (MSDASQL)- Configured ODBC DSN using the 32 bit Sybase ASE ODBC DriverHistory:Initially there was not the MSDASQL provider on SQL 2005 x64. I downloaded it from MS and installed it. Great, the provider now shows up in SQL. However it will not talk with a 32 bit ODBC DSN.At this point I'm open to any suggestion. Whether it be a OLEDB provider in SQL Server that communicates directly to Sybase or whether it is a ODBC driver that the 64 bit MSDASQL works with.I have looked at DataDirect and Sybase directly. I'm actually evaluating DataDirect now but Sybase wants me to purchase the entire Developer SDK for $1,500 just to get the 64 bit ODBC driver. I'm basically looking for an inexpensive and stable solution. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-18 : 16:25:11
|
| tfountain,We had the same issue connecting to 32-bit ODBC drivers from MSDASQL. We had this issue even before April when it was released. We got 64-bit ODBC drivers for openlink and it worked fine. |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-09-19 : 09:21:08
|
| I have downloaded the x64 OLEDB ODBC provider (MSDASQL) for SQL to use from the MS site (http://www.microsoft.com/downloads/details.aspx?FamilyID=000364db-5e8b-44a8-b9be-ca44d18b059b&displaylang=en#Overview). Now my only other issue is I need to find a reliable x64 ODBC driver for it to use. My other alternative is to find a x64 OLEDB provider to install on the SQL box that talks directly to Sybase. Any other suggestions besides Openlink since that one is a $1500 solution. Or am I pretty much stuck with this cost with any solution? |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-09-22 : 13:00:48
|
| Just wanted to post my solution. I downloaded the x64 OLEDB ODBC provider (MSDASQL) from Microsoft and installed it, then purchased the x64 ODBC drivers from Sybase directly. I actually had to purchase the development SDK as it is not sold separately and is bundled with that. |
|
|
|
|
|
|
Linked server on 2005 (x64) to Sybase ASE 12 (x86)