what exactly this error meassage says?

pongal · Post by **pongal** » Tue Mar 22, 2005 11:00 pm

Hi
i'm trying to import a ODBC table definition where the table is from DB2 Database.
but unfortunately i got this error meassage
"DSR.MetaGeta[GET.TABLES][SQLCONNECT[LMS,'Aoppsol']]:BCI
:Error
SQL STATE=S1000,CODE=7680[DataStage][SQL
Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Userid was revoked or invalid"
Is the above error message related to userid doesn't have access rights or we need to setup any more configuration to connect DB2 database table?
i am sure that my userid and pwd are correct and i donno whether i have access to connect LMS database or not.

Thanks
pongal

ray.wurlod · Post by **ray.wurlod** » Tue Mar 22, 2005 11:37 pm

The error message reports that the user ID does not have access to the DB2 database called LMS, though it once did. The message has been returned by the ODBC driver.

Check with your DBA.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 23, 2005 3:07 am

Try to connect to the db via DB2 client. It will confirm the status.