FreeTDS Development Group

["Devinder Singh" <devinbhullar AT gmail.com>]

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