![]() ![]() ![]() Python tuples, mxODBC can automatically return result set rows asĬustom objects. Support for custom Row objects: in addition to using standard.Resources in case result sets are no longer needed. Support for Multiple Result Sets: call stored procedures and accessĪll returned result sets using an easy to API.Procedure calls, functions calls and regular SQL statement execution,Īllowing you to tap into all the flexibility your databases have to Support for Input, Ouput and In/Out Parameters: you canįreely use these parameter types in stored.This gives you fullĪccess to your database systems from Python, without any need to adapt Well as result sets for passing back data to Python. Stored Procedure / Function Calls: directly call stored procedures and functions, using output and input/output parameters, as.to list tables, find column specifications, query index relationships, etc. ![]() ODBC Catalog & Introspection Functions: mxODBC Client API provides methods e.g.Stable, robust and reliable: the mxODBC API has been in active production use for more than 15 years.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 unixODBC, iODBC and DataDirect, which are commonly used on Unix systems.Of EasySoft, DataDirect, OpenLink, Actual Technologies. MySQL ODBC Driver, MariaDB ODBC Driver, MaxDB ODBC Driver as well as the ODBC driver sets Netezza ODBC Driver, Teradata ODBC Driver, PostgreSQL ODBC Driver, Includes adjustments and work-arounds to support MS SQL Server NativeĬlient (both on Windows and Linux), MS SQL Server Native Client ODBC Driver, FreeTDS ODBC Driver, Oracle InstantĬlient ODBC Driver, IBM DB2 ODBC Driver, Sybase ASE ODBC Driver, Support for all popular ODBC Drivers: mxODBC.32-bit and 64-bit ODBC: mxODBC supports both 32-bit and 64-bit versions of the ODBC standard on all supported platforms.Uses ODBC 3 APIs: provided the ODBC driver is capable of using ODBC 3 APIs, mxODBC will use them for added efficiency.Support for all recent ODBC Versions: mxODBC works with ODBC drivers implementing the ODBC version specifications 2.0 - 3.8.Python Database API 2.0 Compliance: the mxODBC API is fully Python DB-API 2.0 (PEP 249) compatible and implements a large number of powerful extensions.Servers need to communicate with a company database running on a Ones you typically find in web-applications, e.g. It specializes on remote database connections such as the Product, which eliminates the need to have an ODBC driver for the client side of the application. If you are looking for a platform independent remote databaseĬonnectivity solution for Python, you may be interested in our If you have trouble finding aĭatabase driver for your platform, try the ODBC vendor list on ( web archive copy), or have a look at our mxODBC Connect product: OS X, you can typically download drivers from the database vendor. On Unix platforms, you can choose one of the ODBC managers unixODBC, iODBC or DataDirect, which provide the same ODBC functionality on most Unix systems.ĭatabases usually ship with ODBC drivers for Windows, so it'sĮasy to get Python connected to a database on Windows. On Mac OS X, the iODBC ODBC Manager is part of the OS, with an optional ODBC manager GUI available as separate download. On Windows the ODBC Data Source Manager is built into the ODBC drivers and manage the binding of the applications against theseĭrivers. Operating systems typically provide ODBC Managers which help set up the In order to facilitate setting up ODBC connectivity, ![]() ODBC refers to Open Database ConnectivityĪnd is the industry standard API for connecting applications to It is an extension to our open-source mx Base Distribution. MxODBC ™ provides an easy to use, high-performance, reliable and robust Python interface to ODBC compatible databases such as MS SQL Server, Oracle Database, IBM DB2, Informix and Netezza, SAP Sybase ASE and Sybase Anywhere, Teradata, MySQL, MariaDB, PostgreSQL, SAP MaxDB and many more. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |