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 <igorhmm AT gmail.com>
  • To: "Igor Korot" <ikorot AT earthlink.net>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with isql
  • Date: Sat, 10 May 2008 08:44:30 -0300

Hi Igor :-)

Sorry about this mistake... installing and deinstalling freetds
version's I leave freeTDS running without unixODBC :-(

I got freetds from cvs, make and install... configure with IP address
and now is everything working fine!! ;-)

Thanks all for the help and sorry about anything...

Igor

On Fri, May 9, 2008 at 8:10 PM, Igor Korot <ikorot AT earthlink.net> wrote:
> 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
>
> _______________________________________________
> 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