snowflake-cloud-data-platform - Unixodbc yields "file not found" error when trying to query Snowflake via ODBC - TagMerge
3Unixodbc yields "file not found" error when trying to query Snowflake via ODBCUnixodbc yields "file not found" error when trying to query Snowflake via ODBC

Unixodbc yields "file not found" error when trying to query Snowflake via ODBC

Asked 1 years ago
0
3 answers

Snowflake ODBC is not supported on Alpine (which sucks). One issue is glib, though even if you get past that it doesn't seem to matter.

https://docs.snowflake.com/en/release-notes/requirements.html#label-client-operating-system-support

Source: link

0

An ODBC-JDBC gateway allows an application that uses the ODBC API to talk to a JDBC Driver:
application <-> ODBC API <-> JDBC API <-> database
A JDBC-ODBC bridge is the opposite of an ODBC-JDBC one. A JDBC-ODBC bridge allows a Java application using JDBC to access an ODBC driver:
Java application <-> JDBC <-> ODBC driver <-> database
The unixODBC source distribution is a gzipped tar file. Uncompress it and then untar the resultant file e.g.
gunzip unixODBC-2.2.12.tar.gz
tar -xvf unixODBC-2.2.12.tar
Change into the resultant directory and run:
./configure --help
In unixODBC ODBC drivers are defined in the odbcinst.ini file. The location of this file is a configure-time variable defined with --sysconfdir but is always the file odbcinst.ini in the --sysconfdir defined path. If unixODBC is already installed you can use unixODBC's odbcinst program to locate the odbcinst.ini file used to defined drivers:
$ odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/auser/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

Source: link

0

+-------------------------------------------------------------+
| unixODBC                                                    |
+-------------------------------------------------------------+

README
---------------------------------------------------------------

Description:

	unixODBC is an Open Source ODBC sub-system and an ODBC SDK
	for Linux, Mac OSX, and UNIX. 
	
License:
	
	All libraries are LGPL Version 2.1
	
	All programs are GPL Version 2.0.

Parts:
	unixODBC includes the following;
	
	- Driver Manager
	- Installer Library and command line tool
	- Command Line Tools to help install a driver and work with SQL
	

How To Start:

	Look for and read README files with extensions of interest. Then
	read the INSTALL file.
	
	You can also jump into the doc directory and browse information 
	there. And do not forget the online stuff.
	
	Some documentation may be a bit out of date the vast majority of
	it should be ok.
	
Config Files:

	The ODBC Installer Library is responsible for reading and writing
	the unixODBC config files. 
	
	The savvy can look at;
	 
	_odbcinst_SystemINI.c
	_odbcinst_UserINI.c
	
	In any case; you can override where unixODBC looks for its system
	config files by setting the ODBCSYSINI environment variable during 
	the use of unixODBC.
      
Resources:

        http://sourceforge.net/projects/unixodbc/
        https://github.com/lurcher/unixODBC/
        http://www.unixodbc.org/

Source: link

Recent Questions on snowflake-cloud-data-platform

    Programming Languages