Questions tagged [odbc]

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

1
vote
2answers
349 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
529 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
594 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 ...
0
votes
0answers
1k 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
2k 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 ...
3
votes
1answer
1k views

Cant find pyodbc driver despite install

I have pyodbc installed and I am trying to connect to a server, but I pyodbc cant find the drivers. I did: pip install pyodbc followed the Microsoft instructions here ran a test script: import ...
1
vote
0answers
68 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 ...
5
votes
0answers
2k 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
3k 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
69 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
674 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
2k 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
7k 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
257 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
618 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
293 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
368 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, ...
15
votes
3answers
42k 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
485 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
203 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
804 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
794 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 ...
3
votes
1answer
3k 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 ...