Replying to: Doug Thorneycroft <dthorneycroft AT LACSD DOT ORG> (Fri, 3 Apr 1998
07:55:54 -0800)

>Mike:
>ADSM Server V3.1.0.1 - Client=win95 DB=MS - Access 97
>
>Here's what we're doing.
>1.Ran the ODBC setup, entered the TCP/IP address for the ADSM server
>(Same as ADSM clients use)
>
>2. Open Access- select get external data - link table - select ODBC
>databases.
>
>3. Select The ADSM 32 bit driver
>
>
>4. Get message ODBC- call failed
>
>Thanks for responding

Hi Doug, 

I think that what may be missing is step 1 below. This is the way I did it:

1- Define the environment variable DSMG_DIR pointing to
<adsm_root>/ODBC/ADSM.

2- Open a new database in MS Access

3- File -> Get External Data -> Link Tables

4- Files of type: Select ODBC Databases

5- Create a new Machine Data Source (User)

6- Enter Server Name and Server Address

7- I'm prompted for Admin Name and Password

8- I get a list of tables to pick from the ADSM server.

(You can do steps 5 and/or 6 from Control Panel -> 32bit ODBC)

One problem I have is that when I close MS Access *after* using ADSM ODBC I
get an Aplication Exception Error. 

--
Rui Malheiro,
Rui Malheiro,
6 Mil - Tecnologias de Informacao
URL: <http://www.6mil.pt/>