OpenX for MS SQL Server

OpenX component is a set of high-performance software interfaces for data access that provides universal data integration over an enterprise's network. If you're 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 vendor's native database APIs, thus eliminating need in all possible intermediate layers such as ODBC/ADO. It's 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 vendor's native database APIs, thus eliminating need in all possible intermediate layers such as ODBC/OLEDB.

Here are some key features of "OpenX for Sybase ASE ASA":

· Cursor emulation and memory conservation - While emulating cursors, OpenX doesn't saves result sets in it's memory buffer. It fetches row by row from SQL server's 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 OpenX's instance was created. · Connection behavior - One of important OpenX features is protected connection. OpenX won't 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 server's 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.

Requirements:

· Pentium Processor based system (Pentium III 500MHz or higher recommended) · 128Mb RAM (256 or more recommended) [dllhost.exe running OpenX2 component consumes about 2-7Mb of RAM while idle. One thousand concurrent idle OpenX instances will consume about 14Mb of RAM. These values may vary when OpenX is not idle.] · Windows NT 4.0 SP6 or Windows 2000 SP1/SP2. · Microsoft IIS 4 or 5 for OpenX ASP Edition

Limitations:

· demo with result set limited to 5 rows of data