Resolvent for Error When Searching Active Directory Using OleDB

Topic: DB_E_NOTABLE(0x80040E37)
Description: Mario Rodriguez 's trouble: http://www.thescripts.com/forum/thread110472.html  (searched by google)
Explain: Cannot find the table "LDAP://DC=domain name, DC=COM".
Resolvent: Append the AD server's name to the LDAP Path. such as "LDAP://ADSrv/DC=MYDOMAIN, DC=COM" or "LDAP://ADSrv.MYDOMAIN.COM".

Code:

 1OleDbConnection activeConn = new OleDbConnection("Provider=ADSDSOObject");
 2string cmdString = "SELECT * FROM 'LDAP://DC=domain name, DC=COM' WHERE objectClass='OU'";
 3OleDbDataAdapter custDA = new OleDbDataAdapter();
 4DataSet dataset = new DataSet();
 5custDA.SelectCommand = new OleDbCommand(cmdString, activeConn);
 6try
 7{
 8 custDA.Fill(dataset, "OU");
 9}
10catch(Exception e)
11{
12 Console.WriteLine("Exception while filling the dataset: "+e);
13}

Code after Modify:

 1OleDbConnection activeConn = new OleDbConnection("Provider=ADSDSOObject");
 2string cmdString = "SELECT * FROM 'LDAP://ADSrv/DC=domain name, DC=COM' WHERE objectClass='OU'";
 3OleDbDataAdapter custDA = new OleDbDataAdapter();
 4DataSet dataset = new DataSet();
 5custDA.SelectCommand = new OleDbCommand(cmdString, activeConn);
 6try
 7{
 8 custDA.Fill(dataset, "OU");
 9}
10catch(Exception e)
11{
12 Console.WriteLine("Exception while filling the dataset: "+e);
13}