[Asterisk-Users] Re: Asterisk-Users Digest, Vol 9, Issue 21

[Kamran Ahmad]

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