[unixODBC-support] building unixODBC on Solaris 9
mjn at umn.edu
Wed Nov 22 13:27:44 GMT 2006
Terrific! Stefan, that did the trick; thank you so much for all of
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.
> Description=CFANS Email Database
> Choosing your TDS version:
>> -----Original Message-----
>> From: unixodbc-support-bounces at easysoft.com
>> [mailto:unixodbc-support-bounces at easysoft.com] 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:
>>> Description=CFANS Email Database
>> And this driver:
>> 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:
>>> 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
>>> [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
>> 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
>> whose existence has never kept a man from going hungry, as to
>> from what is called culture, ideas whose compelling force is
>> 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).
>>> If you are using the SFWgcc package from the companion CD
>> you might
>>> it in /opt/sfw/lib/gcc-*
>>> You can also try to use the -static-libgcc linker flag to avoid this
>> unixODBC-support mailing list
>> unixODBC-support at easysoft.com
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
More information about the unixODBC-support