SQL Server 64 Bit...Linked Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ajay - 25 Feb 2005 18:03 GMT

Does SQL Server 64 Bit support linked servers, I am trying to read data from
a 32 bit server, it tells me the ODBC driver is missing. The driver is
installed in the drivers section in ODBC.

Any ideas ?

Thank you

Reply to this Message

Mike Epprecht \(SQL MVP\) - 26 Feb 2005 14:12 GMT

Hi

Yes it is. How did you set it up. As an ODBC datasource or a "SQL Server"
connection on the linked server dialogue?
If it is a SQL Server, always use the native SQL Server option.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> Does SQL Server 64 Bit support linked servers, I am trying to read data from
> a 32 bit server, it tells me the ODBC driver is missing. The driver is
[quoted text clipped - 3 lines]
>
> Thank you

Reply to this Message