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 > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
