64 bit linked server to Sybase

Tech-Archive recommends: Speed Up your PC by fixing your registry

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)


.

Relevant Pages

  • Re: How to know whether SQL Server 2005 Tools installed are x64 ve
    ... My mistake, I'm confused with SSMS, as there's no x64 version of this tool. ... have a look at "Microsoft SQL Server 2005 Command Line Query Utility", ... Microsoft SQL Server Management Objects Collection ...
    (microsoft.public.sqlserver.tools)
  • Re: Cant install SQL Server 2005 Express Edition on WinXP Pro x64 (0x80041008)
    ... Edition setup off CD, everything installs just fine, but SQL ... Server 2005 Express Edition x64". ... it fails on "SQL Server Setup is scanning ... executed due to WMI configuration on the machine ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server consolidation project
    ... The bottom line is that X64 will give you reasonable cost hardware that is capable of accessing lots of memory directly for X64 bit apps while still allowing 32 bit apps to run just as fast as well. ... Andrew J. Kelly SQL MVP ... Could you guys please recommend some good IBM machines as i dont have a choice for running SQL Server as a cluster ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 x96 and x64 side by side
    ... If I followed the discussion correctly, the cluster in this example has SQL ... Your comment on "x64 does not have a compiler for scripting" I don't quite ... The SQL Server Books Online also have a discussion of how to run SSIS ... We want to isntall anew dedicated instance for SSIS in Prod and they want ...
    (microsoft.public.sqlserver.setup)
  • 64-bit linked server to Sybase
    ... vendors do not have a 64-bit driver. ... Looks like our migration is SQL Server 2005 x64 will have to wait unless we ... Any one using Data Direct to connect to Sybase from SQL Server 2005 x64? ...
    (microsoft.public.sqlserver.connect)