Re: Problems with isql

"Devinder Singh" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]> 
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 <[email protected]>:

> 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 <[email protected]>
> 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 <[email protected]>:
> >
> >> 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 <[email protected]>
> wrote:
> >> > Igor,
> >> >
> >> > -----Original Message-----
> >> >>From: Igor <[email protected]>
> >> >>Sent: May 9, 2008 6:46 PM
> >> >>To: FreeTDS Development Group <[email protected]>
> >> >>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 <[email protected]
> >
> >> 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
> >> >>> [email protected]
> >> >>> http://lists.ibiblio.org/mailman/listinfo/freetds
> >> >>>
> >> >>_______________________________________________
> >> >>FreeTDS mailing list
> >> >>[email protected]
> >> >>http://lists.ibiblio.org/mailman/listinfo/freetds
> >> >
> >> > _______________________________________________
> >> > FreeTDS mailing list
> >> > [email protected]
> >> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >> >
> >> _______________________________________________
> >> FreeTDS mailing list
> >> [email protected]
> >> http://lists.ibiblio.org/mailman/listinfo/freetds
> >>
> >
> >
> >
> > --
> > Devinder
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Devinder
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.