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 Korot <ikorot AT earthlink.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with isql
  • Date: Fri, 9 May 2008 10:06:35 -0700 (GMT-07:00)

Igor,
Do you run any kind of firewall? Either on client or server?
Can you telnet to the machine?

Thank you.

-----Original Message-----
>From: Igor <igorhmm AT gmail.com>
>Sent: May 9, 2008 9:51 AM
>To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
>Subject: Re: [freetds] Problems with isql
>
>Hi James, thanks for reply :)
>
>I guess now is easy to found error...
>
>I've installed 0.82 but I got the same error... looking with osql (a
>great tool, thanks) I can found the error but I don't know how to
>solve this...
>
>I guess the osql make a system call to /bin/host but on freebsd the
>returns is different from linux, take a look on error:
>
>[root@bsd ~]# 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
>FreeTDS servername is "192.168.1.21"
>192.168.1.21 has address Name: erp.braziline.com.br Address:
>192.168.1.21 Aliases: erp
>
> DSN: LekkusLOJA
> Server's hostname: 192.168.1.21
> Address: Name:
> erp.braziline.com.br: Address:
> 192.168.1.21: Aliases:
> erp:
> Driver: /usr/local/lib/libtdsodbc.so
>
>Attempting connection as lekkus...
>[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
>[ISQL]ERROR: Could not SQLConnect
>
>Can you have any sugestion ?
>
>Thanks
>
>Igor
>
>On Fri, May 9, 2008 at 10:56 AM, James K. Lowden <jklowden AT freetds.org>
>wrote:
>> Igor wrote:
>>>
>>> I've installed:
>>> - unixODBC-2.2.12
>>> - freetds-0.65.dev.20061107
>>> (I've installed this versions because I get this working fine)
>>>
>>> The error:
>>>
>>> [root@bsd /usr/local/etc]# isql -v LekkusLOJA $DBUSER $DBPASS
>>> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
>>> [ISQL]ERROR: Could not SQLConnect
>>
>> Suggestions:
>>
>> 1. Use 0.82. It's what's for breakfast.
>> 2. Try src/apps/osql to troubleshoot your ODBC setup.
>> 3. TDSDUMP and TDSDUMPCONFIG will show how isql is trying to connect.
>>
>> HTH.
>>
>> --jkl
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>_______________________________________________
>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