Connect docker python to SQL server with pyodbc

by

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 = pyodbc.connect('Driver={FreeTDS};'
                            'Server=xxxxx;'
                            'Database=DCMM;'
                            'UID=xxxxx;'
                            'PWD=xxxxx')

Now the container compiles, and gets data from SQL server

More Related Contents:

  1. How do I pass environment variables to Docker containers?
  2. Dockerfile if else condition with external arguments
  3. Multiple FROMs – what it means
  4. How to update /etc/hosts file in Docker image during “docker build”
  5. Multiple RUN vs. single chained RUN in Dockerfile, which is better?
  6. Conditional COPY/ADD in Dockerfile?
  7. denied: requested access to the resource is denied: docker
  8. standard_init_linux.go:190: exec user process caused “no such file or directory” – Docker
  9. How to pass arguments within docker-compose?
  10. Docker – unable to prepare context: unable to evaluate symlinks in Dockerfile path: GetFileAttributesEx
  11. Externalising Spring Boot properties when deploying to Docker
  12. COPY with docker but with exclusion
  13. ARG or ENV, which one to use in this case?
  14. How can I use a variable inside a Dockerfile CMD?
  15. Docker COPY from ubuntu absolute path
  16. How to fill user input for interactive command for “RUN” command?
  17. Why the “none” image appears in Docker and how can we avoid it
  18. How to mount local volumes in docker machine
  19. Is there a way to combine Docker images into 1 container?
  20. How do I set environment variables during the build in docker
  21. Difference between links and depends_on in docker_compose.yml
  22. How to set image name in Dockerfile?
  23. Change directory command in Docker?
  24. Dockerfile build – possible to ignore error?
  25. Docker: Using –password via the CLI is insecure. Use –password-stdin
  26. Share variable in multi-stage Dockerfile: ARG before FROM not substituted
  27. Docker container doesn’t expose ports when –net=host is mentioned in the docker run command
  28. How do I Docker COPY as non root?
  29. Docker follow symlink outside context
  30. Dockerfile: Output of RUN instruction into a Variable

Leave a Comment