Re: Problems with isql

Hi Igor :)

This server is my firewall... but this isn't the problem..

I've installed bind to get /bin/host to work fine.. and now FreeTDS is
trying to connect to correct server:

[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 = bzbraziline
	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 "bzbraziline"
bzbraziline has address 192.168.1.21

                           DSN:	LekkusLOJA
             Server's hostname:	bzbraziline
                       Address:	192.168.1.21
                        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
[root@bsd ~]#
[root@bsd ~]# telnet 192.168.1.21 1401
Trying 192.168.1.21...
Connected to 192.168.1.21.
Escape character is '^]'.

The connection are allowed... DNS is working fine.. but still having
problems to connect :-(

Thanks

Igor

On Fri, May 9, 2008 at 2:06 PM, Igor Korot <[email protected]> wrote:
> 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
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>