Interesting, though I can not think of any data center I have worked
with that would be happy with a request to do such a link. Then again
the guys around here in the data centers are "set in their ways" and
never like "change". I'd have to wonder if after linking databases if
it is faster than j
DTS can run stored procedures as well. The two options
aren't exclusive. If you're really worried about
speed, then you should definitely cut CF out of the
loop and have SQL Server pull the data directly from
Oracle.
If you have SQL Server talk to Oracle directly, then
you will probably need to se
Aaron,
Check this out:
http://www.winnetmag.com/SQLServer/Article/ArticleID/22264/SQLServer_22264.html
Regards,
-JB
Aaron Rouse wrote:
> Why do you need to execute the DTS from CFMX? I suppose you could do
> a combination of DTS and stored procedures. I personally have never
> used an SP to
Why do you need to execute the DTS from CFMX? I suppose you could do
a combination of DTS and stored procedures. I personally have never
used an SP to connect to another flavor database and pull out date,
honestly not even sure how that would be done, so could not say if it
is faster or not to do
My first thought was DTS but arent SPROCs much faster to execute? Plus
I need to execute the DTS via a Cold Fusion template I know how to due
this but I always run through loops with my DBA about the setup with all
the permissions I need to have setup.
Regards,
-JB
Dave Watts wrote:
> > I'm
> I'm need some advice. I have a few tables in Oracle 9i that I
> need to get into SQL Server 7 daily and when needed, the
> basic function of the process is get the data from Oracle
> then perform some joins followed by creating a new table in
> SQL Server with the results each time this job i
I would use a DTS package. I have a process here that runs nightly
and it is a DTS package that connects to the Oracle 9i server and
pulls data out of views and places that data into tables on the SQL
Server then manipulates that data into the final tables that their
application accesses.
On Tue,
CFers,
Im need some advice. I have a few tables in Oracle 9i that I need to
get into SQL Server 7 daily and when needed, the basic function of the
process is get the data from Oracle then perform some joins followed by
creating a new table in SQL Server with the results each time this job
is
t there feel free to correct me if I'm wrong.
Mark
-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 10:38 AM
To: CF-Talk
Subject: OT: Oracle and SQL Server Licenses
I am looking to answer a question about the licensing models for both SQL
I am looking to answer a question about the licensing models for both SQL
Server and Oracle. After reading several legal masterpieces from each
company, I am no closer to an answer but am ready for a beer. Does someone
know what my licensing options are for the enterprise managers for each
program
stgetat function the key
that represents row 50 and the key that represents row 100 and requery for
the rows whose keys fall between them.
-Original Message-
From: Todd McFarlin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 6:11 PM
To: CF-Talk
Subject: RE: Oracle and SQL
G
Lmao... I think that was Mcfarland???
>From: Peter Theobald <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: Oracle and SQL
>Date: Thu, 14 Dec 2000 21:47:00 -0500
>
>Can't you use Cold Fusion's startrow=
Can't you use Cold Fusion's startrow= and maxrows= to do the same thing?
P.S. I loved your comics, animations, film, and action figures :-)
At 10:17 AM 12/14/00 -0800, Todd McFarlin wrote:
>Greetings,
>
>Being an Oracle person, I'm having a difficult time trying to make a
>CFQuery work
tarting point. But how
does one say RowNum in SQL?
-Original Message-
From: Todd McFarlin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 10:17 AM
To: CF-Talk
Subject: Oracle and SQL
Greetings,
Being an Oracle person, I'm having a difficult time trying to make a
, December 14, 2000 1:17 PM
To: CF-Talk
Subject: Oracle and SQL
Greetings,
Being an Oracle person, I'm having a difficult time trying to make a
CFQuery work correctly in SQL.
The Problem: I have a database with thousands of rows. I need to select only
50 rows per query. The start
If you're using native oracle drivers, and not ODBC, your CFQUERY content
should contain oracle syntax, so rownum would be a valid option in the syntax.
Judith Campbell
Chief Technical Officer
Digital Positions, Inc.
[EMAIL PROTECTED]
404-351-9366
At 09:40 AM 12/14/00 -0800, you wrote:
>Greetin
Use the Maxrows argument in the CFQuery Tag:
Select * from the_table where user_id = 1
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.
You can use the max rows in the cfquery or run a cfloop over the query
> ** Original Subject: RE: ORACLE and SQL
> ** Original Sender: "Todd McFarlin" <[EMAIL PROTECTED]>
> ** Original Date: Thu, 14 Dec 2000 14:21:44 -0500
> ** Original Message follows...
>
&
Greetings,
Being an Oracle person, I'm having a difficult time trying to make a
CFQuery work correctly in SQL.
The Problem: I have a database with thousands of rows. I need to select only
50 rows per query. The start row and end row need to be variables. Now,
Oracle has a function called
Greetings,
Being an Oracle person, I'm having a difficult time trying to make a
CFQuery work correctly in SQL.
The Problem: I have a database with thousands of rows. I need to select only
50 rows per query. The start row and end row need to be variables. Now,
Oracle has a function called
20 matches
Mail list logo