# Scrypt Python SQL Server

**URL:** <https://forums.docker.com/t/scrypt-python-sql-server/53752>\
**Category:** General\
**Created:** [July 9, 2018, 1:58pm UTC](https://forums.docker.com/t/scrypt-python-sql-server/53752 "2018-07-09T13:58:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tsdvserrano](https://avatars.discourse-cdn.com/v4/letter/t/d07c76/32.png) [@tsdvserrano](https://forums.docker.com/u/tsdvserrano)\
**Post date:** [July 9, 2018, 1:58pm UTC](https://forums.docker.com/t/scrypt-python-sql-server/53752/1 "2018-07-09T13:58:13Z")

</div>

I am new to docker and python. I am running a docker image for tensorflow for image classification in Windows 10. I like to save the output into HOST SQL Server. I have modified the python code for the insert. pyodbc was not working initially. But I have run below commands and it is working.

RUN  
apt-get update && apt-get install -y gcc unixodbc-dev

RUN  
pip install pyodbc

But I am still getting the below error while try to run the insert python script. What should I do next?

pyodbc.Error: (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘SQL Server’ : file not found (0) (SQLDriverConnect)”)

cnxn = pyodbc.connect(‘Trusted\_Connection=yes’, driver = ‘{SQL Server}’,server = ‘127.0.0.1’, port=‘1433’, user=‘sa’, password=’\*\*\*\*\*’, database=’\*\*\*\*’)