python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - pyodbc

SQLAlchemy fails to insert decimal only on temp table

Trying to insert into temp tables with SQLAlchemy (plugged into PYODBC/sql server) and inserting more than one row with decimal values and fast_executemany=True throws: ProgrammingError("(pyodbc...
test-img

manoftheyear

python

sql-server

sqlalchemy

pyodbc

Votes: 0

Answers: 1

Latest Answer

fast_executemany=True asks the ODBC driver what the column types are, and the default mechanism used by Microsoft's ODBC drivers for SQL Server is to call a system stored procedure named sp_describe_u...
test-img

Gord Thompson

Create a hive table using python

I am using python and I want to create a hive table. Also I want that table should be created with same data type as of data type in dataframe; Below is the code I used to create a connection with hiv...
test-img

KMittal

python

hive

pyodbc

impala

Votes: 0

Answers: 0

Python - "pyodbc" is not accessed Pylance

Im new to using python, and having some trouble using pyodbc to connect to MS SQL. I've reinstalled almost everything except windows so far. reinstalled a few times, both with pip/pip3. Even tried old...
test-img

Orly Oo

python

visual-studio-code

pyodbc

pylance

Votes: 0

Answers: 1

Latest Answer

The error you show is one given by your editor, not by Python. Pylance is an extension for Visual Studio Code (VSCode) to help the editor understand Python code. It simply means that Pylance is not us...
test-img

Martijn Pieters

Quickbooks and pyodbc LIKE pattern matching

I'm using pyodbc to run some queries against Quickbooks and having some issues with pattern matching, specifically with square bracket wildcards. I don't even know if I'm allowed to use square bracket...
test-img

Matt Perry

pyodbc

quickbooks

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs