ODBC Connection Strings for LDAP<->ODBC in Visual Basic for MS Access 
Author Message
 ODBC Connection Strings for LDAP<->ODBC in Visual Basic for MS Access

I am using a tool called PSEnlist to drag a table from LDAP via ODBC into
Microsoft Access 2000 and am trying to automate this task (to run
overnight). The problem is when I run the module, I get a dialog box
prompting for my LDAP login and password (I am anonymously logging in
anyway). How can I send the keystrokes for this? Or do I put the details in
the ODBC connection string. Here is my code:

call TransferDatabase(acImport, "ODBC Database",
"ODBC;DSN=LDAPUser;DATABASE=","employees","Employees",,True)

Any ideas?
I can't put the Sendkeys method after this line as the dialog box suspends
it.
I tried putting UID="";PWD="" in the connection string, but then the
connection failed.
TIA,
Joe



Tue, 03 Sep 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. MS Visual Basic -> MS Access via ODBC

2. VB5<->RDO2<->ODBC<->ORACLE Procedure Problem

3. AS400<-->ODBC<-->Access

4. VB30 <-<ODBC>-> Access 2.0

5. VB ODBC <--> RDB Connection Issues

6. ODBC connection to <name> failed

7. Visual Basic 5, ODBC and MS Access

8. US-FL-Jacksonville Opportunities in MS Access/Visual Basic ODBC

9. US-FL-Jacksonville Opportunities in MS Access/Visual Basic ODBC

10. US-FL-Jacksonville Opportunities in MS Access/Visual Basic ODBC

11. US-FL-Jacksonville Opportunities in MS Access/Visual Basic ODBC

12. US-FL-Jacksonville Opportunities in MS Access/Visual Basic ODBC

 

 
Powered by phpBB® Forum Software