[unixODBC-support] (unixODBC 2.3.1 OR unixODBC 2.2.14) AND PostgreSQL 9.1 AND Solaris 10 AND psqlodbc-09.01.0100

Hernan Saltiel hsaltiel at gmail.com
Sun Jun 3 16:07:18 BST 2012


On Sun, Jun 3, 2012 at 5:47 AM, Nick Gorham <nick at lurcher.org> wrote:

>  On 02/06/2012 23:18, Hernan Saltiel wrote:
>
>
>
> On Sat, Jun 2, 2012 at 6:01 PM, Nick Gorham <nick at lurcher.org> wrote:
>
>> On 02/06/2012 17:57, Hernan Saltiel wrote:
>>
>>> Hi all!
>>>
>>> I'm having several issues trying to make the combination of unixODBC
>>> 2.3.1 + psqlodbc-09.01.0100 + Solaris 10 SPARC working.
>>> At the beggining, I tried compiling unixODBC 2.3.1 with gcc 3.4.6
>>> downloaded from Sunfreeware.com. To install Postgresql 9.1 and gcc 3.4.6, I
>>> needed also libiconv, libintl, zlib, etc. All of this installs in
>>> /usr/local, and Postgresql installs in /usr/local/pgsql.
>>> unixODBC 2.3.1 compiles perfectly, and also psqlodbc-09.01.0100.
>>> The problem arises when trying to connect to a database I created for
>>> test purposes.
>>> I created the scweb database with only one table.
>>> I wrote the /usr/local/etc/odbcinst.ini with this contents:
>>>
>>
>>  Is it a 32 or 64 bit build?
>>
>
>  Hi!
>
>  This is the output of isainfo:
>
> # isainfo -v
> 64-bit sparcv9 applications
>         vis
> 32-bit sparc applications
>         vis v8plus div32 mul32
>
>
> Ok, what does
>
> file /usr/local/bin/isql
>
> show you, A 32 or 64 bit binary
>

Hi, Nick!

Is a 32 bits binary:

# file /usr/local/bin/isql
/usr/local/bin/isql:    ELF 32-bit MSB executable SPARC Version 1,
dynamically linked, not stripped


>
> Also, does ldd on the postgres driver show it linked against libodbc* from
> the configure line it looks like it should.
>

Yes, it does. Here is the output of ldd:

# ldd /usr/local/lib/psqlodbcw.so
        libpq.so.5 =>    /usr/local/pgsql/lib/libpq.so.5
        libpthread.so.1 =>       /usr/lib/libpthread.so.1
        libodbcinst.so.1 =>      /usr/local/lib/libodbcinst.so.1
        libodbc.so.1 =>  /usr/local/lib/libodbc.so.1
        libdl.so.1 =>    /usr/lib/libdl.so.1
        libthread.so.1 =>        /usr/lib/libthread.so.1
        libc.so.1 =>     /usr/lib/libc.so.1
        libgcc_s.so.1 =>         /usr/local/lib/libgcc_s.so.1
        libsocket.so.1 =>        /usr/lib/libsocket.so.1
        libnsl.so.1 =>   /usr/lib/libnsl.so.1
        libmp.so.2 =>    /usr/lib/libmp.so.2
        libmd.so.1 =>    /usr/lib/libmd.so.1
        libscf.so.1 =>   /usr/lib/libscf.so.1
        libdoor.so.1 =>  /usr/lib/libdoor.so.1
        libuutil.so.1 =>         /usr/lib/libuutil.so.1
        libgen.so.1 =>   /usr/lib/libgen.so.1
        libm.so.2 =>     /usr/lib/libm.so.2
        /platform/SUNW,Ultra-4/lib/libc_psr.so.1
        /platform/SUNW,Ultra-4/lib/libmd_psr.so.1

 Thanks a lot for your help!
Best regards,

HeCSa.



>
> --
> Nick
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>


-- 
HeCSa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20120603/99cec40b/attachment.html>


More information about the unixODBC-support mailing list