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
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 ...
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 ...
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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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:
...
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
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 ...
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 ...
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 ...
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) [...
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
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/...