Re: ora-12203 can't connect from form builder to local database

> Many people install a database server and various client software into
> different ORACLE_HOMEs (usually because it's necessary). Then they set
> up the Oracle Networking stuff for the ORACLE_HOME related to the
> server, but totally forget that the client software has a completely
> independant set of Oracle Networking configuration in the client's
> ORACLE_HOME.
I configured files mentioned earlier using some short how-to especially for it, but not for 9i and XP Professional (8i and 98), but it deosn't work. I looked in Oracle9i Net Services Administrator's Guide.pdf and Oracle9i Net Services Reference Guide.pdf, I tried google tips, I've been trying to solve this problem for 3 days now and I'm beginning to feel frustrated:(

what is the most freaky thing is that when I run from developer Net8 Easy Config (E:\dev\BIN\N8SW.EXE), change in the first window network configuration directory from E:\oracle\NET80\ADMIN\ to E:\dev\NET80\ADMIN\ and then tested the service it worked fine!!! so maybe it's something about editing registry entries....

when I do C:\Documents and Settings\jacek>e:\oracle\bin\TNSPING.EXE jac Using
E:\oracle\network\admin\sqlnet.ora
using TNSNAMES adapter for this alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP )(HOST = 127.0.0.1)(PORT = 1526))) (CONNECT_DATA = (SERVICE_NAME = jac) (SID = jac)))
OK (110 ms)

but when trying C:\Documents and Settings\jacek>e:\dev\BIN\TNSPING80.EXE jac
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)) TNS-12538: TNS:no such protocol adapter

--
best regards, jacek