ODBC connections may disconnect due to various reasons, including network instability, server timeouts, or improper configuration settings. Additionally, if the database server experiences high load or resource constraints, it may terminate idle connections to free up resources. Client-side issues, such as application crashes or network interruptions, can also lead to disconnections. To mitigate this, maintaining proper connection pooling and timeout settings can help.
Employ the ODBC code or module written for whatever language you're writing in. Or, alternatively, write your own ODBC code.
ODBC and SQL operate at Session Layer.
In tally ODBC is used to connect to other programs and exchange data dynamically
To use ODBC with Tally 9, first ensure that you have the ODBC Driver installed and configured for Tally. Next, enable ODBC in Tally by going to the Gateway of Tally, selecting "F12: Configure," and then "Advanced Configuration" to set ODBC Server to 'Yes.' Once configured, you can connect to Tally’s database through an ODBC-compliant application, allowing you to fetch and manipulate data from Tally using SQL queries. Make sure Tally is running in the background while accessing it via ODBC.
Alongside dedicated ODBC drivers, a JDCB driver is usually required. This enables a bridge to the ODBC driver, enabling the database to connect to its target.
JDBC - ODBC bridge
ODBC provides an open, vendor- neutral way of accessing data stored in a variety of proprietary personal computer, minicomputer, and mainframe databases. ODBC alleviates the need for independent software vendors and corporate developers to learn multiple application programming interfaces. ODBC now provides a universal data access interface. With ODBC, application developers can allow an application to concurrently access, view, and modify data from multiple, diverse databases.
Is there an ODBC driver available for your Oracle database? If so, the ODBC functions may be the way to go.
Robert Gryphon has written: 'Using ODBC 2' -- subject(s): Database management, Microsoft ODBC
i guess
Open Database Connectivity
Value by value