MxODBC provides an easy to use, high-performance, reliable and robust interface to ODBC compatible databases such as,,, and, and,,,,, and many more. It is an extension to our open-source. ODBC refers to and is the industry standard API for connecting applications to databases. Python Unicode Version (UCS2 vs. UCS4) On Unix it is important to know whether you need to download a distribution for a narrow Unicode build of Python (UCS2) or a wide version (UCS4). MySQL Connector/ODBC (64-Bit) provides both driver-manager based and native interfaces to the MySQL database, with full support for MySQL functionality. In order to facilitate setting up ODBC connectivity, operating systems typically provide ODBC Managers which help set up the ODBC drivers and manage the binding of the applications against these drivers. On Windows the is built into the system. On Mac OS X, the is part of the OS, with an optional available as separate download. On Unix platforms, you can choose one of the ODBC managers, or, which provide the same ODBC functionality on most Unix systems. Databases usually ship with ODBC drivers for Windows, so it's easy to get Python connected to a database on Windows. If you are working on Linux and Mac OS X, you can typically download drivers from the database vendor. If you have trouble finding a database driver for your platform, try the (), or have a look at our mxODBC Connect product: If you are looking for a platform independent remote database connectivity solution for Python, you may be interested in our product, which eliminates the need to have an ODBC driver for the client side of the application. It specializes on remote database connections such as the ones you typically find in web-applications, e.g. Where multiple Linux servers need to communicate with a company database running on a Windows server. • Python Database API 2.0 Compliance: the mxODBC API is fully compatible and implements a large number of powerful extensions. • Support for all recent ODBC Versions: mxODBC works with ODBC drivers implementing the ODBC version specifications 2.0 - 3.8. • Uses ODBC 3 APIs: provided the ODBC driver is capable of using ODBC 3 APIs, mxODBC will use them for added efficiency. • 32-bit and 64-bit ODBC: mxODBC supports both 32-bit and 64-bit versions of the ODBC standard on all supported platforms. • Support for all popular ODBC Drivers: mxODBC includes adjustments and work-arounds to support MS SQL Server Native Client (both on Windows and Linux), MS SQL Server Native Client ODBC Driver, FreeTDS ODBC Driver, Oracle Instant Client ODBC Driver, IBM DB2 ODBC Driver, Sybase ASE ODBC Driver, Netezza ODBC Driver, Teradata ODBC Driver, PostgreSQL ODBC Driver, MySQL ODBC Driver, MariaDB ODBC Driver, MaxDB ODBC Driver as well as the ODBC driver sets of EasySoft, DataDirect, OpenLink, Actual Technologies. • Support for all popular ODBC Driver Managers: mxODBC comes with subpackages for the native Windows and Mac OS X ODBC managers, as well as the ODBC managers, and, which are commonly used on Unix systems. • Stable, robust and reliable: the mxODBC API has been in active production use for more than 15 years. • ODBC Catalog & Introspection Functions: mxODBC Client API provides methods e.g. To list tables, find column specifications, query index relationships, etc. • Stored Procedure / Function Calls: directly call stored procedures and functions, using output and input/output parameters, as well as result sets for passing back data to Python. This gives you full access to your database systems from Python, without any need to adapt database APIs. • Support for Input, Ouput and In/Out Parameters: you can freely use these parameter types in stored procedure calls, functions calls and regular SQL statement execution, allowing you to tap into all the flexibility your databases have to offer. • Support for Multiple Result Sets: call stored procedures and access all returned result sets using an easy to API. Easily free up resources in case result sets are no longer needed. • Support for custom Row objects: in addition to using standard Python tuples, mxODBC can automatically return result set rows as custom objects. MxODBC comes with a set of optimized row factories for: TupleRows, ListRows and NamespaceRows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2018
Categories |