[freetds] I am Not getting connection.. to SQL SERVER

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Aug 22 04:34:23 EDT 2008


> 
> Hi Guys !
> I installed the FreeTDS based the rules through the below link..
>  
> http://wiki.rubyonrails.org/rails/pages/HowtoConnectToMicrosof
> tSQLServerFromRailsOnLinux
> 
> I installed the FreeTDS
>  # tsql -S YOUR_DB_DEFINITION_NAME -U USERNAME -P PASSWORD 
> The Command Worked fine 
> > The Server located in remote system.. it's name is the 
> rohitm(System Name) in which the sqlserver presented
> > The database name which i have to connect is hsaedi_development
> user name is "sa" 
> 
>  My /etc/odbc.ini File is as below
> [SqlDB]
> Driver	= FreeTDS
> Description	= ODBC via FreeTDS
> Server	= rohitm
> Port	= 1433
> Database	= hsaedi_development
> User	= sa
> Password	= password
> Mars_Connection	= No
> Logging	= 0
> LogFile	= 
> 
> /etc/odbcinst.ini File is as below
> 
> [FreeTDS]
> Description	= TDS driver (Sybase/MS SQL)
> Driver	= /usr/local/lib/libtdsodbc.so
> Setup	= /usr/lib/odbc/libtdsS.so
> CPTimeout	= 
> CPReuse	= 
> FileUsage	= 1
> DontDLClose	= 1
> UsageCount	= 1
> 
> Now the command # isql SqlDB sa sa123 throwing the error
> 
> [ISQL]ERROR: Could not SQLConnect
> 
> 
> 
> Can AnyOne Help me regarding these Where i went wrong i can't 
> understand
> 

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

freddy77
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3129 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080822/cc7eab13/attachment.bin 


More information about the FreeTDS mailing list