Thread: ODBC on Solaris

ODBC on Solaris

From
Michael Sims
Date:
Greetings all,

I wish to use PostgreSQL via ODBC from a Solaris machine.

I've compiled the ODBC driver, set up the pgsql server on my Linux box,
and discovered the hard way that the pgsql ODBC driver is case-sensitive
when it comes to the names of the values in .odbc.ini.  I have even gotten
my client to connect.

However, when I try to read the names of the tables present using
SQLTables(), I get the following error: "Couldn't allocate statement for
SQLTables result."  This also happens for SQLExecDirect().

I've searched the web and mailing list archives and have found the Linux
solution for an older version of the driver (needing to add -lm -lc
-Bsymbolic), but nothing for Solaris.  Is there an analogous fix I can
make?

I'm using Solaris 2.7, PostgreSQL 7.0.3, and pgsqlODBC 0.26.

Thanks for your time.
Mike

-- 
msims@pumatech.com






Re: ODBC on Solaris

From
Peter Eisentraut
Date:
Michael Sims writes:

> I've searched the web and mailing list archives and have found the Linux
> solution for an older version of the driver (needing to add -lm -lc
> -Bsymbolic), but nothing for Solaris.  Is there an analogous fix I can
> make?

The same one.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



Re: ODBC on Solaris

From
Michael Sims
Date:
Comrade Peter Eisentraut, hero of the people, wrote:

> Michael Sims writes:
>
> > I've searched the web and mailing list archives and have found the Linux
> > solution for an older version of the driver (needing to add -lm -lc
> > -Bsymbolic), but nothing for Solaris.  Is there an analogous fix I can
> > make?
>
> The same one.

Hey, it works.  Color me lame for not actually trying it first.  Thanks a
lot, Peter!
Mike

-- 
msims@pumatech.com