![]() While this tutorial uses a simple code sample to connect and demonstrate basic operations, we recommend that you fully test your ODBC driver with the complete set of operations you expect to use in your production application. We've also provided a code sample demonstrating a connection to Microsoft SQL Server using the Python ODBC interface via the Progress DataDirect Connect64 for ODBC SQL Server Wire Protocol driver. Once a connection has been established, your application can execute selects, inserts, or other ODBC operations supported by your driver and database.īelow, we provide a tutorial to show you how to install a DataDirect ODBC driver, Python, and pyodbc. The ODBC driver manager and driver will connect, typically over a network, to the database server.įor more information on pyodbc, see the Github Pyodbc Wiki. The ODBC driver manager is platform-specific, while the ODBC driver is database-specific. Using pyodbc, you can easily connect Python applications to data sources with an ODBC driver.Īs with other application stacks connecting through the ODBC API, the application-in this case your Python code along with the pyodbc module-will use an ODBC driver manager and ODBC driver. It implements the DB API 2.0 specification. Pyodbc is an open source Python module that makes accessing ODBC databases simple. It was created by Guido van Rossum and first released in 1991. Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language.
0 Comments
Leave a Reply. |