Questions tagged [odbc]

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

Filter by
Sorted by
Tagged with
3 votes
1 answer
1k views

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 ...
user avatar
  • 355
1 vote
1 answer
5k views

0x2746 Error msodbcsql connection to SQL Server 2016

I am getting a error when trying to use sqlcmd against my SQL Server 2016 database. I can successfully get a connection to on port 1433 (venv) xxxx@ip-xxx-xx-xx-xxx:/etc$ telnet xx.xxx.xxx.202 1433 ...
user avatar
0 votes
0 answers
2k views

Error: Microsoft ODBC Driver 17 for SQL Server - Does Not Connect

sqlcmd -S 192.168.1.86\\SQLEXPRESS,1443 -U c -P e Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired. Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider:...
user avatar
0 votes
1 answer
287 views

JSDB showing error libodbc.so.1 can't be opened

I am trying to run jsdb in my ubuntu 19.10 machine. I am getting this error ./jsdb: error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory I ...
user avatar
5 votes
1 answer
13k views

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 ...
user avatar
  • 173
3 votes
0 answers
80 views

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 ...
user avatar
  • 31
2 votes
0 answers
1k views

Problem configuring MSSQL client and Kerberos authentication

I have a problem configuring an Ubuntu 18.04. client to connect to MSSQL Server using Windows Authentication. First of all, Kerberos/AD Login works fine using PAM and Winbind, connection using SQL ...
user avatar
  • 21
6 votes
2 answers
5k views

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 ...
user avatar
  • 11.6k
1 vote
1 answer
4k views

How to install PHP SQL Server drivers in Ubuntu 19?

I have followed the instructions on the tutorial for installation on Linux, but unfortunately the Unix ODBC dependencies are not available in the repos for Ubuntu 19.04. https://docs.microsoft.com/en-...
user avatar
2 votes
3 answers
11k views

Unable to connect Microsoft SQL-Server and Visual Studio code

I just installed MSSQL 2017 for linux and Visual Studio code for linux on my Ubuntu 18.10 machine. Both the installation succeeded, but I cannot connect from visual studio to the DB. I have the ...
user avatar
0 votes
1 answer
2k views

Problem with RODBC installation in Ubuntu with R 3.5.1

The thread here about RODBC is old, about 7 years old, their solution about installing r-cran-odbc and libiodbc2-dev do not work. As of R 3.5.1, I am getting the same error as 7 years ago install....
user avatar
  • 739
0 votes
0 answers
3k views

How to enable PDO-ODBC on Ubuntu + XAMPP in order to connect to MS-Access DB?

I want to use a mdb Access Database with PHP 7.2 on Ubuntu 18 + XAMPP. So I've installed the following packages, although not all of them may be required: sudo apt install php7.2-odbc sudo apt ...
user avatar
  • 1
4 votes
0 answers
7k views

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 ...
user avatar
7 votes
1 answer
23k views

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 ...
user avatar
  • 73
7 votes
1 answer
11k views

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 ...
user avatar
  • 251
1 vote
0 answers
104 views

unix-odbc package, undefined reference to SQLCancelHandle [duplicate]

I am trying to compile a ODBC software with the unix-odbc library which I installed with the following command on Ubuntu 16.04. apt-get install unixodbc-dev unixodbc-bin unixodbc The library worked ...
user avatar
10 votes
1 answer
6k views

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?
user avatar
  • 121
2 votes
2 answers
15k views

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 ...
user avatar
  • 123
0 votes
0 answers
103 views

ODBCCreateDataSourceQ4 vs myodbc Discontinuation

I need a DSN to connect to a MariaDB (Ubuntu's replacement for MySQL) database and seem to have run into some confusion about ODBC drivers on Ubuntu (and Linux in general). Specifically, Flora-2 ...
user avatar
0 votes
0 answers
33 views

why is freetds so outdated? [duplicate]

FreeTDS released 0.95 in June 2015 and 1.0 in May 2016, yet all I find for packages are various compiles of 0.91. Is there a problem with versions 0.95 and/or 1.0 that preclude any of debian-dom from ...
user avatar
  • 191
-1 votes
1 answer
2k views

mssql connection via odic

i have an issue connecting an mssql database via odbc in ubuntu 16.04 LTS. I have installed unix odbc and mussel driver. mssql driver is declared in odbcinst.ini : statadmin@dsc-stat:~$ cat /etc/...
user avatar
  • 1
1 vote
1 answer
5k views

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 ...
user avatar
  • 11
1 vote
1 answer
9k views

Install ODBC and Sybase on Ubuntu 16.04

I am currently building Ubuntu 16.04 server for our project. Error occurs when I'm trying to install: sudo apt-get install php5-odbc php5-sybase tdsodbc The error says: Unable to locate package ...
user avatar
  • 13
1 vote
0 answers
326 views

unixODBC access to MDB databasefile for all users

I have configured the odbc for a MS Access MDB databasefile. The access is ok when executing sudo isql -v MyDatabaseName since it returns Connected! and I get a SQL prompt and I can select data from ...
user avatar
0 votes
1 answer
1k views

[unixODBC]Missing database name in call to CC_connect

I'm on Ubuntu 16.04 x64, and I've set up both PostgreSQL and ODBC. Or I almost have; when I execute some scheme code from guile, it outputs the following error: Can't perform SQLConnect rc=-1(201) [...
user avatar
  • 101
2 votes
0 answers
409 views

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 ...
user avatar
  • 21
1 vote
1 answer
762 views

Linux Ubuntu LTS ODBC Microsoft sql

Ubuntu 14.04.1 LTS From my Ubuntu machine I want to access an MS SQL 2005 server via ODBC. This MSSQL server is on our internal network. I've installed these packages: unixodbc, unixodbc-dev, ...
user avatar
17 votes
3 answers
54k views

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 ...
user avatar
  • 1,085
0 votes
1 answer
1k views

isql working but not tsql

I'm not great with Linux but I'm able to muddle through. My final goal is to get RODBC working in a shiny app to connect to an oracle 11.1g data base. My first step was to set up the oracle client on ...
user avatar
  • 1
1 vote
0 answers
222 views

Mono generating LocalAlloc error while executing the code

I am using Ubuntu 16.04 and have installed mono, monodevelop 5.10. Earlier i was working on 14.04 with mono, monodevelop v 4.0.2. My codes were working fine in the earlier version. In the current ...
user avatar
0 votes
1 answer
1k views

Ubuntu 12.04 ODBC connection to MySQL

I have task - write CEL events into mysql. I wrote next setting: odbcinst.ini => [MySQL] Description = ODBC for MySQL Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/i386-linux-...
user avatar
  • 101
0 votes
1 answer
1k views

Working with Nodejs + MSSQL at Ubuntu

I've my nodejs app connected to MSSQL server, worked perfectly in my Windows laptop, sing mssql@npm The same app is not able to see the database in my Ubuntu laptop. I defined the mssql connectivity ...
user avatar
5 votes
1 answer
6k views

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 ...
user avatar