XML-ODBC Server
The Easysoft XML-ODBC Server allows client applications to access databases that support ODBC by using XML requests over TCP/IP. Supported databases include Microsoft SQL Server, Microsoft Access, Oracle, InterBase, and IBM DB2.
The XML-ODBC Server listens for XML requests from clients that specify an ODBC data source to connect to, the user name and password for the target database, and the SQL to execute. If the SQL generates a result set, it is also returned to the client in XML.
Client applications can be developed in any language and for any device with TCP/IP support.
The XML-ODBC Server is a multi-threaded, high-performance service available on Windows, Linux, and UNIX platforms. In addition, the XML-ODBC Server:
- Supports ODBC 2–3.51 drivers.
- Supports unixODBC, the open-source ODBC Driver Manager, which is included with the distribution on non-Windows platforms.
- Does not require additional client software. TCP/IP networking and a small amount of socket code in any language are all that is required.
- Does not have to be installed on the database server. The target database can be hosted on the same server as the XML-ODBC Server or on any remote platform accessible with ODBC.
- Lets you update, insert, or query local and remote ODBC data sources by using simple XML requests.
- Supports multiple XML output formats that let you choose the format of XML result sets. For example, XML result sets formatted with the TableTags format are suitable for importing into Microsoft Office applications.
- Lets you output column data as either CDATA or PCDATA.
- Lets you format XML output by associating a style sheet with the output.
- Includes sample code, working objects, classes, and modules for C, Perl, PHP, Python, Java, and Visual Basic.
- Includes sample SAX-based parsing of XML output in PHP and Perl and an example XSLT application for Perl that shows how to transform XML output to HTML.
- Supports any SQL that is valid for the target ODBC database engine, including transaction and stored procedure support.
- Accepts requests containing multiple SQL statements, enabling a series of updates, inserts, or deletes to be executed as part of a single transaction.
- Provides full Unicode UTF-16 support for Unicode data sources. This ensures data is accurately output as UTF-8 in the result set.
- Supports access control lists that let you protect access to the XML-ODBC Server.
- Lets you configure the XML-ODBC Server remotely by sending configuration requests from a client application to a control port.
- Supports access control lists that let you protect access to the control port.
Platforms
The XML-ODBC Server is currently available on these platforms:
| Version | Platform | Distribution |
|---|---|---|
| v1.1 | FreeBSD (x86) (32 - Bit) | (4.2) |
| v1.1 | Linux (x86) (32 - Bit) | (kernel 2.2-2.4, glibc 2.1.x) |
| v1.1 | Windows (x86) (32 - Bit) | (NT4, 2000, XP, 2003) |
