Re: How to use ODBC datasources in SQL Server 2005 x64

Gregor 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?
.

Relevant Pages

  • Re: Copying from one record set to another
    ... I had a version using linked servers in SQL Server, ... I have another thread in the SQL server newsgroup looking for an answer ... read about linked tables in Access online help - a linked table can be ...
    (microsoft.public.data.ado)
  • Re: Permissions on master..sysservers
    ... application uses linked servers to link to other SQL Servers. ... I've noticed the constraint is across all of our SQL2K SP3 installations, ... > Jasper Smith (SQL Server MVP) ... > constraint on the providerstring column causing the select statement to ...
    (microsoft.public.sqlserver.security)
  • Re: temp db indexing in SQL2k
    ... SQL Server has something called deferred name resolution. ... But if all tables in a query exists, then all other objects in the ... Maybe your scenario with linked servers changes the scene here, ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.programming)
  • How to use ODBC datasources in SQL Server 2005 x64
    ... I migrated from SQL Server 2000 Standard to SQL Server 2005 Standard x64. ... Now i try to get the linked Servers working, ... The MSDASQL (ole db provider for ODBC data sources) is missing. ...
    (microsoft.public.sqlserver.connect)
  • 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)