Sponsored Content
Operating Systems Linux How to change ODBC Driver Manager? Post 302991633 by pchang on Tuesday 14th of February 2017 03:59:57 PM
Old 02-14-2017
How to change ODBC Driver Manager?

Hi Forum.

I have been searching this information for a while but to no avail.

I'm running the following command odbcinst -j on a Linux box and get the following:

Code:
unixODBC 2.3.0
DRIVERS............: //opt/Progress/DataDirect/Connect64_for_ODBC_71/odbcinst.ini
SYSTEM DATA SOURCES: /odbc.ini
FILE DATA SOURCES..: /ODBCDataSources
USER DATA SOURCES..: /opt/Progress/DataDirect/Connect64_for_ODBC_71/odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

It seems that the OS wants to use the unixODBC Driver Manager and I want to be able to change it to a different Driver Manager.

What environment variable that I need to set to use something different? For example a DataDirect ODBC Driver Manager.

Thanks

Last edited by rbatte1; 02-15-2017 at 09:59 AM.. Reason: Added ICODE tags
 

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

ODBC Driver for UNIX

I have no experiance in Unix and I am trying to help our DBAs set up a connection from a Unix Oracle box to a DB2 database on an AS400 server. Does anyone know where I might find a good generic ODBC driver for Unix that should be able to connect to AS400? Any links to sites that would help would... (0 Replies)
Discussion started by: doctorofstyle
0 Replies

2. Shell Programming and Scripting

DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Here is part of my program code: #Collect the output of test database and count the no #of rows too while(my @array = $tstDbStatementHandle->fetchrow_array) { push @tstDbOutputArray,; $tstDbOutputRows++; } ... (3 Replies)
Discussion started by: sameerstephen
3 Replies

3. Hardware

Difference between platform driver,codec driver and Machine driver

In general terms what are the differences platform driver,codec driver and Machine driver? (1 Reply)
Discussion started by: rupeshkp728
1 Replies

4. Linux

rpm packaging issue for unixodbc driver manager

Hi All, I am trying to make rpm package for unixODBC driver manager 2.3.0 using below spec file. During rpmbuild i am getting the error. Can you pls advice how we can overcome this issue %define name unixODBC %define ver 2.3.0 %define prefix /usr %define sysconfdir /etc %define libdir... (2 Replies)
Discussion started by: kamauv234
2 Replies

5. Red Hat

Linux ODBC driver issue

Hi Gurus, I have a odbc in Linux. when I run command ldd. I got following result: # ldd DWora26.so linux-vdso.so.1 => (0x00007fff26355000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc31e70a000) librt.so.1 => /lib64/librt.so.1 (0x00007fc31e501000) ... (1 Reply)
Discussion started by: ken6503
1 Replies

6. SCO

How to change raid controller driver ? (hardware change)

Hello I'm trying to virtualize an instance of Sco Unix 5.0.5 in VirtualBox (called VM-A) , but sco I have problems set to launch with the new raid controller . The physical machine has a raid controller adaptec (alad driver) but VirtualBox uses buslogic (blc driver) What ... (3 Replies)
Discussion started by: flako
3 Replies
odbcinst(1)						       unixODBC manual pages						       odbcinst(1)

NAME
odbcinst - An unixODBC tool for manipulating configuration files SYNOPSIS
odbcinst ACTION OBJECT OPTIONS DESCRIPTION
odbcinst is a command line tool which has been created for allowing people who are developing the install scripts/RPMs for Drivers to be able to easily create/remove entries in odbc.ini and odbcinst.ini. This command line tool is a complement to the shared library of the same name (libodbcinst.so). This tool is a part of the odbcinst component of unixODBC. OPTIONS
ACTIONS -i Install (add section to config file) new OBJECT. -u Uninstall (remove section from config file) existing OBJECT. -q Query the config files and print the options for specified OBJECT. -j Prints current configuration of unixODBC, listing (among others) the paths to the configuration files. -c Calls SQLCreateDataSource -m Calls SQLManageDataSources --version Prints program version and exits. OBJECTS -d The ACTION affect drivers (and thus the odbcinst.ini configuration file). -s The ACTION affect data sources (and thus the user or system odbc.ini configuration file). OPTIONS -f FILE The FILE is template file, describing the configuration of installed OBJECT (only valid for the -i ACTION). -r Same as the -f OPTION, only take the standard input as the template file. -n NAME Specifies the NAME of the OBJECT. -v Turn off verbose mode. This turns off all information, warning and error messages. -l The specified data source is system-wide. Has any effect only with the -s OBJECT. -h The specified data source is user-specific. Has any effect only with the -s OBJECT. RETURN VALUES
This command returns zero on success and non-zero value on failure. FILES
/etc/odbinst.ini Configuration file containing all the database drivers specifications. See odbcinst.ini(5) for more details. /etc/odbc.ini System-wide data sources specifications. See odbc.ini(5) for more details. $HOME/.odbc.ini User-specific data sources specifications. See odbc.ini(5) for more details. SEE ALSO
odbcinst.ini(5), odbc.ini(5) AUTHORS
The authors of unixODBC are Peter Harvey <pharvey@codebydesign.com> and Nick Gorham <nick@easysoft.com>. For the full list of contributors see the AUTHORS file. COPYRIGHT
unixODBC is licensed under the GNU Lesser General Public License. For details about the license, see the COPYING file. version 2.3.1 Wed 26 Jun 2013 odbcinst(1)
All times are GMT -4. The time now is 08:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy