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

    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
    'AIMUAT')


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


    - create nickname REMOTEDB2.aimconnection for
    REMOTEDB2.AIM.AIMCONNECTION


    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?


    Thanks!
    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
    Posts
    448
    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.


    regards

    Mujeeb

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    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.

    regards

    Mujeeb

Posting Permissions

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