Lees hier de laatste IGA-ontwikkelingen

Databases: oracle dump database table layout

In SQL Server there is a nice feature which lets you generate an SQL script from any database using the SQL Enterprise Manager. Oracle can do the same using sqlplusw:

Lees meer

Databases: date and time functions

Unfortunately databases don't all use the same SQL language. In most cases, the notation of SQL queries is roughly the same, however in some cases there are differences, for instance when working with dates and times:

Lees meer

AD: which attributes are stored in the global catalog?

The Global Catalog (GC) doesn't store all attributes. Refer to http://support.microsoft.com/kb/256938 for all default GC attributes in Windows 2000 Active Directory. You can easily check if an attribute is stored in the GC using ADExplorer or ADSIEdit. Look in the schema naming context and check if partialAttributeSet=TRUE.

Lees meer

ADSI error 8007001f: a device attached to the system is not functioning

When creating user accounts using scripts or tools, you can run into the error 8007001F: A device attached to the system is not functioning. This is because you are trying to create a user account with a sAMAccountName > 20 characters. The field in AD can store 256 characters, but AD denies more than 20 characters due to NETBIOS compatibility.

Lees meer

LDAP: objectcategory versus objectclass

When performing LDAP searches using scripts or LDAP capable tools, you are usually looking for user, group or computer objects. Default queries include the objectClass to distinguish between these types.

Lees meer