[freetds] Problems with isql

Devinder Singh devinbhullar at gmail.com
Sat May 10 10:51:06 EDT 2008


Hi

I can t seem to connect to MSSQL 2000 using Free TDS

once i extracted the tar file

i did


./configure
make
make install

do i need to specify any version

when i ran TSQL -c i get

 iconv library: no
>> >>                        TDS version: 5.0
>> >>                              iODBC: no
>> >>                           unixodbc: yes

whys does it show TDS version 5.0

#tsql -H 192.168.1.9 -p 1433 -U sa -P password

login incorect
canot connect to server





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

> 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 at 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 at 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 at 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 at 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 at 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




-- 
Devinder



More information about the FreeTDS mailing list