[unixODBC-support] Freetds with unixodbc

Stefan Radman Stefan.Radman at CTBTO.ORG
Wed Dec 21 12:21:42 GMT 2005


You have 2 choices for correcting your configuration:

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

freetds.conf:
  [plat]
  host = 1.2.3.4
  port = 1433
  tds version = 7.0

odbc.ini:
  [plat]
  Driver          = TDS
  Description     = ODBC connection via FreeTDS
  Trace           = No
  Servername      = plat
  Database        = plat
  User            = myuser
  Password        = mypasswd

Note:
* "Servername" refers to the freetds.conf entry "plat"

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

odbc.ini:
  [plat]
  Driver          = TDS
  Description     = ODBC connection via FreeTDS
  Trace           = No
  Server          = 1.2.3.4
  Port            = 1433
  TDS_Version     = 7.0
  Database        = plat
  User            = myuser
  Password        = mypasswd

Note:
* freetds is ignored in this configuration


Cheers
Stefan

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com 
> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Its Azfar
> Sent: Wednesday, 21 December, 2005 11:21
> To: Support for the unixODBC project
> Subject: Re: [unixODBC-support] Freetds with unixodbc
> 
> what i done yet is 
> 
> unixodbc:
> ./configure --enable-gui=no
> make
> make install
> 
> freetds:
> ./configure --with-unixodbc=/usr/local 
>  make
>  make install
> 
> Edit freetds.conf:
> tds version = 7.0
> [plat]
> 	host = 1.2.3.4
>         port = 1433
> 	tds version = 7.0
> 
> Edit odbc.ini:
> [plat]
> Driver          = TDS
> Description     = ODBC connection via FreeTDS
> Trace           = No
> Server      = 1.2.3.4
> Database        = plat
> User            = myuser
> Password        = mypasswd
> 
> Edit odbcinst.ini:
> [TDS]
> Description     = FreeTDS
> Driver          = /usr/local/lib/libtdsodbc.so
> Setup           = /usr/local/lib/libtdsodbc.so
> UsageCount      = 1
> 
> i can connect to my database by tsql but isql simply
> hang when i try to connect. Any help. I need to
> connect MS SQL 2000.
> 
> 
> --- Its Azfar <azfarhusain at yahoo.com> wrote:
> 
> > Can some one guide me how to install unixodbc with
> > freetds on freebsd. I tried but unable to get
> > success.
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> > protection around 
> > http://mail.yahoo.com 
> > _______________________________________________
> > unixODBC-support mailing list
> > unixODBC-support at easysoft.com
> >
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 
> 




More information about the unixODBC-support mailing list