Ask Ubuntu
Ask Ubuntu

Questions tagged [odbc]

Open Database Connectivity (ODBC) is a standard programming language middleware application programming interface (API) for accessing database management systems (DBMS).

The aim of ODBC is to provide a standard, language-agnostic, cross-platform API for accessing database managements systems.

39 questions
17
votes
3 answers

Installing Ubuntu 16.04 LTS: How to install ODBC?

After installing a fresh new copy of Ubuntu 16.04, I tried to install MySQL ODBC as per the official documentation at https://help.ubuntu.com/community/ODBC: # apt-get install libmyodbc Reading package lists... Done Building dependency tree …
Ernie
  • 1,085
10
votes
1 answer

Wine QLDrivers No ODBC drivers

I run winecfg and terminal throw err: 0012:err:winediag:SQLDrivers No ODBC drivers could be found. Check the settings for your libodbc provider. how to fix this?
Huy Hoàn
  • 121
  • 1
  • 5
7
votes
3 answers

How to install and configure the latest ODBC driivers for both MYSQL & PostgreSQL in 18.04

I'm currently trying to get access to some MYSQL and PostgreSQL databases via an ODBC connection via an ODBC Administrator GUI as I had on Windows. After searching around, I have only found scattered and old tutorials for installing and setting up…
Mysterio
  • 12,288
7
votes
1 answer

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server

I am not able to run sqlcmd command My OS (18.04) is $ uname -a Linux Linux 4.15.0-23-generic #25-Ubuntu SMP Wed May 23 18:02:16 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux $ sqlcmd -S localhost -U SA -P 'password' Sqlcmd: Error: Microsoft ODBC…
Raakh
  • 103
7
votes
1 answer

Cant find pyodbc driver despite install

I have pyodbc installed and I am trying to connect to a server, but pyodbc can't find the drivers. I did the following: Installed pyodbc using pip: pip install pyodbc Followed the Microsoft instructions. Ran a test script: import pyodbc…
Rilcon42
  • 251
6
votes
0 answers

How to add support for MS Access .mdb to PHP7 PDO in Ubuntu 18.04

I needed to be able to read a .mdb (Microsoft Access© (JET) file) copied from a Windows system on Linux, specifically Ubuntu 18.04. I searched dozens of web sites and could not find a straightforward way to achieve this. Most of the pages only…
James Cobban
  • 251
5
votes
1 answer

How do I install sqlite3 ODBC drivers with unixODBC?

According to the unixODBC drivers page (straight out of the 90s), I should download the SQLite3 drivers from: http://www.ch-werner.de/sqliteodbc The instructions for building sqliteodbc from the source code provided on that page is available here:…
user390136
5
votes
1 answer

Installing unixodbc on 19.10

I am attempting to use pyodbc to connect to a MSSQL database in python. I have installed the MS drivers following the instructions here using the 19.04 version. When attempting to install pyodbc via pip i get sql.h: No such file or directory.…
niknoe
  • 173
  • 1
  • 2
  • 6
4
votes
2 answers

Microsoft ODBC v18 is not find by APT

I'm following these instructions to install the ODBC driver v18 on Ubuntu 22.04. I'm aware that the script does not want to install anything for Ubuntu 22.04 but I bet it's a typo because the repository for 22.04 does exist. After issuing: sudo…
Mark
  • 577
3
votes
2 answers

cannot install msodbcsql17

I am having issues install msodbcsql17 in my docker container. I tried suggestions similar to Unable to install msodbcsql17 on Ubuntu 18.04, but still received the error: ACCEPT_EULA=Y apt-get install -y msodbcsql17' returned a non-zero code:…
frank
  • 135
3
votes
0 answers

UnixODBC reads ASCII?ANSI although It is compiled with iconv enabled

I have been searching for this issue for quite a while, please do not be quick to give me similar questions, here is the issue: I installed and configured unixodbc on ubuntu, connected it to oracle and connection works I installed and configured…
C. Geek
  • 31
2
votes
2 answers

Microsoft ODBC drivers not fully installed and no way to unistall them

I've downloaded this debian package: curl https://packages.microsoft.com/ubuntu/16.04/prod/pool/main/m/msodbcsql/msodbcsql_13.1.4.0-1_amd64.deb -o msodbcsql_13.1.4.0-1_amd64.deb Then I have run the following command: sudo ACCEPT_EULA=Y dpkg -i…
TPPZ
  • 123
  • 2
  • 2
  • 6
2
votes
1 answer

Problem connecting to SQL server via FreeTDS/UnixOdbc

I am trying to connect to MS-SQL server via ODBC, probably this is one of most asked questions but this one is very strange because same configuration works in my local machine, I mean I did everything on my local computer and its OK, but now in…
Bahram
  • 21
2
votes
0 answers

Help with permissions in Apache2 to get ODBC driver to work in browser

I'm new to LAMP environment and I have some issue with my browser viewing ODBC queries. My php code works in the console under root, but if I run the file using www-data as the user it fails the same way as the browser. Here's the php…
mudrock
  • 21
2
votes
0 answers

[08001][Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2746 - Ubuntu 22.04

I'm trying to connect to an MS SQL Server 2016 from my ubuntu server 22.04. I've installed the odbc driver following the official MS documentation:…
BigLeo
  • 121
1
2 3