| ORA-12203 [message #66629] |
Thu, 12 September 2002 23:59  |
githa
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
Hi
I try to connect to oracle 8i database from ASP as
'Create the OraSession Object.
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
'Create the OraDatabase Object by opening a connection to Oracle.
Set OraDatabase = OraSession.DbOpenDatabase("", "SCOTT/TIGER",cint(0))
and I encountered the following error
Oracle Automation error '800a01b8'
Unable to make connection, ORA-12203: TNS:unable to connect to destination
How can I get out of it?
Thank you
Githa
|
|
|
|
| Re: ORA-12203 [message #66637 is a reply to message #66629] |
Fri, 20 September 2002 09:34  |
ram kumar
Messages: 113
Registered: August 2002
|
Senior Member |
|
|
hi
u need to specity the connect string also
SCOTT/TIGER@??????
?????=servie name to connect the database
regards
ram
|
|
|
|
| Re: ORA-12203 [message #66679 is a reply to message #66629] |
Sat, 12 October 2002 10:16 |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
You need to cahnge the following
'Create the OraSession Object.
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
|
|
|
| Re: ORA-12203 [message #67260 is a reply to message #66629] |
Fri, 12 March 2004 01:35 |
yannick
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
|
This error is sometimes due to the Oracle TNSlistener service. stop and restart this service. even windows show u that its up
|
|
|
|
| Re: ORA-12203 [message #67270 is a reply to message #67260] |
Thu, 25 March 2004 15:35 |
Soth
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
The problem is because when you go to Internet,
the site web install some programs on your computer
(without you knowing it). These programs block your acces to DataBase Oracle.
For solving this pregram, you can go to CONTROL PANEL
==> Add/Delete Programs : check in your lists and try to UNINSTALL somes programs which you suspect that you did not install. When you UNINSTALL, the UNINSTALL program will send you to web site for downloding the UNINSTALL PROGRAM.
Exemple:
- nCASEAdsUninstaller.exe
- nCASEUninstaller.exe
|
|
|
|
|
|
| Re: ORA-12203 [message #67524 is a reply to message #66629] |
Wed, 15 September 2004 00:05 |
Samir
Messages: 32
Registered: April 2002
|
Member |
|
|
i am getting the erroe TNS unable to connect to destination.
i have edited registry and change tnsnames.ora file.
at last i reload windows (not over write ) then problem get solved .
pl. give short problem solution.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
