pyodbc Questions
4
After installing pyodbc in a docker container I'm receiving the error:
File "/root/.local/lib/python3.10/site-packages/sqlalchemy/connectors/pyodbc.py", line 43, in dbapi
return __impor...
Dogmatist asked 14/4, 2023 at 20:21
5
I'm trying to connect to a SQL server database using pyodbc in Python 3. But I get an error when I'm trying to establish the connection.
I do something like this:
import pyodbc
conn = pyodbc.connec...
Elytron asked 23/3, 2022 at 12:28
7
Ubuntu 22.04.1 LTS
pyodbc 4.0.35
OpenSSL 3.0.2 15 Mar 2022 (Library: OpenSSL 3.0.2 15 Mar 2022)
Followed steps on Install the Microsoft ODBC driver for SQL Server (Linux)
Installation successful. W...
Plasterwork asked 6/12, 2022 at 19:23
3
Solved
I am trying to perform a table creation using pyodbc on a SQL Server 2017 database hosted using Docker. I'm also using a network so that I can connect to it later from another Docker image. However...
Cabaret asked 14/2, 2020 at 7:6
3
I am trying to connect to my company's SQL Server Databases via my MacBook and have followed the steps outlined here: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Mac-OS...
Chrisy asked 4/8, 2019 at 23:40
4
When I run
$ python manage.py inspectdb --database=mssql_database
I have the following error
django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/...
Younts asked 5/5, 2022 at 10:29
3
Solved
I'm pretty new to Python (2.7) and am just not a lot of help with pyodbc. I have a script that calls a stored procedure:
sql = "exec gen_all.dbo.rpt_trinity_total '" + startDate + "', '" + endDate...
Ossicle asked 11/2, 2013 at 23:50
8
Solved
I am trying to connect from a linux machine to a windows SQL Server with pyodbc.
I do have a couple of constraints:
Need to log on with a windows domain account
Need to use python3
Need to do it...
7
Solved
I have trouble getting pyodbc work. I have unixodbc , unixodbc-dev, odbc-postgresql, pyodbc packages installed on my Linux Mint 14.
I am losing hope to find solution on my own, any help appreciated...
Astri asked 29/4, 2013 at 13:47
14
I've written a short python script which tries to import the pyodbc extension package so I can access my SQL table.
import pyodbc as pyodbc
cnxn = pyodbc.connect('Driver={SQL Server};'
'Server=DE...
Redmund asked 29/8, 2018 at 19:56
4
Solved
I know sqlite3 has
data = {'test_col': 012345679}
sqlite3_conn.execute("""
UPDATE test_db SET test_col = :test_col
;""", data)
and mysql-connector-python has
data = {'test_col': 012345679}
my...
4
Solved
I'm trying to connect from a Databricks notebook to an Azure SQL Datawarehouse using the pyodbc python library. When I execute the code I get this error:
Error: ('01000', "[01000] [unixODBC][Drive...
Paganini asked 4/4, 2020 at 1:50
3
Solved
I am running on Windows 7, Python 2.7 and Microsoft Access 2013.
When I try running:
import pyodbc
conn_string = '''
DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};
UID=admin;
UserCommitSync=Y...
7
Solved
I am trying to connect to MS SQL Server using pyodbc from a remote machine running Ubuntu 16.04.
import pyodbc
conn = pyodbc.connect(r'DRIVER=ODBC Driver 17 for SQL Server; SERVER=xxxTest-SRV; P...
Mcripley asked 26/4, 2018 at 14:55
2
Solved
I have found some other questions that have a similar error to what I am getting, but have not been able to figure out how to resolve this based on the answers. I am trying to import an excel file ...
Banded asked 10/7, 2018 at 15:23
3
Solved
I am trying to insert data into a mssql database. I needed as fast method for this so I set the fast_executemany param to true. The upload works fine for most part but if one of the column is a dat...
Jeepers asked 6/5, 2022 at 13:28
13
I have a dataframe with ca 155,000 rows and 12 columns.
If I export it to csv with dataframe.to_csv , the output is an 11MB file (which is produced instantly).
If, however, I export to a Microsoft...
Laic asked 17/4, 2015 at 17:55
2
Solved
I've been unable to find a documented way to set a timeout for the initial connection that actually works. I'm not asking about a "query timeout", but rather a timeout on an initial connection atte...
Cadwell asked 12/9, 2013 at 20:51
5
Solved
I have a Python process that uses SQLAlchemy to insert some data into a MS SQL Server DB. When the Python process runs it hangs during the insert. I turned on SQLAlchemy logging to get some more in...
Summertree asked 30/10, 2020 at 14:27
4
Solved
I am trying to read data from SQL server into pandas data frame. Below is the code.
def get_data(size):
con = pyodbc.connect(r'driver={SQL Server}; server=SPROD_RPT01; database=Reporting')
cur = ...
Ebba asked 17/11, 2017 at 16:27
4
Solved
I am using PyODBC to back up my database, using following code:
SQL_command = """
BACKUP DATABASE [MyDatabase]
TO DISK = N'D:\MSSQL\BACKUP\MyDatabase_20141212.bak' WITH
NOFORMAT
...
16
Solved
When I try to connect to a sql server database with pyodbc (on mac):
import pyodbc
server = '####'
database = '####'
username = '####@####'
password = '#####'
driver='{ODBC Driver 13 for SQL Serv...
24
import pyodbc
connection = pyodbc.connect('Driver = {SQL Server};Server=SIWSQL43A\SIMSSPROD43A;'
'Database=CSM_reporting;Trusted_Connection=yes;')
Error:
connection = pyodbc.connect('Driver = {...
1
Hi I am trying to read a dataframe from sql server from a linux(ubuntu server).
The file(gscm.ppk) has the admin keys in it
I have used the following format to connect to sql server:
import urllib....
Barcot asked 16/10, 2021 at 22:14
5
I want to access the data in a Microsoft Access database. I have some .accdb and .mdb files and want to read them in Python.
From my research, pyodbc can only be used on Windows platform, but I a...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.