Re: CF8 Standard and Oracle

[Ian Skinner <iskinner@xxxxxxxxxxx>]

ccwebman wrote:
> I recently had a server die that was running an old old cf4.5 enterprise with 
> oracle. I just purchased the coldfusion 8 standard (no $ for enterprise right 
> now) and I need to connect to the oracle database. Is there any instructions on 
> doing this? 
>
>  please help
>
>  Corey

With Standard you do not have the built in Oracle driver, as I am sure 
you are aware.  Your choices are to use Oracle's JDBC 'Thin Client' or 
ODBC drivers.  The former is generally considered the better option. 
You just install the JDBC driver from oracle then configure it as an 
'other' DSN in ColdFusion.  There are knowledge base articles on how to 
do this on Adobe and the internet.  They may reference CF7, but the 
process should be equivalent.  I don't have links at hand since it has 
been a couple of years since I have had to do this.