It differs by driver. Here are two examples: import MySQLdb mc = MySQLdb.connect() r = mc.cursor() r.execute(‘select %s, %s’, (“foo”, 2)) r._executed “select ‘foo’, 2” import psycopg2 pc = psycopg2.connect() r = pc.cursor() r.execute(‘select %s, %s’, (‘foo’, 2)) r.query “select E’foo’, 2”
Two thoughts on what to check: 1) Your connection string is wrong. There’s a way to get a known good connection string directly from the ODBC Administrator program (taken from http://www.visokio.com/kb/db/dsn-less-odbc). These instructions assume you’re using an MDB, but the same process will work for a paradox file On a typical client PC, open Control … Read more
At the time this question was asked, pandas 0.23.0 had just been released. That version changed the default behaviour of .to_sql() from calling the DBAPI .executemany() method to constructing a table-value constructor (TVC) that would improve upload speed by inserting multiple rows with a single .execute() call of an INSERT statement. Unfortunately that approach often … Read more
You need to commit the data. Each SQL command is in a transaction and the transaction must be committed to write the transaction to the SQL Server so that it can be read by other SQL commands. Under MS SQL Server Management Studio the default is to allow auto-commit which means each SQL command immediately … Read more
Is pyodbc becoming deprecated? No. For at least the last couple of years pandas’ documentation has clearly stated that it wants either a SQLAlchemy Connectable (i.e., an Engine or Connection object) or a SQLite DBAPI connection. (The switch-over to SQLAlchemy was almost universal, but they continued supporting SQLite connections for backwards compatibility.) People have been … Read more
I believe the answer to your problem is that in your ~/.odbc.ini file you are saying to use driver PostgreSQL – but you have not defined that driver in your /etc/odbcinst.ini file. Try changing PostgreSQL to PostgreSQL ANSI or PostgreSQL Unicode (both of which are defined in /etc/odbcinst.ini).
Need to Run: sudo apt-get install gcc need to add a odbcinst.ini file containing: [FreeTDS]Description=FreeTDS Driver Driver=/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup=/usr/lib/x86_64-linux-gnu/odbc/libtdsS.so need to add folowing to docker file ADD odbcinst.ini /etc/odbcinst.ini RUN apt-get update RUN apt-get install -y tdsodbc unixodbc-dev RUN apt install unixodbc-bin -y RUN apt-get clean -y need to change connection in .py to connection = … Read more
From the pyodbc documentation To call a stored procedure right now, pass the call to the execute method using either a format your database recognizes or using the ODBC call escape format. (The ODBC driver will then reformat the call for you to match the given database.) For SQL Server you would use something like … Read more
Just in case some lonely net nomad comes across this issue, the solution by Torxed didn’t work for me. But the following worked for me. I was calling an SP which inserts some values into a table and then returns some data back. Just add the following to the SP : SET NOCOUNT ON It’ll … Read more
Is there some modification that can be done to make it work without installing 32 bit python and 32 bit pyodbc? Not really. If you have 32-bit Office installed then you have the 32-bit version of the Access Database Engine (a.k.a. “ACE”), and only 32-bit applications can use it. The installer for the 64-bit version … Read more