Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Minneapolis, MN

    Unanswered: Federated System

    I'm in trhe midst of creating a federated connection to a database.
    Everything looks good until I get to the "nickname" part. Below is the
    series of commands I executed against the remote database. Each came
    back successful.

    - create wrapper drda

    - create server REMOTEDB2 type DB2/6000 version 8.1 wrapper drda
    authorization "amrobi2" password "amrobi2" options (node 'DB2', dbname

    - create user mapping for amrobi2 server REMOTEDB2
    OPTIONS(remote_authid 'amrobi2', remote_password 'amrobi2')

    - create nickname REMOTEDB2.aimconnection for

    It's this last one that doesn't cooperate. I get the following error:

    SQL1822N Unexpected error code "-30082" received from data source
    "REMOTEDB2". Associated text and tokens are "func="DriverConnect" msg="
    SQL30082N Attempt to esta". SQLSTATE=560BD

    This looks like a user/password issue but from what I can see,
    everything seems okay.
    Can anyone shed any light on what the deal might be?

    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  2. #2
    Join Date
    Mar 2004
    Did you check that you can connect to that remote database using
    the remote_id and password from native command prompt like sqlplus or isql.
    I have this same problem with sybase , but when I alter the usermapping
    it works.



  3. #3
    Join Date
    Mar 2004
    Adding to that, all the previous stage should not give any errors.

    It is when you infact access the datasource, then all comes into play.

    I prefer that you should check with passthru session first.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts