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 23:12:30 +0800

Hi Igor

Initially i didnt do this

# ./configure --with-tdsver=8.0 --with-unixodbc=/usr/local
# make
# make install

do i need the above for MSSQL 2000






2008/5/10 Igor <igorhmm AT gmail.com>:

> Try this first:
>
> http://www.unixodbc.org/doc/FreeTDS.html
>
> Regards,
>
> Igor
>
> On Sat, May 10, 2008 at 11:44 AM, Devinder Singh <devinbhullar AT gmail.com>
> wrote:
> > 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
> > _______________________________________________
> > 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




Archive powered by MHonArc 2.6.24.

Top of Page