Re: Problems with isql
"Devinder Singh" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]>: > Try this first: > > http://www.unixodbc.org/doc/FreeTDS.html > > Regards, > > Igor > > On Sat, May 10, 2008 at 11:44 AM, Devinder Singh <[email protected]> > 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 <[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 > > _______________________________________________ > > 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