OpenX for Sybase ASE/ASA 2.0

OpenX component is a set of high-performance software interfaces for data access that provides universal data integration over an enterprises network.
If youre building database driven desktop application or web site, you can use its power to programmatically access and manipulate data by writing only few strings of code.
Its application-level database-programming interface allows enterprise programmers to write applications from any OLE-compliant language, including C#, C/C++, JScript, Java, Visual Basic, and VBScript.
OpenX is the fastest way to interact with RDBMS, because it makes direct calls to vendors native database APIs, thus eliminating need in all possible intermediate layers such as ODBC/ADO. Its designed and optimized to achieve maximum performance under heavy load.
Thinking of upgrading your RDBMS?
Moving to another RDBMS vendor?
OpenX protects your investment by supporting all major database vendors on the most popular operating systems.
OpenX is a tool that works with SQL Server, Oracle, DB2, Informix, Sybase, InterBase, Centura SQLBase, MySQL, and ODBC.
OpenX is the fastest way to connect to RDBMS, because it makes direct calls to vendors native database APIs, thus eliminating need in all possible intermediate layers such as ODBC/OLEDB.
Main features:
- Cursor emulation and memory conservation - While emulating cursors, OpenX doesnt saves result sets in its memory buffer. It fetches row by row from SQL servers memory buffers instead. This technique is highly optimized, and aimed to scroll read-only records in a forward-only manner. Such method saves memory on machine where OpenXs instance was created.
- Connection behavior - One of important OpenX features is protected connection. OpenX wont crash or raise ASP error if network or SQL server problem occurs. Also, it may happen if somebody kills OpenX process on SQL server. ErrorCode will return "-9999999" in that case. Executing Disconnect() and after that Connect(), will return OpenX to normal state.
- isEmpty property behavior - Calling isEmpty after Execute() has the side effect of moving the cursor to the first row of the result set (if any).
We recommend using "do ... while ( MoveNext() )" in that case.
- Processing HTML Forms and Uploading Files (OpenX ASP Edition only) - This feature of OpenX greatly simplifies HTML Form processing and File uploading procedures. Only few strings of code needed to validate posted HTML Form and save its data into the database. If this form includes one or more tags, the files will be received by OpenX and stored onto servers hard drive or saved right into the database. Only one submit button is required for a form containing any combination of HTML form elements plus the upload file elements.
OpenX provides all the functionalty of standard File uploading components: it will show the type of file, its extention and size, aggregate amount of bytes transferred during given upload session, and will allow you controlling the overwrite switch and the size of uploads.
OpenX will validate posted HTML forms, ensure that all mandatory fields are filled properly, and even check the validity of email addresses and credit card numbers.