Re: Problems with isql

I've forget an important information... tsql is working fine:

[root@bsd /usr/local/etc]# tsql -H 192.168.1.21 -p 1401 -U lekkus -P
lekkuslekkus
locale is "C"
locale charset is "US-ASCII"
1>

But if I remove freetds.conf tsql doesn't work...

Thanks

Igor

On Thu, May 8, 2008 at 10:17 PM, Igor <[email protected]> wrote:
> Hello all,
>
> I'm trying to get unixODBC + freeTDS on my FreeBSD 6.2 (pfSense -
> developer edition).
>
> I already get this working on another linux box.. runing with SuSE.
>
> 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
> [root@bsd /usr/local/etc]#
>
> And my files:
>
> [root@bsd /usr/local/etc]# ls -l odbc.ini odbcinst.ini freetds.conf
> -rw-r--r--  1 root  wheel  188 May  8 21:48 freetds.conf
> -rw-r--r--  1 root  wheel  138 May  8 21:46 odbc.ini
> -rw-r--r--  1 root  wheel  188 May  8 21:47 odbcinst.ini
>
> [root@bsd /usr/local/etc]# cat odbc.ini
> [LekkusLOJA]
> Driver = FreeTDS
> Description = Lekkus LOJA
> Trace = No
> Server = 192.168.1.21
> Port = 1401
> TDS_version = 8.0
> Database = Lekkus
>
> [root@bsd /usr/local/etc]# cat odbcinst.ini
> [FreeTDS]
> Description = FreeTDS ODBC Driver for MS-SQL
> Driver = /usr/local/lib/libtdsodbc.so
> UsageCount = 1
> [ODBC]
> Trace = Yes
> TraceFile = /tmp/sql.log
> ForceTrace = No
> Pooling = Yes
>
> [root@bsd /usr/local/etc]# cat freetds.conf
> [global]
> tds version = 4.2
> debug flags = 0x80
> text size = 64512
> [192.168.1.21]
> host = 192.168.1.21
> port = 1401
> tds version = 8.0
> dump file = /tmp/freetds.log
> debug flags = 0x80
>
> (attached is my sql.log)
>
> I guess the 'tsql' isn't founding the correctly config from
> freetds.conf... because I've tried to remove freetds.conf and I got
> the same error.
>
> Thanks for any help or tips..
>
> Regards,
>
> Igor
>