Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and reconnect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The connection manager establishes a direct connection between the interface module and the port module by determining which port modules are associated with each data source and storing a data source identifier in a data structure. The connection manager also identifies each port module by a port module identifier and storing the port module identifier in a data structure. The connection manager returns a port module identifier for an available port module to the interface module for directly connecting the interface module and the port module and thus the data source.

Abstract: The invention provides management of requested data files, such as large object binary files (LOBs), to maximize storage space. An interface module provides translation between a requesting application and a database containing the data files. The interface module stores requested data files in a temporary directory which is accessible by the requesting application. The interface module further generates or duplicates data file names corresponding to each data file. The data file names are sent to a clean module where the data file names are placed in a data structure. The clean module includes a timing module which generates time stamps for each data file name. The time stamps reflect the time of receipt for each data file name and are stored in association with their respective data file names. The clean module further includes a delete module which reviews the time stamps to determine if a preestablished time delay has passed.

Abstract: The present invention provides a system and method for providing nesting Structured Query Language (SQL) functions. The method includes: calling a first SQL function; processing a first result table for the first SQL function; determining that the first result able comprises a second SQL function; calling the second SQL function; processing a second result table of the second SQL function; returning a result for the second SQL function; resuming processing of the first result table; and returning a result for the first SQL function. The method and system allows a Net.Data™ system to call SQL functions from within a result table of another SQL function. The level of nesting is maintained for an array of SQL statement handles to ensure that the proper handles are used. In this manner, auxiliary tables are not required, simplifying the programming of Net.Data™ queries and decreasing memory overhead.

Abstract: A method and system for retrieving data from a database over a network includes: generating an executable statement at a gateway in accordance with a macro language file, where the executable statement comprises one or more a parameter markers; passing the executable statement from the gateway to database software; and passing a value for each parameter marker from the gateway to the database software. The present invention allows the Net.Data gateway to support parameter markers in place of Net.Data variables. This allows the Net.Data gateway to take advantage of the dynamic Structured Query Language (SQL) statement caching feature available with conventional database systems. With the use of this invention, the execution of the SQL statements occurs more rapidly, saving resources and improving performance. Additionally, the Net.Data variables may be automatically replaced with parameter markers, with the Net.Data variables and their values maintained. This provides transparent support for parameter markers.

Abstract: The present invention provides a system and method for providing nesting Structured Query Language (SQL) functions. The method includes: calling a first SQL function; processing a first result table for the first SQL function; determining that the first result able comprises a second SQL function; calling the second SQL function; processing a second result table of the second SQL function; returning a result for the second SQL function; resuming processing of the first result table; and returning a result for the first SQL function. The method and system allows a Net.Data system to call SQL functions from within a result table of another SQL function. The level of nesting is maintained for an array of SQL statement handles to ensure that the proper handles are used. In this manner, auxiliary tables are not required, simplifying the programming of Net.Data queries and decreasing memory overhead.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source, to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The port module detects the unavailability of the data source in response to an initial request for the data source by the remote application. The port module may then dynamically detect the availability of the data source in response to a subsequent request for the data source and re-connect to the data source to the remote application in response to the subsequent request without having to reinitialize the connection manager.

Abstract: The invention provides for the connection of a plurality of remote applications with a data source and identifying a status corresponding to interactions between a remote application and a data source to maximize the speed and reliability of data transfer. An interface module interfaces with a remote application such as a web browser. A port module interfaces between interface module and a data source. A connection manager facilitates the interface between the interface module and the port module. The remote application may selectively establish an arbitrary set of user-selectable parameters to reflect a status of a connection between the remote application and the data source.