How to use ODBC datasources in SQL Server 2005 x64

From: Gregor Stefka <stefka@xxxxxxxxxxxxxxxxx>
Date: Sun, 03 Dec 2006 14:43:26 +0100

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
.

Follow-Ups:
- Re: How to use ODBC datasources in SQL Server 2005 x64
  - From: Gregor Stefka

Prev by Date: Re: SQL 2k5 Dev on Vista Business
Next by Date: 2.0 Timeout Expired / TCP Provider, error: 0 / Clustered SQL 2000
Previous by thread: Re: SQL 2k5 Dev on Vista Business
Next by thread: Re: How to use ODBC datasources in SQL Server 2005 x64
Index(es):
- Date
- Thread

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: 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. ... SQL Server 2005 x64 does not support ODBC Data sources as linked servers!! ...
(microsoft.public.sqlserver.connect)
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)
Re: DSN-less connection
... Setting up ODBC data sources is a headache for each user workstation. ... What means of authentication do you use? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver)