Re: Remote Client for SQL Server 2000 - create linked servers

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

arno (aschobspam@xxxxxxxxx) writes:
PS: For other reasons I have to go back to another snapshot. So I
could test the installation of SQL-Server again, and odbc crashed
again. So, I cannot install SQL-Server without problems. The error
message is (translated from german):

runtime error '-2147467259 (80004005)': [Microsoft][ODBC Driver
Manager] The name of the datasource could not be found, there was no
standard driver mentioned.

So, I will have to try SQL Server express 2005 to see if I can set
linked servers with GUI.

The error message indicates an incorrect connection string.

But I realise that I am at complete loss of trying to understand
what you are doing. Do you get this error when you try to connect
to SQL Server from an application? Or do you get it when you try to
access a linked server?

Maybe you should start over and tell from the beginning what you are
doing and what is failing.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Remote Client for SQL Server 2000 - create linked servers
    ... I have not tried to create linked server from Express (I think it should ... I need a client to administer one SQL Server 2000 database from my ... create linked servers to flatfiles, Access mdb, Excel files etc... ...
    (microsoft.public.sqlserver.clients)
  • 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)