The error message you displayed tells me that your TNSNames.ora file is not right.
Dave ----- Original Message ----- From: "Simon Whittaker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 11:55 AM Subject: Re: Oracle Help > hi there, > I have been working on this all day and am still getting errors - I can > connect using sqlplus in solaris without problems but cannot connect > through cfadministrator - I tried a page to sdee if it would work even > though it was failaing connectivity but with no joy. Error code is below: > > ORA-12154: TNS:could not resolve service name > > > I am not sure what this means but I presume that it is at least seeing > Oracle (therefore it is setup correctly). > > I hope someone can help > > Cheers > > Simon > > > > ----- Original Message ----- > From: "Dave Hannum" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 01, 2001 12:25 PM > Subject: Re: Oracle Help > > > > Dumb question, but, are you sure you have the username and password > correct > > in CFAdministrator. Also, do you have something like Oracle DBA Studio or > > Enterprise Manager that you can connect with? If so, the problem is with > > your CF Administrator settings. If not, then check the TNSNames.ora file. > > Also, are you trying to use ODBC or the Native Drivers. If you are using > > ODBC, be sure and use the "Microsoft ODBC for Oracle" drivers. > > > > Dave > > > > > > ----- Original Message ----- > > From: "Tony Schreiber" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, October 31, 2001 11:47 PM > > Subject: Re: Oracle Help > > > > > > > On my CF5/Win2k machine with Oracle 8.0.5 client, my CF administrator > says > > > not verified - but the datasource works just fine... > > > > > > > I need some help with Oracle - I am not able to connect to my oracle > > dbase > > > > from within cf administrator - it simply gives the not verified > message. > > The > > > > trouble is I am not entirely sure what the host string is supposed to > > look > > > > like in the input box - is it dbasename/username@hostname or nothing > > like > > > > the above? I hope someone can help with this. > > > > > > > > > > > > Cheers > > > > > > > > Simon > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
