Re: 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
>