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
0
votes
0answers
89 views

Location of ODBC driver in 20.04?

Where in Ubuntu 20.04 is libmyodbc.so? I'm stuck in driver hell. I'm attempting to connect to a MySQL database with LibreOffice Base. I attempted to follow the Ubuntu ODBC Instructions, but it appears ...
0
votes
1answer
34 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 ...
0
votes
0answers
20 views

SQL 2000 db connection via Ubuntu Server possible?

I have an odd question, but, is there a way via odbc to connect to sql 2000 somehow from Ubuntu? Thanks in advance
0
votes
0answers
63 views

Can't install R package 32-bits in Ubuntu 18.04 64-bits

OS: Ubuntu 18.04 64 bits R: 3.5.3 (2019-03-11) -- "Great Truth" - i686-pc-linux-gnu (32-bit) I want to connect R to Firebird database. To accomplish this, I'm using unixODBC, Firebird super-server, ...
5
votes
1answer
4k 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 ...
3
votes
0answers
55 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 ...
1
vote
0answers
234 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 ...
5
votes
2answers
677 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 ...
1
vote
1answer
2k 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-...
2
votes
3answers
4k 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 ...
0
votes
1answer
1k 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....
0
votes
0answers
2k 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 ...
2
votes
0answers
4k 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 ...
5
votes
1answer
12k 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 ...
5
votes
1answer
6k 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 ...
1
vote
0answers
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 ...
8
votes
1answer
3k 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?
1
vote
2answers
8k 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 ...
0
votes
0answers
87 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 ...
0
votes
0answers
29 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 ...
-1
votes
1answer
1k 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/...
1
vote
1answer
3k 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 ...
0
votes
1answer
3k views

How to install libmyodbc on Ubuntu 16.04

I'm trying to install libmyodbc on ubuntu 16.04 so I can migrate a Sql Server .mdf file into MySql. apt-get install libmyodbc doesn't work. I suspect I'll need a management tool as well to add DSN's. ...
1
vote
1answer
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 ...
1
vote
0answers
305 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 ...
0
votes
1answer
840 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) [...
2
votes
0answers
369 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 ...
1
vote
1answer
624 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, ...
16
votes
3answers
49k 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 ...
0
votes
1answer
754 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 ...
1
vote
0answers
211 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 ...
0
votes
1answer
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-...
0
votes
1answer
967 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 ...
5
votes
1answer
4k 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 ...