Re: Problems installing Postgresql ODBC driver 32bits on Redhat 6.5 - Mailing list pgsql-odbc

On 03/15/2016 05:52 AM, Laerte Antonio de Almeida Giraldelli wrote:

Thanks Adrian,

Here are the answers:

- odbcinst.ini content:

The below shows where it is located(/etc/odbcinst.ini), not what is in it.

odbcinst -j

unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/apvmh79/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

- I have downloaded the odbc packages from:

http://rpm.pbone.net/

unixODBC-2.2.14-12.el6_3.i686.rpm
postgresql-odbc-7.2.5-1.i386.rpm

Any particular reason you are not using the RH repos?

- When I copied content file /etc/odbc.ini to /home/apvmh79/.odbc.ini

The error changed from:
[IM002][unixODBC]Missing server name, port, or database name in call to
CC_connect.

To:
[28000][unixODBC]FATAL:  no PostgreSQL user name specified in startup packet

And there is a UserName in /home/apvmh79/.odbc.ini?

The postgre server is 9.4 version.



Att.
-------------------------------------------
Laerte Antonio de A. Giraldelli
Gerência de Implantação
CPqD - Diretoria de Suporte à Decisão e Aplicações
Fone: +55 19 3705-7215
laerteg@cpqd.com.br <mailto:laerteg@cpqd.com.br>
www.cpqd.com.br <http://www.cpqd.com.br/>

"/When you make your mark in the world, watch out for guys with
erasers./" The Wall Street Journal.

2016-03-14 20:08 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>>:

    On 03/14/2016 11:49 AM, Laerte Antonio de Almeida Giraldelli wrote:

        Hello,  please

        We are trying to do a postgre isql conexion . We tried to install
        several RPM packages for postgresql-odbc 32bits, but we can't make a
        test using isql.

        We have the environment below:

        SO:Redhat 6.5
        unixODBC-2.2.14-12.el6_3.i686  (installed)
        When the pkg postgresql-odbc-7.0.2-17.i386.rpm was installed, It
        returned this error:

        isql -v rep_teste

        [01000][unixODBC][Driver Manager]Can't open lib
        '/usr/lib/psqlodbc.so' :
        file not found
        [ISQL]ERROR: Could not SQLConnect


    Did you check if the file existed at the above location or anywhere?


        When the pkg postgresql-odbc-7.2.5-1.i386.rpm was installed, the lib
        above was installed, but we got the error:


    Where was it installed?


        isql -v rep_teste

        [IM002][unixODBC]Missing server name, port, or database name in
        call to
        CC_connect.
        [ISQL]ERROR: Could not SQLConnect

        We guess the /etc/odbc.ini is correct:

        [rep_teste]
        Description         = PostgreSQL connection to SallyDB
        Driver                 = PostgreSQL
        Database            = rep_teswte
        Servername         = vmhteste
        UserName           = teste
        Password           = 123456
        Port                    = 5432
        Protocol              = 9.4
        ReadOnly            = No
        RowVersioning       = No
        ShowSystemTables    = No
        ConnSettings        =

        We think there are a postgresql-odbc package mistake but we
        can't find
        the correct package.


    What is in the odbcinst.ini file?

    What are repo(s) are you using to get the unixODBC and
    postgresql-odbc packages?


        We'll apprecciate any help. Thank !!.

        Att.
        Laerte Antonio.
        --------------------------------------------
        "/When you make your mark in the world, watch out for guys with
        erasers./" The Wall Street Journal.



    --
    Adrian Klaver

    adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com