ClickOnce Deployment Question

Hi,

Back-End/Database: Oracle 10g
Front-End: Visual Basic.Net 2005
Server PC: Windows 2000/NT
Server PC Computer Name: myserver
Client PC: Windows XP

I'm having problems running the application on a client pc. Let's say that the XP PC is brand new. No setup has been done. This is the first time it's gonna be used to run the application on the server pc.

Here is a step by step of what i did.
1. On the Server PC, I published my application using ClickOnce using all default options.
2. To test the application, on the server pc I opened Internet Explorer, typed http://myserver/myappdir/Publish.html.
3. I then click RUN and the application appears.
4. I log in using my username and password. Everything is OK.

Now I got to the Client PC.
1. I opened Internet Explorer, typed http://myserver/myappdir/Publish.html.
2. I then click RUN and the application appears.
3. I log in using my username and password. I get a TNS Error. TNS could not be resolved.

I'm not sure what's causing this. Can anyone help. THanks.

I figured out a way to fix this but I'm not sure if its a good solution though.

What I did was install ODP.Net on the Client PC and Manually Configured the TNSNAMES.ORA. It worked after that but its not what I had in mind.

I was thinking of something that kinda plug and play. For example, I get a new computer, then connect it to the network then browse http://myserver/myappdir/Publish.html. Then run it from there and then everything will be automatic. Meaning it will install files that are need like the .Net 2.0, etc... is there anyway i could do this?

thanks...