Connecting to an Oracle Database Using VB.NET Application

I am working on a VB.NET application that has a function where it connects to an Oracle database and collects data using different queries.

The program is working fine. My question is, is it possible to manage such an application without ODBC, Oracle Instant Client or TNSNames.ora?

He needed to work on as many as 50 machines, and it would be a real pain ... to install these drivers / software on each computer. This is my first Windows application before I use Java only for my projects. Therefore, I am very unfamiliar with him.

I read something about the fact that I need to refer to the corresponding DLL files in my .NET project, so the end user does not need to worry about any other program next to the main one. If this is true, can someone tell me which files the dlls need and where to get them? I tried to use the dll files from the ODTwithODAC installation, but Visual Studio does not allow me to reference them.

PS: Go easy on me, English is not my native language.

+4
source share
1 answer

Managed driver is ODP.Net and do not forget to set copyLocal = true in the link properties, or the link cannot be copied after publishing and installing the application on another computer.

+1
source

Source: https://habr.com/ru/post/1680204/


All Articles