FreeTDS Development Group

["James Horn" <horn.jt.vms AT gmail.com>]

What do you have (or do you have anything) in your freetds.conf?

On 6/14/07, Craig A. Berry <craigberry AT mac.com> wrote:
> At 7:00 AM -0500 6/14/07, James Horn wrote:
> >While trying to setup unixODBC to use FreeTDS for access to an Microsoft
> SQL
> >database on OpenVMS, I could not find the driver file. Any ideas on where
> to
> >look?
>
> Here's what I did (and apologies for not replying to your earlier
> off-list message).  Put all of your shareable images for the driver
> manager and the drivers along with the .ini files together in a
> directory somewhere.  The basic procedure is to define logical names
> and then refer to those logical names in your odbcinst.ini file.  For
> reasons I no longer remember, the drivers have to be referred to via
> logical name rather than actual file name for unixODBC to locate
> them.  I haven't fiddled with this stuff in at least a couple of
> years, but unless something really drastic has changed it should
> still work.
>
>
> $ define ODBC_LIBDIR DISK:[DIR.ODBC_STUFF]      ! put your own directory
> name here
> $ define LIBTDSODBC ODBC_LIBDIR:LIBTDSODBC.EXE
>
> Here's what my odbcinst.ini file looks like:
>
> ---- end of odbcinst.ini -----
>
> [FreeTDS]
> Description = Tabular Datastream Driver
> Driver = LIBTDSODBC
> Setup =
> FileUsage = 1
>
> ---- end of odbcinst.ini -----
>
> In the odbc.ini file, here's what the my FreeTDS section looks like:
>
>
> [tdstest]
> Driver = FreeTDS
> Description = local test machine
> Trace = No
> Servername = sqlhost
> Database = tempdb
> UID = tdsuser
>
> More details on the odbc.ini file are here:
>
> http://www.freetds.org/userguide/odbcconnattr.htm
>
> --
> ________________________________________
> Craig A. Berry
> mailto:craigberry AT mac.com
>
> "... getting out of a sonnet is much more
> difficult than getting in."
>                  Brad Leithauser
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds