[freetds] ODBC-only connection to SQL Server from FreeBSD

Carlo Andreoli vespito at vespito.com
Thu Aug 4 11:22:56 EDT 2005


> > carlo at qs41% /usr/local/bin/iodbc-odbctest "DSN= SCAM; 
> > UID=user; P= psw"
> 
> Try to remove spaces.

This was the problem! Thank you so much!

> > [SCAM]
> > Driver          = /usr/home/carlo/freetds/lib/libtdsodbc.so
> > Description     = SQL SERVER
> > Server          = ip.ip.ip.ip
> > Address         = ip.ip.ip.ip
> > Host            = ip.ip.ip.ip
> 
> Server is sufficient

It is, thank you!

> > UID             = user
> > PWD             = psw
> 
> RTFM

Yep, sorry, not needed.

 
> > Database        = SYSMA4
> 
> > ReadOnly        = no
> 
> ??? iODBC ???

Sorry, I don't know how to obtain the IODBC settings. Anyway, things rule now, so no problem.

> Try removing additional settings and enabling FreeTDS logging (see
> manual at http://www.freetds.org/userguide/logging.htm)

Thank you!

Carlo.



More information about the FreeTDS mailing list