( Registration required.)įor example, if want to access SQL Server from Python, download the Easysoft ODBC-SQL Server Driver for your Python platform.
#64 BIT ODBC MANAGER INSTALL#
To use pyodbc, you need to install an ODBC driver on the machine Python where is installed: On Debian, we used Python 2.4.4, the python2.4-dev package and the g++ package. On Ubuntu, we used Python 2.5.1 and Python 3.2.3, the python-dev package and the g++ package. When testing on RedHat, we used Python 2.5.1, the python-devel package and the gcc-c++ package. To build pyodbc, you need the Python libraries and header files, and a C++ compiler. The pyodbc module requires Python 2.4 or greater (see README.txt, which is included with the pyodbc distribution). pyodbc and LinuxĮasysoft ODBC drivers have been tested with pyodbc 2.0+, 2.1+, 3.0+, 4.0+ on RedHat, Ubuntu and Debian GNU/Linux, but should work with any recent 32-bit or 64-bit Linux distribution - CentOS, Fedora, Kubuntu, Mandrake/Mandriva, OpenSUSE/SUSE, RedHat Enterprise Linux (RHEL), Slackware and so on.
You can then connect Python on Linux and Unix to remote database such as Microsoft SQL Server, Oracle®, DB2, Microsoft Access, Sybase ASE and InterBase.
#64 BIT ODBC MANAGER HOW TO#
This tutorial shows how to use pyodbc with an ODBC driver, which you can download from this site. Pyodbc is a Python DB conformant module for ODBC databases. This helps developers to write Python applications that are portable across databases. Python DB was designed to allow conformant modules to provide a consistent interface to different database products. The Python DB API defines a database-neutral interface to data stored in relational databases. pyodbc implements the Python DB API 2.0 specification. Pyodbc is an open source Python module that provides access to ODBC databases. To connect Microsoft Access or any other remote ODBC database to Python, use pyodbc with the ODBC-ODBC Bridge. To connect Sybase ASE to Python running on Solaris, HP-UX or Linux, use pyodbc with the Sybase ODBC Driver.
To connect DB2 to Python, use pyodbc with the DB2 ODBC Driver. To connect MongoDB to Python, use pyodbc with the MongoDB ODBC Driver. To connect Oracle® to Python, use pyodbc with the Oracle® ODBC Driver. To connect Microsoft SQL Server to Python running on Unix or Linux, use pyodbc with the SQL Server ODBC Driver or ODBC-ODBC Bridge (OOB).
0 kommentar(er)
