64-bit linked server to Sybase

Hi,
From my research, it appears that it is not possible to have a linked server
created in SQL Server 2005 x64 use a 32-bit DSN (i.e. created with a 32 bit
driver). The answer is that I need to create a 64-bit DSN in order to
create a linked server in SQL Server 2005 x64. The problem is that many
vendors (i.e. Sybase) do not have a 64-bit driver.
Looks like our migration is SQL Server 2005 x64 will have to wait unless we
can get this to work with perhaps a third party vendore such as Data Direct.
Any one using Data Direct to connect to Sybase from SQL Server 2005 x64?
Thanks,
Rocco M.
(posted in microsoft.public.sqlserver.odbc,
microsoft.public.sqlserver.clients and microsoft.public.sqlserver.connect)Hi,
I've just ran into the same problem linking to Oracle 8i.
MSDAORA, OraOLEDB.Oracle and ODBC drivers do not work.
64 bit drivers have not been released yet... Any workaround except returning
to sqlserver 32bit?
Davide
"Rocco M" <rocco.mastrangelo@.hp.com> ha scritto nel messaggio
news:AHYeg.1209$cY3.584@.news.cpqcorp.net...
> Hi,
> From my research, it appears that it is not possible to have a linked
> server created in SQL Server 2005 x64 use a 32-bit DSN (i.e. created with
> a 32 bit driver). The answer is that I need to create a 64-bit DSN in
> order to create a linked server in SQL Server 2005 x64. The problem is
> that many vendors (i.e. Sybase) do not have a 64-bit driver.
> Looks like our migration is SQL Server 2005 x64 will have to wait unless
> we can get this to work with perhaps a third party vendore such as Data
> Direct. Any one using Data Direct to connect to Sybase from SQL Server
> 2005 x64?
> Thanks,
> Rocco M.
> (posted in microsoft.public.sqlserver.odbc,
> microsoft.public.sqlserver.clients and microsoft.public.sqlserver.connect)
>