Re: query between 2 database types

2000-12-13 Thread Greg Wolfinger
Eli: I know that Novell puts out a product that lets you connect sql server, oracle, access, db2, etc... all together and use them as a virtual single database. I believe its called SQL Everywhere (but I'm really not sure). Greg - Original Message - From: "Eli Shechter" <[EMAIL PROTECTE

RE: query between 2 database types

2000-12-13 Thread Allan Pichler
To the best of my knowledge, you can't ! I believe that feature will be available in CF 5, but you would stil need to run 2 queries. The new feature in CF 5 allows you to run queries on existing recordsets! As you probably know you can only specify one DATASOURCE pr. query, so accessing 2 from on

Re: [query between 2 database types]

2000-12-13 Thread Alex
not sure if you can. but you can query one DB then populate the results in a temp table in the other DB "Eli Shechter" <[EMAIL PROTECTED]> wrote: Hi I recently started using a program that runs off a oracle database, and my website runs off SQL server 7.0 how can I run a query so that within on

RE: query between 2 database types

2000-12-13 Thread Dave Watts
> I recently started using a program that runs off a oracle > database, and my website runs off SQL server 7.0 > > how can I run a query so that within one query I can pull > data from both databases? You can't really do that from CF. There are ways to get what you want. One way is to run the

RE: query between 2 database types

2000-12-13 Thread Rick Lamb
Gona have to wait for CF 5.0. It has the ability to query a query which will allow this. Rick -Original Message- From: Eli Shechter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 12:26 PM To: CF-Talk Subject: query between 2 database types Hi I recently started using a

RE: query between 2 database types

2000-12-13 Thread Simon Horwith
the short answer is that you can't. Of course, there are always ways to get the job done... so I'll rephrase: you can't do this with CFQUERY... no matter how kick ass your SQL might be. What you can do, is either use CFOBJECT, a sql server job, or a DTS; to implement some sort of COM or CORBA so

RE: query between 2 database types

2000-12-13 Thread Peter Stolz
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 2:53 PM To: CF-Talk Subject: RE: query between 2 database types To the best of my knowledge, you can't ! I believe that feature will be available in CF 5, but you would stil need to run 2 queries. The new feature in CF 5 allows you t

RE: query between 2 database types

2000-12-13 Thread Dave Watts
> Gona have to wait for CF 5.0. It has the ability to query a > query which will allow this. To the best of my knowledge, the ability to query a recordset already retrieved by CF (which is supposed to be introduced in CF 5) still will not allow a single query to be run against multiple datasourc

Re: query between 2 database types

2000-12-13 Thread Neil H.
; <[EMAIL PROTECTED]> Sent: Wednesday, December 13, 2000 4:06 PM Subject: RE: query between 2 database types > Gona have to wait for CF 5.0. It has the ability to query a query which will > allow this. > > Rick > > -Original Message- > From: Eli Shechter [mailto:[EMAIL P