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
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
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
> 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
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
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
[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
> 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
; <[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
9 matches
Mail list logo