heterogenous query 
Author Message
 heterogenous query

Hi there!

I am trying to do an heterogenous query (insert in a different server
than the server holding data to be inserted) between 2 Sybase servers
(using DAO connectins) based the Jet help file:

INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])]
SELECT [source.]field1[, field2[, ...]
FROM tableexpression

Microsoft says you can do this with ODBC datasources and MS SQL Server.

I am wondering if this is possible with Sybase servers and if anybody
has some code samples to illustrate this.

Appreciate your help,

Wed, 09 May 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. heterogenous queries

2. Heterogenous Joins and RAS Connections

3. ADO and heterogenous joins

4. login script in heterogenous network

5. Heterogenous Join, tables in 2 different MDBs

6. Heterogenous(?) query with RDO???

7. how can I build 2 queries in 1 query(VB SQL query)

8. Selecting from a Parameterised query in a CreateQuerydef'd query

9. function used in query repeats for each query value

10. query of a query

11. SQL Query - MAX, Grouping and Sub query

12. Query Object vs VBA Query


Powered by phpBB® Forum Software