[freetds] Problems with isql

Igor igorhmm at gmail.com
Fri May 9 18:21:14 EDT 2008

Hi James,

I'm using SQL Server 2000 (SP4) and I have another server with SuSE
connecting normally...

I'll try with CVS version and tell you about anything...

This is the dump:

[root at bsd ~]# TDSDUMP=dump osql -S LekkusLOJA -U $DBUSER -P $DBPASS
looking for odbc.ini and odbcinst.ini in /usr/local/etc
	reading "/root/.odbc.ini"
[LekkusLOJA] not found in "/root/.odbc.ini"
	reading "/usr/local/etc/odbc.ini"
[LekkusLOJA] found in "/usr/local/etc/odbc.ini"
found this section:
	Description = Lekkus LOJA
	Driver = FreeTDS
	Trace = No
	Server = bzbraziline
	Port = 1401
	TDS_version = 8.0
	Database = Lekkus
looking for driver for DSN [LekkusLOJA]
driver "FreeTDS" found for [LekkusLOJA] in odbc.ini
found driver named "FreeTDS"
FreeTDS is not a readable file
looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini
driver "/usr/local/lib/libtdsodbc.so" found for [FreeTDS] in odbcinst.ini
/usr/local/lib/libtdsodbc.so is a readable file
"Server" found, not using freetds.conf
FreeTDS servername is "bzbraziline"
bzbraziline has address

                           DSN:	LekkusLOJA
             Server's hostname:	bzbraziline
                        Driver:	/usr/local/lib/libtdsodbc.so

Attempting connection as Lekkus...
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect

[root at bsd ~]# cat dump
util.c:292:Starting log file for FreeTDS 0.65.dev.20061107
	on 2008-05-09 19:18:54 with debug flags 0x4fff.
iconv.c:78:Using trivial iconv
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: (null)
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:226:IP address pointer is empty
login.c:228:Server SYBASE not found!

I've no ideas :-(

Thanks in advance!


On Fri, May 9, 2008 at 4:06 PM, James K. Lowden <jklowden at freetds.org> wrote:
> Igor wrote:
>> I've installed bind to get /bin/host to work fine.. and now FreeTDS is
>> trying to connect to correct server:
> I just committed a new version of osql to CVS HEAD that handles "server =
> a.b.c.d" correctly.  :-)
>> [root at bsd ~]# osql -S LekkusLOJA -U $DBUSER -P $DBPASS
> ...
>>                            DSN:       LekkusLOJA
>>              Server's hostname:       bzbraziline
>>                        Address:
>>                         Driver:       /usr/local/lib/libtdsodbc.so
> [so far, so good]
>> Attempting connection as lekkus...
>> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
>> [ISQL]ERROR: Could not SQLConnect
> Omph!  OK, how about this:
>        $ TDSDUMP=dump osql -S LekkusLOJA -U $DBUSER -P $DBPASS
>        $ head -20 dump
> It's in there somewhere.
> Did you mention the version of your server?   Your odbc.ini sets
> TDS_Version = 8.0.  You need SQL Server 2000 for that.  Try e.g.
>        $ TDSVER=4.2 osql -S LekkusLOJA -U $DBUSER -P $DBPASS
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

More information about the FreeTDS mailing list