Questions tagged [odbc]
The odbc tag has no usage guidance.
20 questions
0
votes
0
answers
56
views
Change location of user defined odbc
BY default "USER DATA SOURCES" must be $HOME/.odbc.ini, But in a newly built RHEL8 server is showing the below result. Is its possible to update the "USER DATA SOURCES" location as ...
- 9,152
1
vote
0
answers
140
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
...
- 111
0
votes
1
answer
2k
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,162
0
votes
0
answers
39
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 ...
- 828
0
votes
1
answer
238
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 ...
- 593
0
votes
1
answer
406
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
233
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 ...
- 143
0
votes
1
answer
1k
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
3k
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
901
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 ...
- 359
1
vote
1
answer
913
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
999
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 ...
- 23
1
vote
2
answers
334
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
480
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
167
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 ...
- 4,169
2
votes
1
answer
8k
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 ...
- 4,169
2
votes
1
answer
2k
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
123
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 ...
- 111
0
votes
1
answer
992
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,663
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]
...
