Gord Thompson

Access.Application.Run with Sub argument works with Python2 but not with Python3

6

[pythonnetTest.zip](https://github.com/pythonnet/pythonnet/files/1253942/pythonnetTest.zip) pythonnet 2.3.0 Python 2.7.13, 32-bit Python 3.6.2, 32-bit Microsoft Access 2013, 32-bit Windows 10 The attached Access database file contains a Module with a Sub that takes an argument...

pyodbc.Binary - Is it something a user would normally need to use?

1

In the Stack Overflow question [here](https://stackoverflow.com/q/52458374/2144390) the user is attempting to use a `pyodbc.Binary` object. My answer to the question shows that there is no need to use that object...

Deciphering SQL_VARIANT values

7

A question on Stack Overflow regarding pyodbc and SQL_VARIANT got me curious to see if an output converter function might be feasible. I confirmed that, without an output converter function,...

request: consistent handling of timezone-aware `datetime` parameter values (with datetimeoffset columns)

4

Further to #134, and related to https://github.com/pandas-dev/pandas/issues/30884 I'm adding this as a "wish list" item. Python version 3.8.5 (tags/v3.8.5:580fbb0, Jul 20 2020, 15:43:08) [MSC v.1926 32 bit (Intel)] pyodbc version...

Add support for changing the current catalog via Connection#set_attr

1

The Python DB API makes no mention of changing the current catalog. However, `System.Data.Odbc` in .NET has a `Connection#ChangeDatabase` method and ```csharp cnxn.ChangeDatabase("master") ``` results in ``` OdbcConsoleApp. 2414-2578 EXIT...

Improve has_table function in mysql dialect

4

https://github.com/sqlalchemy/sqlalchemy/blob/660a340bff8fcefd2826032e75210c0924a2335e/lib/sqlalchemy/dialects/mysql/base.py#L2484-L2489 This is in fact not an issue on Windows: ``` python connection_uri = "mysql+pymysql://root:toot@localhost:3307/mydb?charset=utf8mb4" engine = sa.create_engine(connection_uri) # ... print(platform.system()) # Windows table_name = "γιορτή" with engine.connect() as conn:...

Dependabot updates have upgraded several packages that do not work with Python 3.6 (via Debian Jessie). Upgrading the test environment to use Debian Buster resolves the issue.

Fixes: #365 ## What do these changes do? Update the test environment to work with the current versions of required packages. ## Are there changes in behavior for the user?...

Time for 4.0.35?

1

According to https://pypistats.org/packages/pyodbc , 4.0.34 has been downloaded more than 20 million times in the last 30 days, and 98%+ of those downloads are for Linux. IMO, we really should...

Avoid NPE with parameter value None

1

Fixes: #244 Possibly fixes: #57