Ok, I have a developer trying to use an SP in Oracle to return an
actual query result set to CFMX. Is this even possible anymore? He
followed
http://livedocs.macromedia.com/coldfusion/7/htmldocs/0313.htm
but gets
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]The
Ok, I have a developer trying to use an SP in Oracle to
return an actual query result set to CFMX. Is this even
possible anymore? He followed
http://livedocs.macromedia.com/coldfusion/7/htmldocs/0313.htm
but gets
Error Executing Database Query.
[Macromedia][Oracle JDBC
bamm! thanks Dave. My developer is happy now, complained about the
Live Docs though. :)
D
On Wed, 9 Mar 2005 11:30:19 -0500, Dave Watts [EMAIL PROTECTED] wrote:
Ok, I have a developer trying to use an SP in Oracle to
return an actual query result set to CFMX. Is this even
possible
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
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,
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 is
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
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 it
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
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
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 just
.
Doug
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 4:25 PM
To: CF-Talk
Subject: Re: CFMX Oracle native DSN issues
Yes, I installed the oracle client months ago and a similar
DSN is working
fine on CF5.
Pete
- Original
I can't for the life of me get an oracle native DSN properly configured in CFMX. I
have my tnsnames.ora file open and am copying the SID, server, port, username,
password, etc. verbatim, yet I cannot get the connection to verify correctly. The
error message I'm getting is:
Connection
PROTECTED]]
Sent: Wednesday, February 12, 2003 3:38 PM
To: CF-Talk
Subject: CFMX Oracle native DSN issues
I can't for the life of me get an oracle native DSN properly configured
in CFMX. I have my tnsnames.ora file open and am copying the SID,
server, port, username, password, etc. verbatim, yet I
\tnsnames.ora, for example)).
-lincoln
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 3:38 PM
To: CF-Talk
Subject: CFMX Oracle native DSN issues
I can't for the life of me get an oracle native DSN properly configured in CFMX. I
Yes, I installed the oracle client months ago and a similar DSN is working
fine on CF5.
Pete
- Original Message -
From: Stephenie Hamilton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 12, 2003 3:41 PM
Subject: RE: CFMX Oracle native DSN issues
Are you
I don't know why you are getting an error, but CFMX does not require the Oracle
client/drivers to be installed at all.
Doug
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 4:25 PM
To: CF-Talk
Subject: Re: CFMX Oracle native DSN
Does anybody know what differences there might be between the 4.5 and MX
ODBC drivers for a Oracle database. We have a query to the Oracle database
the runs just fine on a CF4.5 server, but when we migrated to new CFMX
server all of a sudden the query is throwing errors. Both cold fusion
servers
Does anybody know what differences there might be between the 4.5 and MX
ODBC drivers for a Oracle database. We have a query to the Oracle database
the runs just fine on a CF4.5 server, but when we migrated to new CFMX
server all of a sudden the query is throwing errors. Both cold fusion
servers
use the CreateODBCDateTime() function. Old ODBC drivers created date and time down
to the seconds, new date times go to the 1/10 seconds.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
.
Thanks Ian
-Original Message-
From: Larry Hoy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 11:44 AM
To: CF-Talk
Subject: CF4.5 and CFMX Oracle ODBC Drivers
use the CreateODBCDateTime() function. Old ODBC drivers created date and
time down to the seconds, new date times
You might want to check out this TechNote:
http://www.macromedia.com/v1/Handlers/index.cfm?ID=23463Method=Full
Deb
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 3:03 PM
To: CF-Talk
Subject: CF4.5 and CFMX Oracle ODBC Drivers
Does
Thanks for the interesting comments. What is weird about this to me, is
that I'm not INSERTing the data, I'm SELECTing the date. The date is
already in the Oracle database table. It was put into it by another tool
which assumable did so correctly, the data is there. But when I try to
SELECT
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 2:11 PM
To: CF-Talk
Subject: RE: CF4.5 and CFMX Oracle ODBC Drivers
Thanks for the interesting comments. What is weird about this to me, is
that I'm not INSERTing the data, I'm SELECTing the date. The date is
already in the Oracle
Hi,
I've installed CFMX (upgrade from 5) and can not connect to the Oracle 8.1.7
database using the native cold fusion driver, OCI, or the thin type. The
error is:
Connection verification failed for data source: admin_dept_dba
[]java.sql.SQLException: SQLException occurred in JDBCPool
while
Robert Shaw wrote:
So my questions are:
1. Does anyone have any tips or tricks for connecting to Oracle
2. Is there a recommendation for using Native, OCI or thin?
Are you able to connect to the database from the server using the Oracle
client software, such as SQL*Plus?
- Rick
On Tuesday, Nov 12, 2002, at 08:06 US/Pacific, Robert Shaw wrote:
I've installed CFMX (upgrade from 5) and can not connect to the Oracle
8.1.7
database using the native cold fusion driver, OCI, or the thin type.
The
error is:
Connection verification failed for data source: admin_dept_dba
CFMX and Oracle are both running on the Mac (OS X Jaguar) and talking
to each other!
With a reinstall of Oracle (the first ran out of space), and some key
input from Sean Corfield (who's been there) it was possible to get over
the final hurdles, and get these 2 beauties working together.
28 matches
Mail list logo