linked servers 
Author Message
 linked servers
I've established a linked server connection to an Access database using the
oledb for odbc driver.  How should i reference the tables in the database?
i've tried everything but can't find a way of doing it.  Sql server
documentation says to use linkedserver.catalog.schema.objectname.
If i'm using the northwind.mdb database how should i do a select to the
customers table?

Any help would be greatly appreciated,

Soeb Bhana



Wed, 24 Apr 2002 03:00:00 GMT
 linked servers

Soeb - Assuming a linked server name of AccessServer your query would be
similar to
select  *  from AccessServer...customer

--
HTH
--
Jerry Spivey
MCT, MCSE, MCSD
Senior SQL Instructor - Consultant
ARIS Corporation  Bellevue, WA
(Please reply to the newsgroup only, not by email.)


Quote:
> I've established a linked server connection to an Access database using
the
> oledb for odbc driver.  How should i reference the tables in the database?
> i've tried everything but can't find a way of doing it.  Sql server
> documentation says to use linkedserver.catalog.schema.objectname.
> If i'm using the northwind.mdb database how should i do a select to the
> customers table?

> Any help would be greatly appreciated,

> Soeb Bhana



Wed, 24 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Is It Possible: Linked Server to Linked Server?

2. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

3. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

4. LINKED SERVERS : How to link MySQL server on SQL Sever 2000

5. Reliable link to Oracle server (linked, server, oracle)

6. linked server, DTC, SQLOLEDB, Access, linked tables = HEADACHE!

7. How linked are linked servers ?

8. Problem linking to Sybase as linked server

9. urgent: link mysql db as a linked server

10. link server from Oracle to SQL server occurs blocking on SQL server

11. Remote Server -- Changing from Remote Server to Linked Server

12. Linked Server - Server: Msg 7399 - It is already opened exclusively by another user


 
Powered by phpBB® Forum Software