FreeTDS Development Group

["Lowden, James K" <james.k.lowden AT alliancebernstein.com>]

> From: Perry Taylor
> Sent: Wednesday, January 03, 2007 2:20 PM
> 
> when I try to connect from within our
> IBM/UniVerse database environment I get the following error message...
> 
> SQLConnect error:   Status = -1   SQLState = S1000   Natcode = 0
> [ODBC] [FreeTDS][SQL Server]Unable to connect to data source
...
> When I enable TDSDUMP and here is what I get...
> 
> util.c:288:Starting log file for FreeTDS 0.64
>         on 2007-01-03 12:00:49 with debug flags 0x4fff.
> iconv.c:195:names for ISO-8859-1: ISO-8859-1
> iconv.c:195:names for UTF-8: UTF-8
> iconv.c:195:names for UCS-2LE: UCS-2LE
> iconv.c:195:names for UCS-2BE: UCS-2BE
> iconv.c:361:iconv to convert client-side data to the "ISO-8859-1"
character 
> set
> iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
> login.c:209:IP address pointer is empty
> login.c:211:Server SYBASE not found!
> mem.c:519:tds_free_all_results()
> 
> I'm completely baffled as to why it would even be looking for a
> server named "SYBASE".  

"SYBASE" is the default-default last-ditch name FreeTDS attempts to
connect with if nothing it's passed works.  (These days, that's not much
of a feature.)   Because your odbc.ini uses 'Server' instead of
'Servername', you're presumably trying to connect to a DSN named "SQL1".
That points you to a machine named 'devsqll'.  Is there such a machine
on your network?  

I think TDSDUMPCONFIG is your friend here.  I think it will show you
what config files are being traversed.  Also, current snapshots include
my shell script 'osql', which I wrote to help people debug their ODBC
setup.  Please try it and let me know how you fare.  

HTH.  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent 
responsible
for delivering this message to the intended recipient, any review, 
dissemination,
distribution or duplication of this communication is strictly prohibited. If 
you are
not the intended recipient, please contact the sender immediately by reply 
e-mail
and destroy all copies of the original message. Please note that we do not 
accept
account orders and/or instructions by e-mail, and therefore will not be 
responsible
for carrying out such orders and/or instructions.  If you, as the intended 
recipient
of this message, the purpose of which is to inform and update our clients, 
prospects
and consultants of developments relating to our services and products, would 
not
like to receive further e-mail correspondence from the sender, please "reply" 
to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the Americas, New 
York,
NY 10105.