Okay, well I finally got the MS ODBC driver working, I had to go around my head to get to my A$$ doing it. So I would venture to guess I am still doing something wrong. Native drivers, I get an error with though. It is unable to verify the connection. I tried to go into the control panel to do it and got the message "Specified driver could not be loaded due to system error odbc 126(Merant 3.70 ColdFusion OEM 32-bit Oracle8)" Anyone have any suggestions? I can connect using my sql soft application just fine, and MS oracle 8. However I have stored procs and triggers and such, don't I have to use native for these?
At 04:49 PM 3/19/2002 -0600, you wrote: >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] > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists