ADSM-L

ODBC and MS Access

1999-08-10 10:46:03
Subject: ODBC and MS Access
From: "Janse J.I." <J.I.Janse AT RF.RABOBANK DOT NL>
Date: Tue, 10 Aug 1999 15:46:03 +0100
Hello ADSM specialists,


With MS Acces I made an ODBC connection so I'am able to query the
ADSM database. It works fine for most of the tables. Except when I try
importing the RECLAIM_ANALYSIS table:

ANR0101E        IMRCLM (1725) Error 11 opening table
"Reclamation.Analysis"

In my opinion, using a select command on a database may never
result in a severe error. Does anyone know more about this problem
and are there more tables that result in a severe ADSM Error?
When I try to get event results I can't find the EVENT table with MS
Access to query? So I query the actlog table with a criteria "ANE49*" ,
unfortunately also without any result. It seems that there are a lot of
messages in the actlog table that can't be queried with an SQL select
command.
Can anyone help me out here, to use MS Access to get process result
information out of the ADSM database (without ending in severe
errors)?

Thanks in advance,
Joost Janse, Storage Management
Rabofacet
<Prev in Thread] Current Thread [Next in Thread>
  • ODBC and MS Access, Janse J.I. <=