Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [odbc]

21 questions
4
votes
1 answer

Problems with unixODBC and SQLite

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] Description=SQLite3 ODBC…
Dánjal Salberg Adlersson
  • 429
  • 5
  • 11
2
votes
1 answer

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][Driver Manager]Can't open lib '/usr/lib/libmaodbc.so' :…
DrP3pp3r
  • 165
  • 7
2
votes
1 answer

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 Source Name data, placed in the /etc/odbc.ini…
Ramakant
  • 23
  • 5
2
votes
1 answer

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 to get unixODBC to work with MariaDB (or MySQL),…
Elliptical view
  • 3,559
  • 4
  • 25
  • 44
2
votes
1 answer

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 Server 2012 (as I am attempting to connect to a MS…
CVT
  • 21
  • 2
1
vote
0 answers

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 download odbc manager > open odbc manager > under…
IOIOIOIOIOIOI
  • 111
  • 1
1
vote
0 answers

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 with a couple of columns, which works like a…
user2305193
  • 141
  • 5
1
vote
1 answer

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 install.
Marc
  • 111
  • 3
1
vote
2 answers

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 problem. How can I call python 3.3 seperately…
PraveenMathew
  • 11
  • 2
1
vote
0 answers

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 to unistall a bunch of other things like calligra…
Elliptical view
  • 3,559
  • 4
  • 25
  • 44
1
vote
1 answer

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 am able to get a ticket for my windows user…
Michael Vincent
  • 111
  • 2
0
votes
0 answers

NetSuite drivers aren't working with MariaDB on Ubuntu 22.04: can't open lib 'opt/netsuite/odbcclient/lib64/ivoa27.so'

I'm trying to use the CONNECT engine in MariaDB to access NetSuite. I have the ODBC drivers installed and working with everything except MariaDB. Every time I try, I get this error: ERROR 1296 (HY000): Got error 174 'SQLDriverConnect:…
Brandon
  • 1
0
votes
0 answers

MySQL ODBC connector file not found

I'm trying to get the MySQL ODBC connector working, I downloaded the latest source, copied the contents of /lib to /usr/lib64/odbc which was the following files: /usr/lib64/odbc/libmyodbc8w.so /usr/lib64/odbc/libmyodbc8a.so But when I try and…
Ben
  • 123
  • 2
0
votes
1 answer

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, using ODBC. I have tried to follow the MariaDB instructions…
mike rodent
  • 1,092
  • 1
  • 11
  • 21
0
votes
0 answers

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 create my own queries and formulars. But to make…
WGRM
  • 787
  • 3
  • 14
1
2