Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problems with isql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor Korot <ikorot AT earthlink.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with isql
  • Date: Fri, 9 May 2008 19:10:56 -0400 (EDT)

Igor,

-----Original Message-----
>From: Igor <igorhmm AT gmail.com>
>Sent: May 9, 2008 6:46 PM
>To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
>Subject: Re: [freetds] Problems with isql
>
>Hi James,
>
>I'm trying with CVS version and now the IP address is accepted fine..
>but doesn't connect :-(
>
>Check full log:
>
>[root@bsd ~/free/freetds/src/apps]# ./tsql -C
>Compile-time settings (established with the "configure" script)
> Version: freetds v0.83.dev.20080509
> freetds.conf directory: /usr/local/etc
> MS db-lib source compatibility: no
> Sybase binary compatibility: no
> Thread safety: yes
> iconv library: no
> TDS version: 5.0
> iODBC: no
> unixodbc: no
>[root@bsd ~/free/freetds/src/apps]# ./tsql -S 192.168.1.21 -U $DBUSER -P
>$DBPASS
>locale is "C"
>locale charset is "US-ASCII"
>1>
>[root@bsd ~/free/freetds/src/apps]# 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:
> [LekkusLOJA]
> Description = Lekkus LOJA
> Driver = FreeTDS
> Trace = No
> Server = 192.168.1.21
> 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
>Server is "192.168.1.21"
>looking up hostname for ip address 192.168.1.21
>bzbraziline has address 192.168.1.21
>
> DSN: LekkusLOJA
> Driver: /usr/local/lib/libtdsodbc.so
> Server's hostname: bzbraziline
> Address: 192.168.1.21
>
>Attempting connection as lekkus ...
>+ exec isql LekkusLOJA lekkus *********** -v
>[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
>[ISQL]ERROR: Could not SQLConnect
>[root@bsd ~/free/freetds/src/apps]# cat dump
>util.c:292:Starting log file for FreeTDS 0.65.dev.20061107
> on 2008-05-09 19:42:28 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!
^^^^^^

Apparently you are connecting to the Sybase server and not MS one.
How did you configure freeTDS?

>mem.c:565:tds_free_all_results()
>odbc.c:3339:SQLFreeConnect(0x8060400)
>
>I really don't know what is happening...
>
>Thanks again !
>
>Igor

Thank you.

P.S.: Yes, it appears you're not the only Igor on earth... ;-)

>
>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@bsd ~]# osql -S LekkusLOJA -U $DBUSER -P $DBPASS
>> ...
>>> DSN: LekkusLOJA
>>> Server's hostname: bzbraziline
>>> Address: 192.168.1.21
>>> 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
>>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page