pypyodbc
pypyodbc copied to clipboard
jiangwen365
A pure Python Cross Platform ODBC interface module
Removed the call to SQLSetConnectAttr that set SQL_ATTR_ACCESS_MODE every time connect() was called. Kept the call that sets SQL_ATTR_ACCESS_MODE only when the user specifies a read-only connection. My rationale for...
If i try to fetch data with the datatype number(5,2) i got error: ``` File "C:\Program Files (x86)\Python37-32\lib\site-packages\pypyodbc.py", line 608, in Decimal_cvt return Decimal(x) decimal.InvalidOperation: [] ``` This error happens...
```Python import pypyodbc pypyodbc.connection_timeout = 10 serverName = 'server' database = 'DB' username = 'user' password = 'pass' try: conn = pypyodbc.connect('DRIVER={ODBC Driver 13 for SQL Server};SERVER='+serverName+';DATABASE='+database+';UID='+username+';PWD='+password) except pypyodbc.Error as...
I'm trying to run a query on DB2 and get the following error: ``` ... /opt/conda/envs/DSX-Python35/lib/python3.5/site-packages/pypyodbc.py in execute(self, query_string, params, many_mode, call_mode) 1624 1625 else: -> 1626 self.execdirect(query_string) 1627 return...
In SQL_data_type_dict, SQL_WVARCHAR & SQL_VARCHAR have "Variable Length" set to False. Shouldn't they be set to True?
it works fine but when it reached this value it throws the above error Invalid scale value') ('EMP3600477', '3600477', None, None, datetime.date(1970, 1, 1), datetime.date(1970, 1, 1), 'TRF', '002', Decimal('0.000000'),...
i seem to not be able to connect to azure in the cloud using pypyodbc pypyodbc.ProgrammingError: (u'42000', u"[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Reference to database and/or server name in 'master..sysdatabases'...
Hi, I'm hitting a problem when trying to truncate tables on an mssql server (2017 dev). I use python3.6 up to date with 4 weeks old pypi's pypyodbc on centos7.4...
I've made the wheel myself, but the cheeseshop still only has 1.3.5 pypyodbc (1.3.5) - PyPyODBC - A Pure Python ODBC module by ctypes INSTALLED: 1.3.6 LATEST: 1.3.5
The latest version in PyPi 1.3.5 has an issue (ValueError: byte string too long) with SQL Server. The issue no longer existed when we switched to the master version. It...
Metadata
Owner
Metadata
A pure Python Cross Platform ODBC interface module