FreeTDS Development Group

["Craig A. Berry" <craigberry AT mac.com>]

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