Hi Simon,
thanks for the response , following below is my code and attached is the
snapshot of error for your reference , the code runs fine when it is in py
file , however it fails when i convert it into exe.
Code :
import pandas as pd
from pandas import DataFrame
import numpy as np
import pyodbc
from sqlalchemy import create_engine
import time
import sqlalchemy as db
import pymssql
import pyodbc
from sqlalchemy.sql import text as sa_text
from sqlalchemy.orm import sessionmaker
import os
import turbodbc
path1= "Enterpathforexcelfile"
df=pd.read_excel(path1,'Tablename' ,ignore_index=False,index_col=False)
df.fillna('',inplace=True)
#Performaing panadas dataframe operations
engine =
create_engine('mssql+turbodbc://<ID>:<Password>@<Servername>/<Database>?driver=SQL+Server+Native+Client+10.0')
connection=engine.connect()
query="delete from Tablename;"
engine.execute(query)
#transfer dataframe to sql server
df.to_sql('Tablename', connection, schema='schemaname',index=False
,if_exists='append',chunksize=50000)
On Friday, October 11, 2019 at 2:37:48 AM UTC+5:30, Simon King wrote:
>
> What is the error message when it fails?
>
> On Thu, Oct 10, 2019 at 10:00 AM Pradeep Dhamale
> <[email protected] <javascript:>> wrote:
> >
> > i have created a mssql connection using sqlalchemy : mssql+turbodbc
> engine,
> > the script runs properly when it is a .py file , however whenever i
> convert the .py file to .exe using pyinstaller --one file , the exe gets
> generated successfully , but while executing the exe it fails.
> >
> > --
> > 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 [email protected] <javascript:>.
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/54ff39e6-bcff-4545-85cf-a43f9a04f1be%40googlegroups.com.
>
>
>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/a2f0dfbd-ef0f-4bba-a93b-98cbf4fcd651%40googlegroups.com.
