I’m moving an app that was previously running on windows 10 to a docker container with python3.6 linux base image. One of the necessary changes was changing the driver used in sql connection string from “SQL Server” to ODBC Driver 17 for SQL Server, because I have to use unixodbc-dev. I inst…
Tag: unixodbc
[unixODBC][Driver Manager]Can’t open lib ‘/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so’ : file not found
I have installed Postgresql 9.4 on Ubuntu 16.04, and installed postgresql ODBC and Unix ODBC drivers. When I test the ODBC connection with isql it works fine. Also, I am able to connect to the databases using pgadmin III from local and remote locations. But, when I am trying to install a software which will c…
Ubuntu-16.04 + PHP-7.0.22 + ODBC not working
I have been trying to connect MSSQL from my ubantu 16.04 and i had use below tutorial: https://askubuntu.com/questions/578934/mssql-connection-from-ubuntu There is one problem while i am running below command from terminal is: It display below errors: I have follow instruction given by below link answer as we…
Error during insert with parameter(s) over 30 characters
Issue Performing an insert using prepared statements with PDO and an ODBC driver gives the following error when at least one of the parameters is over 30 characters: Inserts work for any bound string that is <= 30 characters in length. I have no issues with SELECT queries. Using INSERT with isql and sqlcmd…