Tina,

     the variable should point to something like
     c:\win32app\IBM\ADSM\odbc\ADSM

     In this directory you find the following:

     odbcadsm.txt
     dmgameng.txt
     odbcadsm.dll

     Matthias


======================================================================
     The opinions expressed above are solely those of the author
     and are not necessarily those of the Schering AG

======================================================================
     NAME:  Matthias Hensel              ADDRESS: Schering AG
     EMAIL: matthias.hensel AT schering DOT de           ZI-Rechnersysteme
     PHONE  +49-30-468-12081                      D-13342 Berlin
     FAX:   +49-30-468-92081                      Germany



____________________________ Antwort-Abtrennung
________________________________
Betreff: odbc access to server
Autor:  ,Hilton Tina [SMTP:HiltonT AT TCE DOT COM] bei BE2183
Datum:    14.10.98 18:49


I'm trying to set up the ODBC connection so I can look at my database
information via MS Query or MS Access.  All our clients are AIX and our
server(v3.1.12) is AIX (v4.2).

On my PC (Windows 95) I have installed the Admin client and ODBC driver.

When I try to select the data source from MS Query, I get this message:

        ADSM:  The message repository cannot be found!  Please ensure
you
have defined environment variable DSMG_DIR pointing to the directory
that
message repository resides.  Driver's SQLAllocHandle on SQL_HANDLE_ENV
failed.

I can't find anything about DSMG_DIR and where to set it on my PC.  Does

anybody out there know what to do?  The only references I can find for
it is
in regards to OS/2.

Any help will be appreciated.


Tina Hilton
Thomson Consumer Electronics
Systems Software
317-587-4292
hiltont AT tce DOT com