pyodbc Questions
7
Solved
I am trying to make sense of the following error that I started getting when I setup my python code to run on a VM server, which has 3.9.5 installed instead of 3.8.5 on my desktop. Not sure that ma...
Queer asked 11/2, 2022 at 15:22
8
I am using pip and trying to install a python module called pyodbc which has some dependencies on non-python libraries like unixodbc-dev, unixodbc-bin, unixodbc. I cannot install these dependencies...
Toggle asked 13/9, 2013 at 9:56
10
I am trying to use Python to connect to a SQL database by using Window authentication. I looked at some of the posts here (e.g., here), but the suggested methods didn't seem to work.
For example, ...
Hoyle asked 8/6, 2016 at 3:34
3
I am having a python application that uses mssql - instead of using pymssql, i was trying pyodbc. There seems to be no problems while running the application in a Windows local machine. While deplo...
3
Solved
I need to send unicode to SQL Server with Python 2.7. I failed with pymssql. I'm now trying to get pypyodbc working (as opposed to pyodbc), as it gives working unicode examples. The problem is that...
Exhalant asked 15/4, 2013 at 21:24
0
I am trying to migrate a 1.4 TB DB on SQL server to MySQL. I am using MySQL workbench to do the migration
SQL server is 2022 dev edition. MySQL version is v 8
It is throwing following errors :-
Co...
Scoville asked 17/8, 2023 at 12:12
3
Solved
I connect to a DB2 server through ODBC connection in my python code. The DB2 server gets reboot for maintainence or disconnects me while running specific server side tasks, happens 1 or 2 times in ...
Moribund asked 6/6, 2019 at 8:45
7
Solved
With this table:
CREATE TABLE test_insert (
col1 INT,
col2 VARCHAR(10),
col3 DATE
)
the following code takes 40 seconds to run:
import pyodbc
from datetime import date
conn = pyodbc.conne...
Mendel asked 17/4, 2011 at 13:50
4
Solved
I am trying to get the ID of a newly inserted row by using OUTPUT. However, I encountered the HY010 error. The following query/code is what I use:
string = """
SET NOCOUNT ON;
DECLARE @NEWID TAB...
Rump asked 8/11, 2017 at 20:24
6
I have a new M1 pro macbook and I'm trying to install pyodbc and relevant drivers on my machine.
So far I have installed unixodbc via homebrew and ODBC drivers according to the instructions found h...
Poland asked 14/2, 2022 at 23:31
7
Solved
I'm using ActivePython 2.7.2.5 on Windows 7.
While trying to connect to a sql-server database with the pyodbc module using the below code, I receive the subsequent Traceback. Any ideas on what I'm...
Pardue asked 17/9, 2013 at 21:59
1
I am using pyodbc to get some data from a MSQL Server. Works fine, except when retrieving a huge number of data: It is really slow.
I have around 4000 rows, which is not a really big number.
conn...
Huppert asked 19/11, 2015 at 20:15
7
Solved
I trid the following code,
import pyodbc
try:
pyodbc.connect('DRIVER={%s};SERVER=%s;DATABASE=%s;UID=%s;PWD=%s' % (driver, server, database, uid, password))
except pyodbc.Error, err:
logging.warn...
3
I'm trying to insert a datetime value into a MS SQL Server table using pyodbc.
If I do it manually, something like:
cursor.execute("""insert into currentvalue(value1,currentdatetime)
values(55,'2...
Gowen asked 27/6, 2014 at 17:57
4
I'm trying to pull a list of tables from an access database. The script goes through and displays about a third of the tables and gets the following error:
Traceback (most recent call last): Fil...
4
Solved
I am using 64-bit python anaconda v4.4 which runs python v3. I have MS Access 2016 32-bit version. I would like to use pyodbc to get python to talk to Access. Is it possible to use 64-bit pyodbc to...
Mariomariology asked 29/8, 2017 at 0:20
19
Solved
I am running Linux (2.6.18-164.15.1.el5.centos.plus) and trying to install pyodbc. I am doing pip install pyodbc and get a very long list of errors, which end in
error: command 'gcc' failed wit...
11
Solved
I'm trying to connect a pyodbc python script running in a docker container to login to a MSSQL database I have tried all sorts of docker files, but not been able to make the connection (fails when ...
Suzan asked 25/9, 2017 at 12:53
3
Solved
I am currently writing a script to run multiple SQL files using Python, a little background before you mention alternative methods; this is to automate the scripts and Python is the only tools I ha...
9
Solved
I am trying to retrieve data from an SQL server using pyodbc and print it in a table using Python. However, I can only seem to retrieve the column name and the data type and stuff like that, not th...
Bantu asked 12/7, 2012 at 11:44
11
Solved
I can't figure out what's wrong with the following code,
The syntax IS ok (checked with SQL Management Studio), i have access as i should so that works too.. but for some reason as soon as i try to...
Bejarano asked 13/10, 2011 at 12:3
11
Solved
I use the following code in Python (with pyodbc for a MS-Access base).
cursor.execute("select a from tbl where b=? and c=?", (x, y))
It's Ok but, for maintenance purposes, I need to know the com...
3
Solved
I've tried to install pyodbc on mac, but I got this error
Traceback (most recent call last):
File "Untitled.py", line 1, in <module>
import pyodbc
ImportError: dlopen(/usr/local/lib/python...
Volleyball asked 21/2, 2018 at 10:59
3
Solved
I'm trying to install this mysql odbc connector on my macOS High Sierra machine, but I get this error:
I tried installing it using installer in the hopes of getting information about what went wr...
Mekong asked 24/11, 2017 at 10:14
6
Solved
Below is my code that I'd like some help with.
I am having to run it over 1,300,000 rows meaning it takes up to 40 minutes to insert ~300,000 rows.
I figure bulk insert is the route to go to spee...
Sync asked 14/4, 2015 at 22:1
© 2022 - 2024 — McMap. All rights reserved.