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