Re: ODBC

Hi:
You need to use the ODBC driver that comes with ADSM
The ODBC definition must be a  type SYSTEM DSN
As part of that definition you define the TCP/IP address and port. We have
our ADSM server on an AIX so I am not familiar with the AS/400.
 Once the ODBC def is in place, you create an empty database in ACCESS,
then select:
   File ....Get external data...Linked tables
   Set file type to ODBC Databases
   Select Machine datasource ( the ODBC name you created earlier)
   Enter an admin userid and password with administrator privilages in ADSM
   ....The tables names should pop up....
   Select the tables you want to link to and they will show up in the table
tab
   Do queries and reports against them in ACCESS to SELECT into to make them
local.

Larry Clark
NYS Thruway Authority


>>> "Tony Jules" <JULEST AT olympus DOT com> 02/11/00 11:12AM >>>
Hi Larry,

I thank you for your reply, but I still have a question related to the
answer. I am new to ADSM, just a couple of weeks. How do I get to the ADSM
tables or connect to it, where is it located? The Server is on the AS/400.

thanks again.

Tony Jules
Olympus America Inc.
ITS Department
516-844-5887
julest AT olympus DOT com

>>> Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US> 02/11 8:31 AM >>>
Hi:

I collect info from the ADSM tables using linked tables in ACCESS, and
insert the info into local tables using an ACCESS append query. e.g.:

INSERT INTO FSPACE ( NODE_NAME, FILESPACE_NAME, FILESPACE_TYPE, CAPACITY,
PCT_UTIL )
SELECT FILESPACES.NODE_NAME, FILESPACES.FILESPACE_NAME,
FILESPACES.FILESPACE_TYPE, FILESPACES.CAPACITY, FILESPACES.PCT_UTIL
FROM FILESPACES;

You can then use the ACCESS report writer to generate reports or import the
data into EXCEL.

Larry Clark
NYS Thruway Authority


>>> Tony Jules <JULEST AT OLYMPUS DOT COM> 02/10/00 04:33PM >>>
Hi everyone,

I need to be able to compile information from the log file everyday for
about 24 clients both Novell and NT 4.0. We are using ADSM 3.1 Server on
AS/400. How can I setup ODBC and be able to compile that information in a
spreadsheet or table format without having to type it in myself?

Thank you for your help.



Tony Jules
Olympus America Inc.
ITS Department
516-844-5887
julest AT olympus DOT com