Im working on cloud native solution, in which I’m having a project pod in which project using mssql database. Also, im executing an installation pod for mssql which uses ubuntu image and install the necessary msodbc17 driver. after the installation im copying the lib files to project pod. and ENV ODBCINI and ENV ODBCSYSINI is set still im unable to access the database when i execute the project.
I used this command for installation of msodbc17 driver:
args:
– |
set -e
apt-get update
apt-get install -y curl apt-transport-https gnupg2
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add –
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list > etc/apt/sources.list.d/msprod.list
apt-get update
ACCEPT_EULA=Y apt-get install -y msodbcsql17 unixodbc-dev
apt-get clean && rm -rf /var/lib/apt/lists/*
echo “ODBC driver installation completed.”
cp -r /opt/microsoft/msodbcsql17/lib64/* /home/shared-resources/msodbc/lib/
Also i copied this .so files to lib dir:
libltdl.so.7 libltdl.so.7.3.1 libmsodbcsql-17.10.so.6.1 libmsodbcsql-17.so libodbc.so libodbc.so.2 libodbc.so.2.0.0 libodbcinst.so libodbcinst.so.2 libodbcinst.so.2.0.0 msodbcsqlr17.rll
I tried every way to resolve the issue but it is not working. Please somebody guide me on this.