building unixODBC on Solaris 9

View: New views
6 Messages — Rating Filter:   Alert me  

building unixODBC on Solaris 9

by mjn :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I've built and installed unixODBC-2.2.12 on Solaris 9 (64bit SPARC).  
Libraries are in '/opt/unixODBC/lib'.

When I attempt to use any of the commands in /opt/unixODBC/bin, I see  
this:

> ld.so.1: odbcinst: fatal: libgcc_s.so.1: open failed: No such file  
> or directory
> Killed

Where might I have gone wrong? I configured thusly:
> ./configure --enable-gui=no --prefix=/opt/unixODBC

Any thoughts are welcome and appreciated. Thanks!

--
_______________________________________________
Mike Neuharth, BA, LPIC-1
Email/UNIX System Administrator
Internet Services, University of Minnesota
===============================================
"What is important, it seems to me, is not so much to defend a culture
whose existence has never kept a man from going hungry, as to extract,
from what is called culture, ideas whose compelling force is identical
with that of hunger."  -Antonin Artaud


_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

Re: building unixODBC on Solaris 9

by Nick Gorham :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

mjn wrote:

> I've built and installed unixODBC-2.2.12 on Solaris 9 (64bit SPARC).  
> Libraries are in '/opt/unixODBC/lib'.
>
> When I attempt to use any of the commands in /opt/unixODBC/bin, I see  
> this:
>
>> ld.so.1: odbcinst: fatal: libgcc_s.so.1: open failed: No such file  
>> or directory
>> Killed
>
>
> Where might I have gone wrong? I configured thusly:
>
>> ./configure --enable-gui=no --prefix=/opt/unixODBC
>
>
> Any thoughts are welcome and appreciated. Thanks!
>
I guess you used gcc to build, but the above lib is not in your
:LD_LIBRARY_PATH

--
Nick
_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

Parent Message unknown RE: building unixODBC on Solaris 9

by Stefan Radman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

It's one of the c++ runtime libraries.
If you are using sunfreeware you might find it in /usr/local/lib (as
part of the gcc or libgcc package).
http://www.sunfreeware.com/solaris9.html
If you are using the SFWgcc package from the companion CD you might find
it in /opt/sfw/lib/gcc-*

You can also try to use the -static-libgcc linker flag to avoid this
dependency.

Stefan

> -----Original Message-----
> From: unixodbc-support-bounces@...
> [mailto:unixodbc-support-bounces@...] On Behalf Of
> Nick Gorham
> Sent: Monday, 20 November, 2006 22:55
> To: Support for the unixODBC project
> Subject: Re: [unixODBC-support] building unixODBC on Solaris 9
>
> mjn wrote:
>
> > I've built and installed unixODBC-2.2.12 on Solaris 9
> (64bit SPARC).  
> > Libraries are in '/opt/unixODBC/lib'.
> >
> > When I attempt to use any of the commands in
> /opt/unixODBC/bin, I see  
> > this:
> >
> >> ld.so.1: odbcinst: fatal: libgcc_s.so.1: open failed: No
> such file  
> >> or directory
> >> Killed
> >
> >
> > Where might I have gone wrong? I configured thusly:
> >
> >> ./configure --enable-gui=no --prefix=/opt/unixODBC
> >
> >
> > Any thoughts are welcome and appreciated. Thanks!
> >
> I guess you used gcc to build, but the above lib is not in your
> :LD_LIBRARY_PATH
>
> --
> Nick
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support@...
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

Re: building unixODBC on Solaris 9

by mjn :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Thanks Nick and Stefan!

I bothered those that installed the gnu libs on our system and  
finding those libraries fixed my first problem; the bin/ commands are  
working fine.

The continuation of the saga...

I've configured this data source:
> [CFANS]
> Driver=FreeTDS
> Description=CFANS Email Database
> Trace=No
> Server=srv.sub.umn.edu
> Port=1433
> Database=email

And this driver:
> [FreeTDS]
> Description=v0.64
> Driver=/opt/freetds//lib/libtdsodbc.so
> UsageCount=1

Using odbcinst.


I have freeTDS installed and I have been able to connect to this same  
server without problems. When I connection using FreeTDS's tsql, I see:
> >/opt/freetds/bin/tsql -S CFANSTest -U user -P pass
> locale is "C"
> locale charset is "646"
> >

The FreeTDS entry for this is:
> [CFANSTest]
>         host = srv.sub.umn.edu
>         port = 1433
>         tds version = 7.0


However, when I attempt to connect with unixODBC's isql, I get this:
> > /opt/unixODBC/bin/isql CFANS user pass -v
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
> [08S01][unixODBC][FreeTDS][SQL Server]Read from SQL server failed.
> [ISQL]ERROR: Could not SQLConnect


And the DBA for the SQL server tells me that he is seeing this error  
inside the MS SQLServer logs (this is SQL SERVER 2000):
> Connection opened but invalid login packet(s) sent.  Connection  
> closed.

The one thing that pops into my head is that I did not specify a  
default protocol version when compiling FreeTDS. Anyone see this  
before and know what causes it?

Thanks again!

--
_______________________________________________
Mike Neuharth, BA, LPIC-1
Email/UNIX System Administrator
Internet Services, University of Minnesota
===============================================
"What is important, it seems to me, is not so much to defend a culture
whose existence has never kept a man from going hungry, as to extract,
from what is called culture, ideas whose compelling force is identical
with that of hunger."  -Antonin Artaud


On Nov 21, 2006, at 2:32 AM, Stefan Radman wrote:

> It's one of the c++ runtime libraries.
> If you are using sunfreeware you might find it in /usr/local/lib (as
> part of the gcc or libgcc package).
> http://www.sunfreeware.com/solaris9.html
> If you are using the SFWgcc package from the companion CD you might  
> find
> it in /opt/sfw/lib/gcc-*
>
> You can also try to use the -static-libgcc linker flag to avoid this
> dependency.
>
> Stefan

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

Parent Message unknown RE: building unixODBC on Solaris 9

by Stefan Radman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

That's rather a question for the TDS list as it is FreeTDS driver (and
MS SQL Server) specific but anyway ...

You should specify the TDS_Version with each DSN independently of the
compiled-in default e.g.

[CFANS]
Driver=FreeTDS
Description=CFANS Email Database
Trace=No
Server=srv.sub.umn.edu
Port=1433
Database=email
TDS_Version=8.0

Choosing your TDS version:
http://www.freetds.org/userguide/choosingtdsprotocol.htm

Stefan

> -----Original Message-----
> From: unixodbc-support-bounces@...
> [mailto:unixodbc-support-bounces@...] On Behalf Of mjn
> Sent: Tuesday, 21 November, 2006 21:24
> To: Support for the unixODBC project
> Subject: Re: [unixODBC-support] building unixODBC on Solaris 9
>
> Thanks Nick and Stefan!
>
> I bothered those that installed the gnu libs on our system and  
> finding those libraries fixed my first problem; the bin/
> commands are  
> working fine.
>
> The continuation of the saga...
>
> I've configured this data source:
> > [CFANS]
> > Driver=FreeTDS
> > Description=CFANS Email Database
> > Trace=No
> > Server=srv.sub.umn.edu
> > Port=1433
> > Database=email
>
> And this driver:
> > [FreeTDS]
> > Description=v0.64
> > Driver=/opt/freetds//lib/libtdsodbc.so
> > UsageCount=1
>
> Using odbcinst.
>
>
> I have freeTDS installed and I have been able to connect to
> this same  
> server without problems. When I connection using FreeTDS's
> tsql, I see:
> > >/opt/freetds/bin/tsql -S CFANSTest -U user -P pass
> > locale is "C"
> > locale charset is "646"
> > >
>
> The FreeTDS entry for this is:
> > [CFANSTest]
> >         host = srv.sub.umn.edu
> >         port = 1433
> >         tds version = 7.0
>
>
> However, when I attempt to connect with unixODBC's isql, I get this:
> > > /opt/unixODBC/bin/isql CFANS user pass -v
> > [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to
> data source
> > [28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
> > [08S01][unixODBC][FreeTDS][SQL Server]Read from SQL server failed.
> > [ISQL]ERROR: Could not SQLConnect
>
>
> And the DBA for the SQL server tells me that he is seeing this error  
> inside the MS SQLServer logs (this is SQL SERVER 2000):
> > Connection opened but invalid login packet(s) sent.  Connection  
> > closed.
>
> The one thing that pops into my head is that I did not specify a  
> default protocol version when compiling FreeTDS. Anyone see this  
> before and know what causes it?
>
> Thanks again!
>
> --
> _______________________________________________
> Mike Neuharth, BA, LPIC-1
> Email/UNIX System Administrator
> Internet Services, University of Minnesota
> ===============================================
> "What is important, it seems to me, is not so much to defend a culture
> whose existence has never kept a man from going hungry, as to extract,
> from what is called culture, ideas whose compelling force is identical
> with that of hunger."  -Antonin Artaud
>
>
> On Nov 21, 2006, at 2:32 AM, Stefan Radman wrote:
>
> > It's one of the c++ runtime libraries.
> > If you are using sunfreeware you might find it in /usr/local/lib (as
> > part of the gcc or libgcc package).
> > http://www.sunfreeware.com/solaris9.html
> > If you are using the SFWgcc package from the companion CD
> you might  
> > find
> > it in /opt/sfw/lib/gcc-*
> >
> > You can also try to use the -static-libgcc linker flag to avoid this
> > dependency.
> >
> > Stefan
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support@...
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

Re: building unixODBC on Solaris 9

by mjn :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Terrific! Stefan, that did the trick; thank you so much for all of  
the help!


--
_______________________________________________
Mike Neuharth, BA, LPIC-1
Email/UNIX System Administrator
Internet Services, University of Minnesota
===============================================
"What is important, it seems to me, is not so much to defend a culture
whose existence has never kept a man from going hungry, as to extract,
from what is called culture, ideas whose compelling force is identical
with that of hunger."  -Antonin Artaud


On Nov 22, 2006, at 2:57 AM, Stefan Radman wrote:

> That's rather a question for the TDS list as it is FreeTDS driver (and
> MS SQL Server) specific but anyway ...
>
> You should specify the TDS_Version with each DSN independently of the
> compiled-in default e.g.
>
> [CFANS]
> Driver=FreeTDS
> Description=CFANS Email Database
> Trace=No
> Server=srv.sub.umn.edu
> Port=1433
> Database=email
> TDS_Version=8.0
>
> Choosing your TDS version:
> http://www.freetds.org/userguide/choosingtdsprotocol.htm
>
> Stefan
>
>> -----Original Message-----
>> From: unixodbc-support-bounces@...
>> [mailto:unixodbc-support-bounces@...] On Behalf Of mjn
>> Sent: Tuesday, 21 November, 2006 21:24
>> To: Support for the unixODBC project
>> Subject: Re: [unixODBC-support] building unixODBC on Solaris 9
>>
>> Thanks Nick and Stefan!
>>
>> I bothered those that installed the gnu libs on our system and
>> finding those libraries fixed my first problem; the bin/
>> commands are
>> working fine.
>>
>> The continuation of the saga...
>>
>> I've configured this data source:
>>> [CFANS]
>>> Driver=FreeTDS
>>> Description=CFANS Email Database
>>> Trace=No
>>> Server=srv.sub.umn.edu
>>> Port=1433
>>> Database=email
>>
>> And this driver:
>>> [FreeTDS]
>>> Description=v0.64
>>> Driver=/opt/freetds//lib/libtdsodbc.so
>>> UsageCount=1
>>
>> Using odbcinst.
>>
>>
>> I have freeTDS installed and I have been able to connect to
>> this same
>> server without problems. When I connection using FreeTDS's
>> tsql, I see:
>>>> /opt/freetds/bin/tsql -S CFANSTest -U user -P pass
>>> locale is "C"
>>> locale charset is "646"
>>>>
>>
>> The FreeTDS entry for this is:
>>> [CFANSTest]
>>>         host = srv.sub.umn.edu
>>>         port = 1433
>>>         tds version = 7.0
>>
>>
>> However, when I attempt to connect with unixODBC's isql, I get this:
>>>> /opt/unixODBC/bin/isql CFANS user pass -v
>>> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to
>> data source
>>> [28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
>>> [08S01][unixODBC][FreeTDS][SQL Server]Read from SQL server failed.
>>> [ISQL]ERROR: Could not SQLConnect
>>
>>
>> And the DBA for the SQL server tells me that he is seeing this error
>> inside the MS SQLServer logs (this is SQL SERVER 2000):
>>> Connection opened but invalid login packet(s) sent.  Connection
>>> closed.
>>
>> The one thing that pops into my head is that I did not specify a
>> default protocol version when compiling FreeTDS. Anyone see this
>> before and know what causes it?
>>
>> Thanks again!
>>
>> --
>> _______________________________________________
>> Mike Neuharth, BA, LPIC-1
>> Email/UNIX System Administrator
>> Internet Services, University of Minnesota
>> ===============================================
>> "What is important, it seems to me, is not so much to defend a  
>> culture
>> whose existence has never kept a man from going hungry, as to  
>> extract,
>> from what is called culture, ideas whose compelling force is  
>> identical
>> with that of hunger."  -Antonin Artaud
>>
>>
>> On Nov 21, 2006, at 2:32 AM, Stefan Radman wrote:
>>
>>> It's one of the c++ runtime libraries.
>>> If you are using sunfreeware you might find it in /usr/local/lib (as
>>> part of the gcc or libgcc package).
>>> http://www.sunfreeware.com/solaris9.html
>>> If you are using the SFWgcc package from the companion CD
>> you might
>>> find
>>> it in /opt/sfw/lib/gcc-*
>>>
>>> You can also try to use the -static-libgcc linker flag to avoid this
>>> dependency.
>>>
>>> Stefan
>>
>> _______________________________________________
>> unixODBC-support mailing list
>> unixODBC-support@...
>> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>>
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support@...
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support