Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problems with isql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Igor <igorhmm AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with isql
  • Date: Fri, 9 May 2008 19:46:19 -0300

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!
mem.c:565:tds_free_all_results()
odbc.c:3339:SQLFreeConnect(0x8060400)

I really don't know what is happening...

Thanks again !

Igor

On Fri, May 9, 2008 at 4:06 PM, James K. Lowden <jklowden AT freetds.org> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page