Load Ingest Data
Results 1 to 6 of 6

Thread: Attunity Connect error

  1. #1
    turtle is offline Junior Member
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0

    Attunity Connect error

    When using the Attunity odbc connection through my application to access the server from my client I receive the message

    Error Connecting to Database
    [Attunity][Attunity Connect Driver]A077 DS Name %s does not appear in the binding entry.

    When I try to open the ODBC connection to verify it I get the message

    Attunity Connect Error
    There is no binding nav on Attunity Connect Machine.

    I cannot open or delete the connection.

    I logged out and logged in as an administrator and reinstalled the Attunity driver. I set up the ODBC connection again with no problems. Then I logged off and back in again as a user without Administrator rights and the issue returned. The only way to resolve it seems to be for the machine user to have Administrator privleges. This had worked without these rights in the past.

    Why is this level of access necessary and is there any way around it?

    Thanks.

  2. #2
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    13
    Hi,

    There are two directories within the Attunity Server installation which requires read/write permissions:
    1. NAVROOT/def
    2. NAVROOT/tmp
    NAVROOT is the directory where you installed the Attunity Server.

    The def directory is the Attunity Server repository and it seems the user is unable to fully access it, and this is why it's not finding the nav binding.

    The tmp directory will contain the temp files and the log files of the product.

    Please, add the proper permissions and let us know if you still face any problems.

    Regards,
    Adeeb M.
    Attunity Support
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    turtle is offline Junior Member
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0
    Hi Adeeb,

    I checked the def directory and all users have full access to it so this doesn't seem to be the problem.

    I checked the log file around the time that the connection error started to appear and the folllowing error was in one of the files.

    [D00B] DRV_TdpGetProperty: Unsupported property id 1020

    However the IP address given was not that of the machine with the connection error so it may not be related.

    Since Administrator rights on the PC seems to fix the issue. Is there some directory stored locally that Attunity would access or alter when trying to connect?

    Thanks.



  4. #4
    Adeeb Mass'ad is offline Support Manager
    Join Date
    Aug 2006
    Location
    Jaffa of Nazareth
    Posts
    169
    Rep Power
    13
    Hi,

    The two directories requiring read/write permissions are both the NAVROOT/def and NAVROOT/tmp. Ofcourse you need access to the NAVROOT/bin for the executables and modules.

    At this point I suggest you open an issue with Support, and supply the log files by setting at least generalTrace/nosTrace in the binding which you are using (NAV?).

    Including both Server log file + irpcd log file.

    Thanks,
    Adeeb M.
    Attunity Support
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  5. #5
    turtle is offline Junior Member
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0
    These are the permissions on those directories.

    drwxrwxrwx 2 root bin 4096 Mar 27 2007 def
    drwxr-xr-x 2 root bin 4096 May 6 17:18 bin
    drwxrwxrwt 2 root bin 1052672 May 7 14:28 tmp

    ok, I may log it with Support.

    Thanks.

  6. #6
    turtle is offline Junior Member
    Join Date
    Jan 2008
    Posts
    4
    Rep Power
    0
    Giving the user Administrator rights on the local client just for one folder, C:\Program Files\Attunity\Connect resolves this issue. It means the user doesn't need to have full Administrator rights for everything on the machine.

    Thanks.

Posting Permissions

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