FreeTDS Development Group

[Merle Reinhart <merlereinhart AT mac.com>]

Michael,

Where the freetds.conf file goes and what fisql is are answered in the  
FreeTDS UserGuide, so I suggest you read through the relevant sections  
again.

However, in my case, I mentioned that I had freetds installed in /usr/ 
local/freetds.  Thus, my freetds.conf file is in /usr/local/freetds/ 
etc/.  I have no clue where macports places it.

fisql is the freetds included replacement for the Sybase and MS SQL  
Server isql query app.
See the fisql man page for more information.

As far as the key-value setup in the odbc.ini file:

[BOB]
Driver      = /usr/local/freetds/lib/libtdsodbc.so
Description = BOB Sybase Server
Servername  = BOB

The contents between the [] is the name you will access the DSN as
'Driver' is the location of the driver
'Description' is free text as to how you want the description to appear
'Servername' is the lookup in the freetds.conf file (it matches what  
is in the [])

As far as using the Mac OS X ODBC Administrator to populate/create the  
driver and DSN entries, I have yet to be successful (the tool has  
never allowed me to enter the key/value pairs so I have no idea what  
I'm doing wrong or if it is a bug so I've avoided ODBC  
Administrator.app).  Thus, make the files by hand and put them where  
they belong (/Library/ODBC for System-wide configurations).  I don't  
know if that is your stumbling block or not.

Merle




On Apr 12, 2009, at 1:20 PM, freetds-request AT lists.ibiblio.org wrote:

> Message: 2
> Date: Sat, 11 Apr 2009 14:55:48 -0400
> From: "lists AT mgreg.com" <lists AT mgreg.com>
> Subject: Re: [freetds] How does one actually *use* FreeTDS?
> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> Message-ID: <4DE60542-7075-4CAA-B800-D81C8B88FB14 AT mgreg.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
>
>
> Where do you place your "freetds.conf" file, and what exactly is
> fisql?  I'm also a bit confused about the key-value setup in the DSN
> configuration.  Would you mind pointing me in the right directly for
> what values are relevant?
>
> Thanks,
> Michael