Quote:
....my connection string is working properly.1)
but when i install its exe on client pc in local area network , its install fine and open but i think oracle data provider not working properly2) because i can not access application data..
Sorry, but you're wrong in both area.
1) Your connection string is proper only for the PC where Oracle database is installed.
2) Oracle data provider is working fine, but your connection string is wrong and Oracle server (installed on any PC in LAN) does not accept incomming connections.
All you have to do is to:
1) enable remote connections to Oracle server on PC in LAN. See:
4 Managing Network Connections[
^]
2) change connection string accordingly. See:
Oracle connection strings - ConnectionStrings.com[
^]
Note that that is good practice to store connection string in a config file.
Good luck!