Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using ODBC
Start by running the following command on the same box:
sqlplus system/manager_at_your_service_name
My guess is that you don't have the Oracle Listener setup properly. If the above command connects then you should be OK.
If not you need to look at tnsnames.ora and listener.ora in $ORACLE_HOME/network/admin.
--Peter
Beebs wrote:
> I'm not sure if this is the proper group to post this to, but I desperately
> need help and searched for days on the web to no avail. Currently, I'm just
> trying to set up an ODBC connection to my Oracle 8i database on a single
> computer and I have no domain name. When I go through and use the Net8
> Assistant, set up a Names Server, make sure my Listener is configured
> properly, along with my Service Name, I keep getting the ODBC error:
>
> [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name
>
> I'm using the native Oracle ODBC driver in Windows 2000 and can't seem to
> figure out why I'm getting this error. Obviously I'm doing something wrong
> but have no clue where to even start looking. If someone out there has any
> idea what this is all about, or has a step-by-step tutorial as to how to set
> up a simple ODBC connection using Oracle 8i on just a single computer with
> no domain(I tried localhost, but even that didn't work), I'd very much
> appreciate it.
>
> Thank you,
> Aaron
>
>
Received on Fri Jun 27 2003 - 12:27:27 CDT