Re: Problems with isql
"Chad Sikorra" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Maybe try adding the following to the end of your ~/.bashrc file (Assuming you're using bash as default) export TDSVER=8.0 Then logout and back in. On Sat, May 10, 2008 at 11:25 PM, Devinder Singh <[email protected]> wrote: > Hi , > > How can i change the TDS Version from 5.0 to 8.0 > > When i run tsql -c i get something like this. Even thoug i have uypdated > freetds.conf file > > to Version 8.0 i tsql -C still says Version 5.0. I have uninstalled freetds > and ran ./configure --tdsver8.0 but still i geth TDS version 5.0 Pls could > someone help . > > > tsql -C > Password: > locale is "C" > locale charset is "646" > Compile-time settings (established with the "configure" script): > Version: freetds v0.62.dev.20030804 > MS db-lib source compatibility: no > Sybase binary compatibility: unknown > Thread safety: no > iconv library: no > TDS version: 5.0 > iODBC: no > unixodbc: yes > > 2008/5/11 Devinder Singh <[email protected]>: > >> Hi Igor >> >> I think im haveing the same problem TDS version 5. >> >> >> Ok i read this from the php mssql site. Do i need to enable msdblib and >> dbmfix the last time tried it could not find them. >> >> INSTALLING FREETDS >> >> 1-. Download freetds -> www.freetds.org >> 2-. tar -zxvf freetds-stable-tgz >> 3-. cd freetds-0.62.3 >> 4-. ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 >> --enable-msdblib --enable-dbmfix --with-gnu-ld >> >> Add the next text in freetds.conf ( /usr/local/freetds/etc ) >> [TDS] >> host = <ip of the Server with Sql> >> port = 1433 >> tds version = 8.0 >> I could not connect wven i added VErsion 8 >> >> When i Ran tsql -C >> >> i still gert TDS version 5. >> >> Pls help . >> >> I sther a full detailed instrctions to set up Frree TDS and MSSQL 2000. >> >> Thanks >> >> Devinder >> >> >> >> 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 > > > > > -- > Devinder > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > -- Chad Sikorra