Re: Problems with isql

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