Problems with isql

Igor <[email protected]> Thu, 8 May 2008 22:17:40 -0300

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

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

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

sql.log (application/octet-stream, 2.1 KB)

[ODBC][32317][__handles.c][447]
		Exit:[SQL_SUCCESS]
			Environment = 0x805d000
[ODBC][32317][SQLAllocHandle.c][358]
		Entry:
			Handle Type = 2
			Input Handle = 0x805d000
[ODBC][32317][SQLAllocHandle.c][476]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x805e000
[ODBC][32317][SQLConnect.c][3586]
		Entry:            
			Connection = 0x805e000            
			Server Name = [LekkusLOJA][length = 10 (SQL_NTS)]            
			User Name = [lekkus][length = 6 (SQL_NTS)]            
			Authentication = [************][length = 12 (SQL_NTS)]
		DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source

[ODBC][32317][SQLConnect.c][3954]
		Exit:[SQL_ERROR]
[ODBC][32317][SQLError.c][424]
		Entry:                
			Connection = 0x805e000                
			SQLState = 0xbfbfe9e0                
			Native = 0xbfbfe9d8                
			Message Text = 0xbfbfe9f0                
			Buffer Length = 500                
			Text Len Ptr = 0xbfbfe9de
[ODBC][32317][SQLError.c][461]
		Exit:[SQL_SUCCESS]                    
			SQLState = S1000                    
			Native = 0xbfbfe9d8 -> 0                    
			Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to data source]
[ODBC][32317][SQLError.c][424]
		Entry:                
			Connection = 0x805e000                
			SQLState = 0xbfbfe9e0                
			Native = 0xbfbfe9d8                
			Message Text = 0xbfbfe9f0                
			Buffer Length = 500                
			Text Len Ptr = 0xbfbfe9de
[ODBC][32317][SQLError.c][461]
		Exit:[SQL_NO_DATA]
[ODBC][32317][SQLError.c][504]
		Entry:                
			Environment = 0x805d000                
			SQLState = 0xbfbfe9e0                
			Native = 0xbfbfe9d8                
			Message Text = 0xbfbfe9f0                
			Buffer Length = 500                
			Text Len Ptr = 0xbfbfe9de
[ODBC][32317][SQLError.c][541]
		Exit:[SQL_NO_DATA]
[ODBC][32317][SQLFreeHandle.c][273]
		Entry:
			Handle Type = 2
			Input Handle = 0x805e000
[ODBC][32317][SQLFreeHandle.c][324]
		Exit:[SQL_SUCCESS]
[ODBC][32317][SQLFreeHandle.c][206]
		Entry:
			Handle Type = 1
			Input Handle = 0x805d000