Questions tagged [odbc]

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

21 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
0 answers
8k 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 ...
James Cobban's user avatar
3 votes
2 answers
4k 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 ...
frank's user avatar
  • 135
3 votes
0 answers
128 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 ...
C. Geek's user avatar
  • 31
2 votes
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/...
BigLeo's user avatar
  • 121
2 votes
0 answers
2k 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 ...
Alex's user avatar
  • 21
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 ...
Bahram's user avatar
  • 21
2 votes
0 answers
442 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 ...
mudrock's user avatar
  • 21
1 vote
0 answers
341 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 ...
Brian Vind Borgstrøm's user avatar
1 vote
1 answer
934 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, ...
Santosh Dhage's user avatar
1 vote
0 answers
228 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 ...
Abhinav Aggarwal's user avatar
0 votes
0 answers
98 views

Best way to install MySQL ODBC Connector on Ubuntu 22.04

I'm running a FileMaker Server on Ubuntu 22.04 where I've also installed mysql-connector-odbc. Everything has been a test server and now I tried to reinstall everything again. From Scratch. But this ...
Johan's user avatar
  • 1
0 votes
0 answers
55 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 ...
Massimiliano Muccinelli's user avatar
0 votes
0 answers
339 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 ...
BoogaBooga's user avatar
0 votes
0 answers
234 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: ...
Aad Dijksman's user avatar
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:...
AkaAndrew's user avatar
0 votes
1 answer
550 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 ...
mithun_ghose's user avatar
0 votes
0 answers
4k 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 ...
John's user avatar
  • 1
0 votes
0 answers
112 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 ...
James Bowery's 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) [...
Chiffa's user avatar
  • 101
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 ...
Cubiod's user avatar
  • 1
-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/...
Thomas's user avatar
  • 1