update sql database with data from ldap database

[gadjodilo77]

Hi,

I have to update a SQL database table with some LDAP data from a novell database.

Here is how I planned to do it:

<cfquery name="devZen" datasource="">
SELECT dev_id, dev_serie, dev_typenr FROM dev WHERE dev_typenr = '1'
</cfquery>


<cfloop query= "devZen">

<!--- Connectie ! --->
<cfldap action="QUERY"
name="qtest"
attributes="cn, ou, wMNAMEUser, wMNAMECPU, wMNAMEOS, wMNetworkAddress,
zENINVOSType, zENINVComputerModel, zENINVComputerType,
zENINVProcessorType, zENINVDiskInfo, wMUserHistory, zENINVMemorySize, zENINVMACAddress, zENINVSerialNumber, ZENINVlastscandate, wMLastRegisteredTime, zeninvsubnetaddress, wMNAMEDNS, lastLoginTime"
start="ou=,o=,c="
scope="SUBTREE"
filter="(&(objectClass=Workstation)(zENINVSerialNumber=#devZen.dev_serie#))"
server="server"
>

"HERE THE UPDATE QUERY"

</cfloop>

However I keep getting this error:

The request has exceeded the allowable time limit Tag: cfldap


The error occurred in C:\xampp\htdocs\bar\zen\act\updatezen.cfm: line 30

28 : scope="SUBTREE"
29 : filter="(&(objectClass=Workstation)(zENINVSerialNumber=#devZen.dev_serie#))"
30 : server="server"
31 : >

Does anybody have another suggestion?

Thank you in advance,

Regards,
Kabbi

 

[gadjodilo77]

Hmmm

Is it even possible?

Regards,
Kabbi