Re: Problems with isql

"James K. Lowden" <[email protected]> Fri, 9 May 2008 09:56:16 -0400

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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