Hi Jamie and all,
I assume you are NOT going to be using the more expensive CF Server
Enterprise version which supports native Oracle drivers; therefore, you will
be connecting from ColdFusion to Oracle via ODBC.
I am also assuming that you can set up (or have a DBA set up) your Oracle
database. In particular, you will need to know the Oracle SQL*Net Connect
String for the database (SID). (See the Oracle file TNSNAMES.ORA)
Since you mention Access, I also assume you are using Windows.
Verify that you can get to the Oracle database using Oracle SQL*PLUS (or by
attaching via MS Access).
On your CF server, set up an ODBC System Data Source using the Oracle
driver. Enter a name for the datasource, a description, and the connect
string (e.g., blah.world).
I then used the CF Administrator page (on my system, it's at
http://<root>/cfide/administrator/login.cfm Data Sources tab to put in the
userid and password to be used by ColdFusion. You can Verify the ODBC data
source from CF Admin.
Note that we're running an older version of CF but I believe this still
would work.
HTH.
Ben
-----Original Message-----
From: Jamie Symonds [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:42 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: CF and ORACLE
This is a multi-part message in MIME format.
--------------5487AC23954301E34319E9FB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hello all - I am a senior in the Bachelor of Information
Systems program at St. Francis Xavier University
[http://www.stfx.ca] in Antigonish, NS. For a course
project (Info 475 - Databases), my project team (myself,
Melanie MacCulloch [[EMAIL PROTECTED]], Nadine Benoit
[[EMAIL PROTECTED]] and Jason Hatfield [[EMAIL PROTECTED]]) is to
create a database in Oracle and collect survey data through
CF forms. I have used CF before for data collection with an
Access database; however have no experience in setting up an
Oracle datasource. We're concerned about setting up our
database and how to go about logging into our database to
insert data through CF... can anyone point us to an info
source (FAQ), etc.?
Thanks!! -----Jamie http://www.stfx.ca/people/x97/x97gfq
--------------5487AC23954301E34319E9FB
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Symonds, Jamie
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Jamie Symonds
n: Symonds;Jamie
adr: Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada
email;internet: [EMAIL PROTECTED]
title: Bachelor of Information Systems, Major (student)
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
version: 2.1
end: vcard
--------------5487AC23954301E34319E9FB--
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
