C# oracle application can't working on client PC

Question

0.00/5 (No votes)

See more:

Hello my problem is that i have developed C# application with telerik UI and oracle database and create msi package using visual studio 2017 and dot net framework 4.6.1,
my connection string is working properly.
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 properly because i can not access application data.. what is the solution for this problem, thanks

What I have tried:

I tried it on many pc in WLAN but it can't work, but when i install it on those pc's in WLAN which have oracle database installed , it works fine for me,

Posted 20-Sep-19 0:14am

Member 14330485

Updated 20-Sep-19 1:35am

Add a Solution

Comments

F-ES Sitecore 20-Sep-19 6:56am

Is the app using a shared Oracle database on a server, or does each client need Oracle installed locally?

Member 14330485 20-Sep-19 7:29am

I think each client need oracle client,what will be the solution?

F-ES Sitecore 20-Sep-19 7:34am

You can't install Oracle on the client machine. If each machine needs a database then use a database engine you can distribute (both technically and legally). That alternative is that they all connect to the same instance of Oracle that you have installed somewhere.

Dave Kreskowiak 20-Sep-19 9:19am

Yes, you must install the Oracle Client on the client machine in order for the application to touch an Oracle database.

Which Oracle provider are you using in your app? If it's the classes found in System.Data.OracleClient namespace, you're using a provider that has been deprecated for quite some time. Drop using that and use the provider provided by Oracle in their ODP.NET package.

As for the connectivity, if you're Oracle database is in one network and the clients are in a completely separate network, with no route between those networks, your clients will not be able to get to the database.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2019-09-20T01:35:00

Quote:
....my connection string is working properly.¹⁾
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 properly²⁾ 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!