Re: 64-bit linked server to Sybase
- From: "Dave" <dgorla@xxxxxx>
- Date: Fri, 09 Jun 2006 22:24:11 GMT
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@xxxxxx> ha scritto nel messaggio
news:AHYeg.1209$cY3.584@xxxxxxxxxxxxxxxxxxx
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)
.
- Prev by Date: In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO.net?
- Next by Date: Re: In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO.net?
- Previous by thread: In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO.net?
- Next by thread: Enable SQL Server Remote Connections via Script
- Index(es):
Relevant Pages
|
