S
sck10
Hello,
I inherited the following piece of code.
Dim LDAP_CONN, LDAP_COM, RS, sql, strPrint, strFields
Set LDAP_CONN = CreateObject("ADODB.Connection")
LDAP_CONN.Provider = "ADsDSOObject"
LDAP_CONN.Open
Set LDAP_COM = CreateObject("ADODB.Command")
Set LDAP_COM.ActiveConnection = LDAP_CONN
sql = "SELECT employeeNumber, name FROM 'LDAP://ldap-uscentral.post..com'
WHERE employeenumber='" & HRID & "'"
Set RS = LDAP_CONN.Execute(sql)
My problem is how to declare LDAP_CONN and LDAP_COM since the database is
using a URL ('LDAP://ldap-uscentral.post.com'). Also, how would I use the
repeater tool with this instead of a recordset.
ASP.NET
Dim strSQL As String = "SELECT employeeNumber, name FROM
'LDAP://ldap-uscentral.post.com' WHERE employeenumber='" & HRID & "'"
Dim LDAP_CONN as NEW OleDbConnection
Dim LDAP_COM As New OleDbCommand(strSQL, LDAP_CONN)
Dim RS, strPrint as string="", strFields as string=""
LDAP_CONN.Provider = "ADsDSOObject"
LDAP_CONN.Open
LDAP_COM = CreateObject("ADODB.Command")
Set LDAP_COM.ActiveConnection = LDAP_CONN
I inherited the following piece of code.
Dim LDAP_CONN, LDAP_COM, RS, sql, strPrint, strFields
Set LDAP_CONN = CreateObject("ADODB.Connection")
LDAP_CONN.Provider = "ADsDSOObject"
LDAP_CONN.Open
Set LDAP_COM = CreateObject("ADODB.Command")
Set LDAP_COM.ActiveConnection = LDAP_CONN
sql = "SELECT employeeNumber, name FROM 'LDAP://ldap-uscentral.post..com'
WHERE employeenumber='" & HRID & "'"
Set RS = LDAP_CONN.Execute(sql)
My problem is how to declare LDAP_CONN and LDAP_COM since the database is
using a URL ('LDAP://ldap-uscentral.post.com'). Also, how would I use the
repeater tool with this instead of a recordset.
ASP.NET
Dim strSQL As String = "SELECT employeeNumber, name FROM
'LDAP://ldap-uscentral.post.com' WHERE employeenumber='" & HRID & "'"
Dim LDAP_CONN as NEW OleDbConnection
Dim LDAP_COM As New OleDbCommand(strSQL, LDAP_CONN)
Dim RS, strPrint as string="", strFields as string=""
LDAP_CONN.Provider = "ADsDSOObject"
LDAP_CONN.Open
LDAP_COM = CreateObject("ADODB.Command")
Set LDAP_COM.ActiveConnection = LDAP_CONN