Oracle DB Help Needed!

Question

I am developing a massive tracking system at work and while it was small we have been using Access, now that it is getting bigger we are migrating to Oracle(I know MySQL would be a much better option but it is all I have available to me) The application is built on NodeJS as an electron app so it will be distributable and must be installed on the users machine. that being said I am not familiar with Oracle DB connections and required drivers. Any help setting up the client application with all resources needed for an Oracle connection would be much appreciated.

Answer 1

Have a look if this helps
http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html

Answer 2

Download JDBC or ODBC drivers for your client program and apply them

Answer 3

So I will need to find out where the library im using which in this case is node-oracledb is looking for the driver. Will I need a 2015 Visual Studio distributable for windows platforms? And if so , im assuming I would include that in the program directory as well right?

Answer 4

Yeah, see if there is a JDBC or ODBC driver for Visual Studio and include it in the program directory.
Actually you can work with Oracle Database itself, too.
You can download Oracle Database 18 client to connect with your server. If you work for a company I assume that they have physical servers. Otherwise you can create virtual servers.

Answer 5

Instant Client is exactly what I was looking for. Ill give that a go. Thank you so much for the help.