Skip to Content.
Sympa Menu

freetds - Re: [freetds] Driver file for OpenVMS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James Horn" <horn.jt.vms AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Driver file for OpenVMS
  • Date: Fri, 15 Jun 2007 16:08:15 -0500

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





Archive powered by MHonArc 2.6.24.

Top of Page