Re: Problems with isql
Igor <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[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 >