Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

VBScript/C# - Connect ORACLE using LDAP string

user9970422Aug 14 2015 — edited Aug 14 2015

I was provided a connection string like;

LDAP://abcd.myCompany.com:3060/cn=DBName,cn=OracleContext,dc=hello


Const ADS_SECURE_AUTHENTICATION = &H1

Const ADS_SERVER_BIND = &H200

Set adoConnection = CreateObject("ADODB.Connection")

adoConnection.Provider = "ADsDSOObject"

adoConnection.Properties("User ID") = strUser

adoConnection.Properties("Password") = strPassword

adoConnection.Properties("Encrypt Password") = True

adoConnection.Properties("ADSI Flag") = ADS_SERVER_BIND Or ADS_SECURE_AUTHENTICATION

adoConnection.Open "Active Directory Provider"

Set adoCommand = CreateObject("ADODB.Command")

Set adoCommand.ActiveConnection = adoConnection

adoCommand.CommandText = "select * from TABLE1"

Set adoRecordset =adoCommand.Execute

I am getting error "Provider does not support this property"

Someone throw some light how to connect and fetch data from oracle database using VBScript or C# with available LDAP connection string.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2015
Added on Aug 14 2015
2 comments
1,959 views