I think it would probably be better to use the Oracle ODBC connector rather than the MS one. I would put money that the MS driver isn't feature complete.
Kevin >>> [EMAIL PROTECTED] 03/19/02 02:46PM >>> We run Oracle 8 here with CF5 Ent. You have two choices. CF Enterprise comes with Native Oracle drivers. You can also use the MS odbc drivers for Oracle. They are very solid and very fast. I've read somewhere (can't remember where) that the latest MS ODBC drivers for Oracle are actually faster with CF than the Native. We have Oracle running on IBM and as a result, we have an issue with the Native drivers, so we use the Microsoft ODBC exclusively. Dave ===================== David Hannum Web Analyst/Programmer Ohio University Athens, OH ----- Original Message ----- From: "Ray Bujarski" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 5:03 PM Subject: Oracle ODBC CF5 Ent > I have CF 5 Enterprise server, I am running oracle 8 for my data server. I > see the drivers (Merant Oracle 8) for creating the odbc connection, but I > am unable to connect. I tried via SQLSoft no problems, I can run queries > as well. > I found in the installation documentation to create an alias Using the Net8 > Easy Config, well when I do that I get a message saying that my tnsnames > file was updated, then I am unable to connect even through my SQLSoft. > I am now able to connect again using SQLSoft, but still a no go on the ODBC > Connection. > Does anyone know what I may be doing wrong here? > Your help is very much appreciated! > Macromedia really needs to get their crap together as far as the ODBC > connections with oracle. I am about to switch back to perl. Worked fine > for me! > > Ray Bujarski > 858-845-7669 > 858-636-9900 pgr > [EMAIL PROTECTED] > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
