Connection String for Pass Through Query to Active Directory

Posted on 2007-10-12
Last Modified: 2011-09-20
What is the ODBC connection string for a pass-through-query to connect to Active Directory?

I've found this template: "Provider=ADSDSOObject;User ID=MyUserID;Password=MyPassword;"

But it doesn't seem to work.
Question by:shelbyinfotech
    LVL 23

    Accepted Solution

    Do you have that provider installed on your system? What specific symptom is telling you it doesn't work?

    This link tells me that as long as you have ADO 2.0 installed, you should have that provider.
    LVL 16

    Expert Comment

    you want your connection string to look something like...

    Author Comment

    Turns out I did not have "Microsoft DAO 3.6 Object Library" reference checked.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now