connection to SQL/Plus OK, Web forms not!

OK - being new to most of this Oracle web stuff, please forgive the following:

I have recently installed Oracle 10g and 10gAS onto a W2K server. Everything seems OK - I can access the database from SQL+ and iSQL as well as view the demo Form accross the WEB on both ports 80 and 7778.

However, when I try to create my own Form, although it works (in that I don't get a URL error) I am prompted for a connection string. When I supply the connection string as from SQL+ it raises ORA-12154 : TNS couldn't resolve service name, and if I leave the Database out of the connection string (not an issue in iSQL) it (understandabily) raises ORA-12560: TNS protocal adapter error.

I have scanned the supplied documentation and many of the Oracle forums but as yet have not seen the answer I require.

And help is welcome - I'm assuming I have missed a few installation steps but am unsure where!

Thanks in advance.

Create the alias to connect to ur database in the forms also.That option u will get in the program folder of ur forms.Click on NEt Configuration assistant.And add a new service to connect to ur db ..
Hope this helps...

I have looked at both Net Manager and Net Confiruration Assistant, even tried manually editing both the TNSNAMES (database and Apps Server) but with no luck.

Have added and removed listener on the default posts 1521, 7778 as well as adding a IPC service....

Not enjoying this the moment - perhaps I should write to Larry and suggest he rethink this Web stuff and return to Client Server (it was so much simpler then (and it worked!))

Thanks anyway.