Hi, having an error when writing a dataframe to db and can't find a
solution out there. Have used sqlalchemy with sql server extensively before
but can't crack this one. Help would be greatly appreciated!
*To reproduce:*
from sqlalchemy import create_engine
import urllib
connection_string =
"Driver={};Server={};Database={};UID={};PWD={};encoding='latin1'".format('SQL
Server',
config['server'],
config['database'],
config['uid'],
config['pwd'])
connection_string = urllib.parse.quote(connection_string)
connection_string = "mysql+pyodbc:///?odbc_connect=%s" % connection_string
engine = create_engine(connection_string, convert_unicode=True)
df = pd.DataFrame(np.random.randn(6, 4), columns=list('ABCD'))
df.to_sql("test_table", engine, if_exists='replace', index=False)
*Error on the first run:*
sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000',
"[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax
near the keyword 'LIKE'. (156) (SQLExecDirectW)") [SQL: "SHOW VARIABLES
LIKE 'character_set%%'"]
*Error on second run:*
sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000',
"[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax
near '`'. (102) (SQLExecDirectW)") [SQL: 'DESCRIBE `test_table`']
*Stack:*
python=3.6
sqlalchemy=1.1.13
pyodbc=4.0.17
Sql Server=2008
Pandas=0.20.3
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
