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: "Devinder Singh" <devinbhullar AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with isql
  • Date: Sat, 10 May 2008 22:46:23 +0800

i changed the version number in freetds.conf to 8.0 but i still shows


aas 5.0 iwhen i run tsql -C

Version 6.4.2

TDS version 5.0



2008/5/10 Devinder Singh <devinbhullar AT gmail.com>:

> Hi Igor
>
> ok can u tell me the steps to connenesc to MSSQL
>
> i just need Freetds.tar ball and i want unix ODBC
>
> then i extract the file and use
>
> .configure --with-tdsvr8.0
>
> when i did that and ran tsql -C
>
> i still get TDS version 5.0
>
>
> 2008/5/10 Igor <igorhmm AT gmail.com>:
>
>> Hi Devinder,
>>
>> This isn't a problem...
>>
>> 'tsql -C' display the default TDS version.. but you can change on
>> freetds.conf
>>
>> Regards,
>>
>> Igor
>>
>> On Sat, May 10, 2008 at 11:27 AM, Devinder Singh <devinbhullar AT gmail.com>
>> wrote:
>> > Hi
>> >
>> > I cant seem to connect to MSSQL using FreeTDS
>> >
>> > It it becuase i didnt specify the version number
>> >
>> > i did
>> >
>> > freetds-0.64#.configure
>> > make
>> > make install
>> >
>> > I didnt not specifc the version 8.0
>> >
>> > when i ran tsql -C
>> >
>> > i get TDS version 5.0
>> >
>> >
>> >
>> >
>> > 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
>> > _______________________________________________
>> > 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




Archive powered by MHonArc 2.6.24.

Top of Page