How to do VBA -> LDPA -> OIM -> Oracle?

[jasmith4]

I have several Access/VBA applications that interface with Oracle databases. Up to now we've been using ODBC (via Access links), DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the password. The oracle clients and databases are fine, and everything works.

But now we're told we have to use LDAP for better security, which means users have to log in with their company intranet IDs to get to the Oracle databases via Oracle Identity Management (OIM), something that the DBAs will set up at some point. And we developers have to scrap all the ODBC/DAO/ADO code and use LDAP/OIM code. Therefore:

1. What object/type library do I need to reference, in place of DAO360.dll or MSADOnn.tlb, to use LDAP and OIM?
2. Is there any reference out there to that library?
3. Does anyone have any sample code?

Thanks!


Cross-posted:
http://www.mrexcel.com/forum/excel-questions/658885-how-do-visual-basic-applications-ldap-oim-oracle.html#post3265768</SPAN>
http://www.mrexcel.com/forum/general-excel-discussion-other-questions/658887-how-do-visual-basic-applications-ldap-oim-oracle.html</SPAN>

 

[SydneyGeek]

The DBAs will need to make sure that you have the appropriate read or write permissions in Oracle.
Otherwise you can still use ADO, just change the connection string.

Replace the part that has
User id=Someuser; Password=YourPassword;

With
OSAuthent=1;

That's from the user end...

Denis

 

[jasmith4]

Nope -- it's politics -- I have to use LDAP.