Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Form cannot connect to database
It would be very helpfull if you could say what goes wrong. What is the
error you are getting.
The tnsnames.ora file looks ok on first sight.
Maybe your listener is not running? Check listener.ora and see if the
listener service is started on host dell8100.
Jingyu <ccdfjy_at_hotmail.com> schreef in berichtnieuws
e5c3e808.0301281243.66b38cd2_at_posting.google.com...
| Used Form builder to create a form to query a database. Basically, I
| have two questions.
| 1. When I create a form, I can connect to the database by setting
| default oracle_sid = jingyu (database name). However, if I try to
| connect the database by provide username, password, database= jingyu,
| I will not be able to connect it.
|
| 2. After I finish the form design, I tried to run it. Then it will
| ask me again to connect to the database. I provide the same
| information, but it will not work.
|
| Hope this file will hope!
|
| C:\oracle\ora92\network\admin\tnsnames.ora
| # Generated by Oracle configuration tools.
|
| INST1_HTTP =
| (DESCRIPTION =
| (ADDRESS_LIST =
| (ADDRESS = (PROTOCOL = TCP)(HOST = dell8100)(PORT = 1521))
| )
| (CONNECT_DATA =
| (SERVER = SHARED)
| (SERVICE_NAME = MODOSE)
| (PRESENTATION = http://HRService)
| )
| )
|
| EXTPROC_CONNECTION_DATA =
| (DESCRIPTION =
| (ADDRESS_LIST =
| (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
| )
| (CONNECT_DATA =
| (SID = PLSExtProc)
| (PRESENTATION = RO)
| )
| )
|
| JINGYU =
| (DESCRIPTION =
| (ADDRESS_LIST =
| (ADDRESS = (PROTOCOL = TCP)(HOST = dell8100)(PORT = 1521))
| )
| (CONNECT_DATA =
| (SERVER = DEDICATED)
| (SERVICE_NAME = Jingyu)
| )
| )
|
| Thanks for the help!
Received on Tue Jan 28 2003 - 14:50:12 CST