How to change ODBC Driver Manager? Post: 302991633

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

02-14-2017

Registered User

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

pchang

View Public Profile for pchang

Find all posts by pchang

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...

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. Hardware

Difference between platform driver,codec driver and Machine driver

In general terms what are the differences platform driver,codec driver and Machine driver?

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...

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) ...

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 ...

LEARN ABOUT CENTOS

odbcinst.ini

odbcinst.ini(5) 					       unixODBC manual pages						   odbcinst.ini(5)

NAME

       /etc/odbcinst.ini - An unixODBC drivers configuration

DESCRIPTION

       /etc/odbcinst.ini  is a text configuration file for unixODBC drivers. It can be edited by hand, but the recommended way to update this file
       is to use the odbcinst(1) utility.

FILE FORMAT

       The general .ini file format is:

	      [SectionName1]
	      key1 = value1
	      key2 = value2
	      ...

	      [SectionName2]
	      key1 = value1
	      key2 = value2
	      ...

       Each ODBC driver has its own section and can be referred to by the name of its section. Recognized configuration keys are:

       Description
	      A text string briefly describing the driver.

       Driver A filesystem path to the actual driver library.

       Setup  A filesystem path to the driver setup library.

       FileUsage
	      odbcinst(1) entry, if you edit the configuration file by hand, you have to supply it yourself.

   TEMPLATE FILES
       The recommended way to manage the drivers is using the odbcinst(1) utility. You can install the drivers by supplying it with template file,
       which has the same format as this file.

EXAMPLES

       An example of the actual PostgreSQL driver:

	      [PostgreSQL]
	      Description = PostgreSQL driver for GNU/Linux
	      Driver	  = /usr/lib/psqlodbcw.so
	      Setup	  = /usr/lib/libodbcpsqlS.so
	      FileUsage   = 1

       By specifying the driver like that, you can then reference it in the odbc.ini(5) as follows:

	      Driver = PostgreSQL

       The recommended way to add that driver is by creating template file containg:

	      [PostgreSQL]
	      Description = PostgreSQL driver for GNU/Linux
	      Driver	  = /usr/lib/psqlodbcw.so
	      Setup	  = /usr/lib/libodbcpsqlS.so

       and call the odbcinst(1):

	      # odbcinst -i -d -f template.ini

SEE ALSO

       odbcinst(1), 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							  Thu 27 Jun 2013						   odbcinst.ini(5)