Re: Problems with isql
"Devinder Singh" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi Chad Thank . I m im am using Open SUSE do i need to add the line below in a file export TDSVER=8.0 Devinder 2008/5/11 Chad Sikorra <[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 > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > -- Devinder