Get Data Moving 1
Results 1 to 2 of 2

Thread: OLE DB (ADO) connection

  1. #1
    baldrick69 is offline Junior Member
    Join Date
    Sep 2010
    Posts
    6
    Rep Power
    0

    OLE DB (ADO) connection

    How do you configure Attunity so that a username/password is prompted for when a user makes an OLE DB (ADO) connection?

    I have two setups which look the same, one doesn't ask for a username password but connects anyway. The other also doesn't ask for a username/password but doesn't connect unless I add the extended property "DSNPassword=username/password".
    Last edited by baldrick69; 07-01-2011 at 05:51 AM.

  2. #2
    baldrick69 is offline Junior Member
    Join Date
    Sep 2010
    Posts
    6
    Rep Power
    0

    Update

    I've now found the anonymous connection checkbox on the Attunity Daemon and that allows us an anonymous connection.

    However, I'd still like to know how you make an OLE DB (ADO) connection by entering a username and password. If I turn the anonymous connection off and enter a username/password the connection fails unless I add an extended property containing the username/password.

Posting Permissions

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