What I'm trying to do Install Microsoft's ODBC driver into a Docker image using the following Dockerfile and the docker build command.: FROM public.ecr.aws/docker/library/python:3.9.10-slim-buster RUN apt-get update RUN apt-get install -y curl gnupg RUN curl -sSL https://packages.microsoft.com/keys/microsoft.asc | apt-key add…
today I need some help with a php-script, that doesn't work anymore. I have to setup a backup server, where a simple timesheet works with a web-interface, connected to an odbc datasource (Access 2007-database) Everything works well on the original…
I was attempting to get the Databricks ODBC driver working on Golang. I followed the directions on https://github.com/alexbrainman/odbc in order to setup the Go library and the system library. Instead of setting up the MSSQL ODBC driver, I installed Databricks'…
I need a simple ODBC test scenario on WIN which I can configure very simply and be assured it is working in support of another question at Unix.SE. In a nutshell I'm trying to setup a PyODBC/Python script connection from…
I have pyodbc installed in Windows10(host os) and CentOS docker image. In Windows10, it is working as expected, however it throws an error on docker image. ValueError: month must be in 1..12 import pyodbc conn = pyodbc.connect('DSN=db2; UID=myid; PWD=mypwd') cursor…
We have a python flask app running on an aws centos ECS instance. We are trying to establish an encrypted connection to our database via PYODBC with odbc 17 on Linux. When running locally we just use the SQL server…
My OS = CentOS-7 Oracle 18.4 XE Java 8 JDK + Tomcat 8 I facing the following error: Exception in thread "main" java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole at oracle.jdbc.driver.DMSFactory.<clinit>(DMSFactory.java:46) at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:1713) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:849) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:443) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:712) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247)…
Function getUsers_Test() can retrieve data with the limit of 10 rows only while my getUsers_Orig() cannot retrieve any records **my record in the database is almost 50 rows*. No error, no warning. (PHP version 5.5.12) function getUsers_Test(){ $sql = "SELECT…
I have a Laravel installation running on a Debian 9.9 server and PHP 7.4. I need to connect to a SQL Server database on a remote Windows server. I followed this guide to install the PHP extensions: https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#installing-the-drivers-on-debian-8-9-and-10 And this…
Trying to use sqlcmd from mssql-tools package (loosly following the docs here: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-RHEL-6-or-Centos-7) and seeing error Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Data source name not found and no default driver specified. even though I believe…