I have to move some customer sites from a very old IIS Server to a newer one, and some sites have troubles to work in the correct way. Most of them complain about a failure called: Microsoft OLE D...

I'm trying to connect to a SQL server database using pyodbc in Python 3. But I get an error when I'm trying to establish the connection. I do something like this: import pyodbc conn = pyodbc.connec...

Ubuntu 22.04.1 LTS pyodbc 4.0.35 OpenSSL 3.0.2 15 Mar 2022 (Library: OpenSSL 3.0.2 15 Mar 2022) Followed steps on Install the Microsoft ODBC driver for SQL Server (Linux) Installation successful. W...

Installing Microsoft® ODBC Driver 17 on windows 10. During the install, Microsoft ODBC Driver 17 for SQL Server setup stops and shows "A previous installation required a reboot of the machine for c...

I am running Python 3.5 on my Linux Mint 18. I want to load the pypyodbc module. However, no matter what I try, I always get the error: OdbcNoLibrary: 'ODBC Library is not found. Is LD_LIBRARY_PA...

I'm failing to connect to a SQL server SQLExpress. The connection worked fine a few days ago. This is how I tried to connect (I'm using Microsoft SQL server management studio): connection = pyodbc...

When I run $ python manage.py inspectdb --database=mssql_database I have the following error django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/...

What's the best way to check if a table exists in a Sql database in a database independant way? I came up with: bool exists; const string sqlStatement = @"SELECT COUNT(*) FROM my_table"; try...

I am trying to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I'm getting an error message that says : A problem was encountered while trying to log into or create t...

I am having an issue with an SQLite database. I am using the SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ Installed the 64-bit version and created the ODBC with these settings: I open my...

I have problem when I try insert some data to Informix TEXT column via JDBC. In ODBC I can simply run SQL like this: INSERT INTO test_table (text_column) VALUES ('insert') but this do not work i...

I am running on Windows 7, Python 2.7 and Microsoft Access 2013. When I try running: import pyodbc conn_string = ''' DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; UID=admin; UserCommitSync=Y...

I continue to read the DBI/ODBC is faster than RODBC, so I tried as follows: require(DBI);require(odbc) con <- DBI::dbConnect(odbc::odbc(), dsn = 'SQLSERVER1', database = 'AcumaticaDB') I can...

I used odbc_connect() in my PHP page to connect to the HANA database. It works fine when I run it locally. I upload the same PHP page into the server and I am getting this error: Fatal error: Call...

I use Visual Studio Community 2019 16.3.1. I want to use an ODBC connection in a .NET Core 3.0 project (the sample works with .NET Framework 4.x): using System.Data.Odbc; using (OdbcConnection c...

I have an MS Access database (intolerably enough), and communicating with it through PHP (ODBC). There is a DateTime field that I have to include in my INSERT statement. This field is NOT defined ...

I have managed to read data of Microsoft Access file (.accdb) on Windows using PDO but I'm having problem getting to work on Linux (CentOS). I can see modules is installed: [root@rapid host]# php ...

When trying to make a program on Windows that connects to a database via ODBC, I got the following error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specif...

I am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance of SQL Server running in a different location, and some apps that I am building ...

I want to access the data in a Microsoft Access database. I have some .accdb and .mdb files and want to read them in Python. From my research, pyodbc can only be used on Windows platform, but I a...

I have installed python 2.7.0 and Teradata module on Windows 7. I am not able to connect and query TD from python. pip install Teradata Now I want to import teradata module in my source code and ...

I am trying to connect to a Microsoft SQL Server database from R studio. I installed the unixODBC driver manager using homebrew: brew install unixodbc I then tried to install the freetds driver as...

I have this: $dbh = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=$mdbFilename", $username, $password); $sql = "SELECT * FROM this_table"; $stmt = $dbh->query($sql...

I'm trying to connect my django app to a SQL Server instance. In development I'm using a sqlsrv created with a docker image and everything work just fine. In production I have a connection issue: ...

I am trying to connect to a PostgreSQL database using the R ODBC drivers in RStudio. For some reason, the drivers are not being detected by R: $ Rscript -e 'odbc::odbcListDrivers()' [1] name attri...