Re: Interfacing with Oracle 8i
- From: "Tim Williams" <saxifrax at pacbell dot net>
- Date: Fri, 15 Jul 2005 10:54:36 -0700
Try opening a command prompt and typing "tnsping {yourTNSname}" (without the
braces)
That should tell you if your machine is set up correctly and will also show
you which parameter files are being used. Check your files have the
required entry.
Tim.
--
Tim Williams
Palo Alto, CA
"prepotency" <prepotency.1s7uyi_1121439993.1554@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:prepotency.1s7uyi_1121439993.1554@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I'm dealing with updating some old programs (vba) from an oracle server
> and then getting them to run and interface with our new mysql server.
> The problem is, I just can't get excel and access to interface with
> this oracle 8i service. Does anyone know anything about 8i or oracle
> in general when it comes to connecting to their odbc services? How can
> I get Oracle 8i ODBC Drivers working and connecting to the "CMSP"
> service on my network? It is not working and just says that "TNS could
> not resolve the connect identifier specified". However I now all the
> info is correct because we have other computers on the network that can
> connect to this service... help!
>
> G
>
>
> --
> prepotency
> ------------------------------------------------------------------------
> prepotency's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=24155
> View this thread: http://www.excelforum.com/showthread.php?threadid=387510
>
.
- References:
- Interfacing with Oracle 8i
- From: prepotency
- Interfacing with Oracle 8i
- Prev by Date: Re: Question About customized menu bar
- Next by Date: Re: How do I group data in an Excel Combo Box
- Previous by thread: Re: Interfacing with Oracle 8i
- Next by thread: Find next cloumn
- Index(es):
Relevant Pages
|
