Importing data from an LDAP Database

• ch1976

  Valued Member

  Points: 57

  More actions

  October 31, 2003 at 10:35 am

  #81336

  I have an LDAB database I would like to dump into my SQL database on a regular basis. I would like to create a DTS package, but could not figure out how to connect to the LDAP Database (sp_addlinkedserver maybe?). Thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  October 31, 2003 at 12:11 pm

  #480479

  http://support.microsoft.com/default.aspx?scid=kb;en-us;299410&Product=sql2k

  http://support.microsoft.com/default.aspx?scid=kb;en-us;319716&Product=sql2k

• ch1976

  Valued Member

  Points: 57

  More actions

  October 31, 2003 at 1:26 pm

  #480493

  I am trying this:

  sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'

  exec sp_addlinkedsrvlogin 'ADSI', false, '[local SQL LOGIN]',

  '[LDAP DB USER]', '[LDAP USER PASSWORD]'

  SELECT * FROM OpenQuery( ADSI, 'SELECT * FROM

  ''ldap://127.0.0.1,o=[LDAP OBJECT GROUP]''')

  And get this:

  An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'.

  OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare returned 0x80040e14].

  I see a lot of people with this error, but not many solutions. I am also trying to connect to an LDAP on a freeBSD box, not a windows server.