I need a two-way link to eDirectory through ASP
Posted on 2006-07-20
I am writing a web interface (using ASP/AJAX) to both view and manage employee account information. We chose eDirectory as the database. The Web interface will also integrate a help-ticket system (login info), web Mail account information (email address/login info) and the Novell network account info.
Everything is done except for the eDirectory link.
I downloaded the ODBC driver for eDirectory on recommendation from someone at a BrainShare; they told me that basically you could use just about any valid SQL statement to access eDirectory. I thought it would be a breeze but I guess I am missing something.
What I need to be able to do:
...is read and write from and to eDirectory using ADO, DAO or ODBC (or some other method ASP can use that (preferably) involves SQL).
What is happening:
When I run any kind of SQL statement (i.e. "SELECT * WHERE name = 'blah'") using the ODBC interface the web server (that is running the ASP) goes to 100% CPU usage until the ASP script run length expires and the script times out. It locks on the SQL execution statement.
When I link anything other than the most basic eDirectory table (i.e. when I link the printers list or employee list) in Microsoft Access I get seemingly infinite results; i.e. the table just keeps repeating and repeating with slight differences of the same records yet they appear in access as new records, and you can page-down for nearly an hour until Access finally crashes.