CFMX does not natively support Oracle 7.3 databases- this is something that is new with CFMX and was not an issue in CF 5.0. We ran into this problem on our Win2k test site. We created an ODBC, not JDBC, connection in Win2k and then connected the CFMX JDBC connector to an "ODBC Socket." But that's about the extent of my memory of what we did.
The problem I have is that it's easy to poke around through Win2k's GUI interface and find the right way to set up the connection, it's not as easy when you don't have root access to a Solaris server and need to put together a list of steps for someone else to do. Thanks for any info. Don ----- Original Message ----- Date: Fri, 11 Oct 2002 13:38:59 -0400 From: "Cathy Taylor" <[EMAIL PROTECTED]> Subject: Re: Connecting to Oracle 7.3.4 database via Oracle server using CFMX Message-ID: <00e601c2714d$150ba3a0$eed387a5@LOADRUNNER2> If you're using CFMX on Unix (btw, which flavor because I'm guessing you're at another gov't facility and if Solaris, you may run into the same problems I've been with 'nobody'?) you just specify the type of database and the proxy port number to connect to. It does the rest. I haven't connected MX to Oracle 7.3 yet, but I've connected 5.0 to it in the past without a problem. Get it installed and peek at the Administrator datasource setup to see what I mean. There's no 3rd party connector involved (or ODBC config). Cathy ----- Original Message ----- From: "Smith, Don , , WHS/PSD" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 12:53 PM Subject: Connecting to Oracle 7.3.4 database via Oracle server using CFMX > Or main unix guru is out of the office today while I'm moving an MX > installation from Win2k to Unix. > > The backend db for this app is in Oracle 7.3.4 which is not supported > in CFMX. On Win2k I created an odbc connection to the database and > then create > an odbc socket connection to that existing data source. That was so > easy to > do in Win2k that I pretty much forget how I did it. > > But I am not as familiar with creating an odbc connection in Unix. I > have the ear of a Unix admin that I can work with, so how would I go > about doing > this? > > Thanks for any info! > > Don > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
