Benthic Software Blog

Tips for using Oracle and our products

Golden remote/home install and use tips

March 20, 2020

All of our products work very well in a remote "working from home" environment. Our Oracle specific products have no other dependencies beyond a working Oracle Client. This blog post outlines installing on a home machine and includes several tips for usage that will increase performance on metered or low bandwith connections. Read more.

Connecting to an Oracle Database

January 28, 2019

Almost all client applications that need to use an Oracle database will have a login window of some type. Usually they will ask for a Username, a Password, and have a field labeled "Database" or "Server". This field generally causes the most trouble because it can be used in a number of different ways depending on your Oracle Client and configuration... Read more.

Introduction to the Oracle Client on Windows

January 28, 2019

The Oracle Client is what connects your applications with your database. Almost all client side applications use it. Generally applications will either use the Oracle Client directly (such as our SQL tool Golden) or will use a connectivity option such as ODBC, OLEDB, .Net, JDBC, etc, which use the Oracle Client "under the hood"... Read more.

How the Oracle Client finds TNSNames.ora

January 28, 2019

Most Oracle Client installs use a TNSNames.ora file. This allows users to enter a database alias in client programs to connect to an Oracle database. A common problem is when the Oracle Client either can't find the TNSNames.ora file or is using a different one than was intended... Read more.

Oracle Date Format Errors and Tips

January 28, 2019

What is a date literal? A date literal is a string that represents a date. Another way to say this is that a date literal is a string that Oracle needs to convert to a date to work with... Read more.