I migrated from SQL Server 2000 Standard to SQL Server 2005 Standard
x64. Now i try to get the linked Servers working, but it looks like
there is no way to use ODBC Data sources as linked servers. Yes of
course, i ve got 64-Bit ODBC Drviers installed and tested.
The MSDASQL (ole db provider for ODBC data sources) is missing.
SQL Server 2005 x64 does not support ODBC Data sources as linked
servers!! Is it really true?
tia
Gregor StefkaGregor Stefka schrieb:
>
> I migrated from SQL Server 2000 Standard to SQL Server 2005 Standard
> x64. Now i try to get the linked Servers working, but it looks like
> there is no way to use ODBC Data sources as linked servers. Yes of
> course, i ve got 64-Bit ODBC Drviers installed and tested.
> The MSDASQL (ole db provider for ODBC data sources) is missing.
> SQL Server 2005 x64 does not support ODBC Data sources as linked
> servers!! Is it really true?
>
> tia
> Gregor Stefka
I cant find any information on microsoft.com.
can anyone clarify this?
is there odbc support (MSDASQL.DLL) for SSIS / linkedServers in SQL
Server 2005 x64?
No comments:
Post a Comment