I know this is a stupid question, but where do you set the
DSMG_DIR??

Rick Smith
Maritz, Inc.
Storage & Security Administration
smithrr AT maritz DOT com
(314) 827-1584

> ----------
> From:         Thomas A. La Porte[SMTP:tlaporte AT ANIM.DREAMWORKS DOT COM]
> Sent:         Saturday, January 31, 1998 1:44 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: ODBC Driver
>
> [Apologies if this has already been answered, I read the digest.]
>
> I'm not right at my NT box, but I'm pretty certain that on your
> NT machine, you need to set the system environment variable
> "DSMG_DIR" to "[adsmdir]\odbc\adsm", where [adsmdir] is the
> directory in which ADSM is installed. You will find that, in
> addition to the dsmameng.txt in the baclient directory of
> [adsmdir], there is a 'dsmgameng.txt' file in the
> [adsmdir]\odbc\adsm directory. That's the message file that the
> ODBC driver wants to find. This tripped us up for a while, too.
>
>  -- Tom
>
> "It's a dog eat dog world,                Thomas A. La Porte
>  and I'm wearing milkbone underwear."     DreamWorks SKG
>               - Norm Peterson
> <tlaporte AT anim.dreamworks DOT com>
>
>
> >Date:    Fri, 30 Jan 1998 09:02:59 -0600
> >From:    "Smith, Richard" <smithrr AT MARITZ DOT COM>
> >Subject: ODBC Driver
> >
> >Hello ADSMer's,
> >
> >        I am trying to use MS Access to link to the ADSM database.
> When
> >I select link tables, or import, I get the following errors:
> >
> >ODBC - Call failed
> >
> >        Followed by:
> >
> >ADSM: The message repository can not be found!  Please ensure you
> >defined environment variable DSMG_Dir pointing to the directory that
> >message resides.  (#1931506537) [Microsoft] [ODBC Driver Manager]
> >Drivers SQLAllocHandle on SQL_Handle_ENV failed (#0)
> >
> >        Any help on this would be appreciated!!
> >
>