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: "Chad Sikorra" <chad.sikorra AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with isql
  • Date: Sat, 10 May 2008 23:43:55 -0500

Maybe try adding the following to the end of your ~/.bashrc file
(Assuming you're using bash as default)

export TDSVER=8.0

Then logout and back in.

On Sat, May 10, 2008 at 11:25 PM, Devinder Singh <devinbhullar AT gmail.com>
wrote:
> Hi ,
>
> How can i change the TDS Version from 5.0 to 8.0
>
> When i run tsql -c i get something like this. Even thoug i have uypdated
> freetds.conf file
>
> to Version 8.0 i tsql -C still says Version 5.0. I have uninstalled freetds
> and ran ./configure --tdsver8.0 but still i geth TDS version 5.0 Pls could
> someone help .
>
>
> tsql -C
> Password:
> locale is "C"
> locale charset is "646"
> Compile-time settings (established with the "configure" script):
> Version: freetds v0.62.dev.20030804
> MS db-lib source compatibility: no
> Sybase binary compatibility: unknown
> Thread safety: no
> iconv library: no
> TDS version: 5.0
> iODBC: no
> unixodbc: yes
>
> 2008/5/11 Devinder Singh <devinbhullar AT gmail.com>:
>
>> Hi Igor
>>
>> I think im haveing the same problem TDS version 5.
>>
>>
>> Ok i read this from the php mssql site. Do i need to enable msdblib and
>> dbmfix the last time tried it could not find them.
>>
>> INSTALLING FREETDS
>>
>> 1-. Download freetds -> www.freetds.org
>> 2-. tar -zxvf freetds-stable-tgz
>> 3-. cd freetds-0.62.3
>> 4-. ./configure --prefix=/usr/local/freetds --with-tdsver=8.0
>> --enable-msdblib --enable-dbmfix --with-gnu-ld
>>
>> Add the next text in freetds.conf ( /usr/local/freetds/etc )
>> [TDS]
>> host = <ip of the Server with Sql>
>> port = 1433
>> tds version = 8.0
>> I could not connect wven i added VErsion 8
>>
>> When i Ran tsql -C
>>
>> i still gert TDS version 5.
>>
>> Pls help .
>>
>> I sther a full detailed instrctions to set up Frree TDS and MSSQL 2000.
>>
>> Thanks
>>
>> Devinder
>>
>>
>>
>> 2008/5/10 Igor <igorhmm AT gmail.com>:
>>
>>> 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
>>> >
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS AT lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>
>>
>>
>> --
>> Devinder
>
>
>
>
> --
> Devinder
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



--
Chad Sikorra




Archive powered by MHonArc 2.6.24.

Top of Page