Questions tagged [odbc]
Open Database Connectivity (ODBC) is a standard programming language middleware application programming interface (API) for accessing database management systems (DBMS).
38
questions
0
votes
0
answers
29
views
odbcinst: symbol lookup error: odbcinst: undefined symbol: iniOpen error installing msodbcsql17
Ubuntu server 20.04.
After updating all packets, msodbcsql17 stopped working.
I've purged it and then tried to reinstall and i get an error in post-install process.
The error is
odbcinst: symbol ...
0
votes
0
answers
141
views
Connect to remote Database using DB2 from Ubuntu
I am trying to setup an Ubuntu VM as a php test development server.
However, I am having trouble connecting to our Remote Database with db2.
I am new to Ubuntu/configuring db2 and have been following ...
0
votes
0
answers
89
views
Connecting from Linux to an SQL database server?
Regarding some troubles connecting from Linux to an SQL Database Server. I read a variety of topics on this community and some DBA forums, but couldn't get it working.
Some background information:
...
- 31
3
votes
2
answers
2k
views
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 ...
- 135
1
vote
0
answers
2k
views
[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: https://learn.microsoft.com/en-us/sql/connect/odbc/...
- 111
4
votes
2
answers
8k
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 ...
- 477
1
vote
1
answer
13k
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
...
- 131
0
votes
0
answers
3k
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
1
answer
471
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 ...
- 61
5
votes
1
answer
18k
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 ...
- 173
3
votes
0
answers
115
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 ...
- 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 ...
- 21
6
votes
3
answers
8k
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 ...
- 11.8k
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-...
- 111
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 ...
- 273
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....
- 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 ...
- 1
6
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 ...
- 241
7
votes
1
answer
25k
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 ...
- 93
7
votes
1
answer
12k
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 ...
- 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 ...
- 188
10
votes
1
answer
7k
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?
- 121
2
votes
2
answers
17k
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 ...
- 123
0
votes
0
answers
110
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 ...
- 581
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 ...
- 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/...
- 1
2
votes
1
answer
6k
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 ...
- 21
1
vote
1
answer
10k
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 ...
- 113
1
vote
0
answers
332
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
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) [...
- 101
2
votes
0
answers
420
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 ...
- 21
1
vote
1
answer
905
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, ...
17
votes
3
answers
55k
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 ...
- 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 ...
- 1
1
vote
0
answers
226
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
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-...
- 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 ...
- 101
5
votes
1
answer
7k
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 ...
user390136