asterisk users - Apr 2005 - Re: Asterisk-Users Digest, Vol 9, Issue 21

hello

can any one tell me what is the problem in my odbc
connection.
here is my sql.log connection with mysql is working
and with freetds is giving me error jawad is one
windows server having MS Sql server

#isql kdsn
src/tds/login.c: tds_connect: jawad:1433: Connection
refused
[ISQL]ERROR: Could not SQLConnect


[ODBC][3085][__handles.c][444]
		Exit:[SQL_SUCCESS]
			Environment = 0x823cb58
[ODBC][3085][SQLAllocHandle.c][345]
		Entry:
			Handle Type = 2
			Input Handle = 0x823cb58
[ODBC][3085][SQLAllocHandle.c][463]
		Exit:[SQL_SUCCESS]
			Output Handle = 0x823d130
[ODBC][3085][SQLConnect.c][3526]
		Entry:            
			Connection = 0x823d130            
			Server Name = [kdsn][length = 7 (SQL_NTS)]         
  
			User Name = [kami][length = 11 (SQL_NTS)]          
 
			Authentication = [***********][length = 11
(SQL_NTS)]
		UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
'UCS-2LE'

		DIAG [08S01] [FreeTDS][SQL Server]Server is
unavailable or does not exist.

		DIAG [S1000] [FreeTDS][SQL Server]Unable to connect
to data source

[ODBC][3085][SQLConnect.c][3894]
		Exit:[SQL_ERROR]
[ODBC][3085][SQLFreeHandle.c][268]
		Entry:
			Handle Type = 2
			Input Handle = 0x823d130
[ODBC][3085][SQLFreeHandle.c][317]
		Exit:[SQL_SUCCESS]
[ODBC][3085][SQLFreeHandle.c][203]
		Entry:
			Handle Type = 1
			Input Handle = 0x823cb58

/usr/local/etc/odbc.ini
[mydsn]
Description             = test
Driver          = test
Server          = localhost
Database                = asterisk
Port            = 3306
Socket          Option          Stmt
                                          
[kdsn]
Description             = tds dsn
Driver          = tdsdriver
Servername              Server          = jawad
Address         = jawad
Port            = 1433
Database                = kdb
TDS_Version             = 4.2
Language                = us_english
TextSize                Domain          PacketSize
                                          
/usr/local/etc/odbcinst.ini
[ODBC]
Trace           = Yes
TraceFile               = /tmp/sql.log
ForceTrace              = Yes
Pooling         = No
                                                      
                                          
[test]
Description             = test
Driver          = /usr/lib/libmyodbc.so
Driver64                Setup           = /usr/local/lib/libodbcmyS.so.1
Setup64         UsageCount              = 1
CPTimeout               CPReuse
                                          
[tdsdriver]
Description             = driver for tds
Driver          = /usr/local/lib/libtdsodbc.so
Driver64                = /usr/local/lib
Setup           = /usr/local/lib/libtdsodbc.so.0
Setup64         = /usr/local/lib
UsageCount              = 1
CPTimeout               CPReuse
                                          


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Personals - Better first dates. More second dates. 
http://personals.yahoo.com