Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Visual Basic connection to Oracle Personal 8i
I have the same problem as his. When I use Net8 to config the
connection, I get the error:
ORA-12500:TNS:listener failed to start a dedicated server process
In file tnsnames.ora is the following:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(SOURCE_ROUTE = OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
In file listener.ora is the following:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =
(PRESENTATION = TTC) (SESSION = NS) )
(PRESENTATION = TTC) (SESSION = NS) )
(PRESENTATION = GIOP) (SESSION = RAW) )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
In article <3A362565.F6299339_at_Unforgetable.com>, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> Jim wrote: > > > Hello everyone: > > > > I've just installed Oracle 8i Personal version and want to connectto the
> > ora-12154 . TNS:Could not resolve service name. > > Error in initializing provider ora-12560. Etc.... > > > > I've been trying to use Net8 but no luck. > > > > Thanks for any help you can give me! > > What method of connection are you trying to use? ODBC? OLEDB? RDO?DAO?
> sucessfully creating a service name via Net8. > >
Sent via Deja.com
http://www.deja.com/
Received on Sun Dec 24 2000 - 16:22:58 CST