FreeTDS Development Group

["David Vaughan" <dvaughan AT am-a.com>]

I think I'm ok now, I installed FreeTDS before UnixODBC which I discovered 
removes the libtdsodbc.so file. So I reinstalled "--with-unixodbc" and I'm 
able to connect via tsql and isql. On my way, THANKS!

>-----Original Message-----
>From: freetds-bounces AT lists.ibiblio.org
>[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of James Horn
>Sent: Friday, June 15, 2007 2:08 PM
>To: FreeTDS Development Group
>Subject: Re: [freetds] Driver file for OpenVMS
>
>
>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
>>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>