Re: SQL Server connectivity failure.

Try TDSDUMP and TDSDUMPCONFIG:

http://www.freetds.org/userguide/logging.htm

--------------------------------------
Randy Syring
Intelicom
Direct: 502-276-0459
Office: 502-212-9913

For the wages of sin is death, but the
free gift of God is eternal life in
Christ Jesus our Lord (Rom 6:23)


On 06/07/2011 12:10 AM, Gopi Chand Telukoti wrote:
> SQL Server connectivity failing with below info. Testing using isql
> EngineRoom username  password getting this error message
>
> "[ISQL]ERROR: Could not SQLConnect"
> Where's the error?
>
> cat /etc/unixODBC/odbc.ini
> [ODBC Data Sources]
> MarketResearch = SQL Server
> EngineRoom = SQL Server
> [MarketResearch]
> Driver = TDS
> Description = Market Research
> Trace = Yes
> TraceFile = /tmp/mstest.log
> Servername = mi
>
> [EngineRoom]
> Driver = TDS
> Description = Engine Room
> Trace = Yes
> TraceFile = /tmp/mstest.log
> Database = Engine_Room
> Servername = WSDB0515V
> Port = 1433
>
> [Default]
> Driver = /wa01/aamie/app/src/freetds/lib/libtdsodbc.so
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>