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
24 views

Using sqlcmd and bcp throws error: For bcp it's “Unable to load BCP resource DLL” and for sqlcmd it's “Unable to load SQLCMD resource files”

I'm using ubuntu 20.04, it was completely clear new installation before the attemp to put ms sql on it. And I need to install SQL server and it's tools, so I followed these instructions. https://docs....
0
votes
0answers
666 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:...
0
votes
0answers
3k 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
140 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 ...
5
votes
1answer
10k 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
65 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
638 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 ...
6
votes
2answers
3k 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
3k 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
9k 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
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....
0
votes
0answers
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 ...
2
votes
0answers
5k 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 ...
6
votes
1answer
19k 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 ...
6
votes
1answer
9k 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
5k 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
11k 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
93 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
32 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
4k 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 ...
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
316 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
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) [...
2
votes
0answers
391 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
664 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
52k 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
925 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
213 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
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 ...
5
votes
1answer
5k 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 ...