Questions tagged [odbc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
68 views

Mac OS - specified driver could not be loaded

Objective Goal is to use an odbc connection between bigquery and excel. However, excel can't find the driver per the error image below. Steps taken so far: download odbc driver from google partner ...
0 votes
1 answer
473 views

Can't get ODBC working with MariaDB

Linux Mint 20 (Ubuntu 20). MariaDB version: "mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2" I want to run LibreOffice Base as the front end, ...
  • 1,052
0 votes
0 answers
88 views

How to change ODBC Configuration USER DATA SOURCES

I'm attempting to setup an ODBC connection on a new EC2 Linux2 instance on AWS. I'm capable, but inexperienced with CLI and no expert by any means. I'm following our vendor's instructions for setting ...
0 votes
0 answers
32 views

Linux - Moved odbc.ini file from home directory

I wanted to rename my odbc.ini(old name) file name to .odbc.ini (new name). I used mv odbc.ini .odbc.ini command in the same directory. However,accidentally it got deleted from my homefolder.I want to ...
0 votes
0 answers
33 views

Table relations in Base with ODBC connected SQlite ZeitgeistDB (Base tells not supported)

There aren't too many programs, that provide access to the ZeitgeistDB in Linux. Tracker-Needle in Debian isn't even available, anymore. So i thought i might use LibreOffice Base to access the DB and ...
  • 767
0 votes
1 answer
161 views

Help my Python script communicate from Linux to ODBC inside KVM/Windows

I'm using the module pyodbc in a Python script to connect to the Intuit application QuickBooks over a network. To accomplish this I'm using an ODBC plugin/DLL called QRemote. This is all very easy and ...
  • 563
0 votes
1 answer
198 views

No package available on installing php_odbc on Centos7.9

I am trying to install php_odbc using yum install. But it shows me the following. Loaded plugins: fastestmirror, universal-hooks Determining fastest mirrors epel/x86_64/metalink ...
  • 1
1 vote
0 answers
163 views

MariaDB connector (remote)

I'm new to databases and have some very basic how-to/where-to questions: I have successfully setup a MariaDB + phpmyadmin on my raspberrypi zero (running the latest diet-pi), including a database ...
0 votes
1 answer
664 views

NetSuite 64bit ODBC Driver installation on Ubuntu 18.04 Cluster giving error:- Can't open lib '/opt/netsuite/odbcclient/lib64/ivoa27.so

Have been running around this issue since 2-3 days now with no luck. Hope someone guides me and help resolve this issue here. I am running a Python application from /home/admin/app/example.py ...
  • 111
2 votes
1 answer
2k views

unixODBC: Cannot load libmaodbc.so

I'm working on an embedded platform and I am trying to access a MariaDB through unixODBC. Trying to test the connection with isql I get the response: isql -v mydsn myuser mypw [01000][unixODBC][...
  • 165
0 votes
1 answer
585 views

/etc/odbcinst.ini used by 64 and 32 bits applications

I have the following /etc/odbcinst.ini file [root@]# cat /etc/odbcinst.ini [FreeTDS] Description=FreeTDS odbc driver #Driver=/usr/lib/libtdsodbc.so.0 Driver=/usr/lib64/libtdsodbc.so.0 UsageCount=1 I ...
  • 339
1 vote
1 answer
706 views

Install libmyodbc on Ubuntu Yakkety (16.10)

How do I install libmyodbc on Yakkety? It was in Xenial, but I'm getting Package 'libmyodbc' has no installation candidate any thoughts? It's necessary for another piece of software i'm trying to ...
  • 111
2 votes
1 answer
803 views

Does SQLDriverConnect (from unix-odbc) cache the DSN data? If so, how can I clear/purge it?

While using the UNIX-ODBC libraries from unixodbc site, I'm facing a problem with the SQLDriverConnect api. If I try to connect to my database twice in a row, first with incorrect DSN data (Data ...
1 vote
2 answers
244 views

Install python library on non-default python version

The system (RHEL 6.5) already have python installed in /usr/bin/python I installed another version(3.3) in another directory /data/tools/python3, as I do not have root permission. Now, I have 2 ...
0 votes
1 answer
354 views

ODBC Authentication with .pem files on Ubuntu server with Python

Using the below 3 PEM files I am able to connected successfully to a MySQL database on windows threw setting up a Data Source. (No problems here) client-key.pem client-cert.pem ca-cert.pem But I ...
1 vote
0 answers
143 views

unixODBC and iODBC installed at the same time?

Is there any conflict with having unixODBC and iODBC installed at the same time? (It seems that some programs might depend on one or the other, at least if I try to uninstall iODBC, it also wants ...
2 votes
1 answer
7k views

Connect to MariaDB (mysql) and MS Access mdb databases via localhost using unixODBC on Debian?

I'm a relative linux newby just trying to move my computing from Windows 10 to Debian. I have been struggling to setup shared dual boot access to my MS Access data bases. I have found it very hard ...
2 votes
1 answer
1k views

unixODBC 2.3.0 "_S_create_c_locale name not valid" error

I am attempting to setup HANA Smart Data Access on an SLES 11 sp3 environment. For HANA to communicate with external data sources unixODBC 2.3.0 is used along with Microsoft ODBC Driver 11 for SQL ...
  • 21
1 vote
1 answer
83 views

ODBC connection from a Linux box to MS SQLServer

I need to connect to MS SQLServer from a Linux box using ODBC from a Qt application I am developing. So far I have installed the ODBC MS SQLServer driver and Kerberos on the Linux box. Using kinit I ...
0 votes
1 answer
876 views

FreeTDS missing encryption support to connect to MS SQL

I'm running a Gentoo Linux and I'm trying to connect to MS SQL via pyodbc using freetds. I enabled the debug log in freetds. Now when I try to connect I'm seeing this: 18:13:00.841828 13523 (net.c:...
  • 8,333
4 votes
1 answer
4k views

Problems with unixODBC and SQLite [closed]

I installed unixodbc, sqlite3 and libsqliteodbc. odbcinst.ini looks like this: [SQLite] Description=SQLite ODBC Driver Driver=libsqliteodbc.so Setup=libsqliteodbc.so UsageCount=2 [SQLite3] ...