Re: Problems with isql

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 <[email protected]>
>Sent: May 9, 2008 9:51 AM
>To: FreeTDS Development Group <[email protected]>
>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 <[email protected]> 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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>_______________________________________________
>FreeTDS mailing list
>[email protected]
>http://lists.ibiblio.org/mailman/listinfo/freetds