Problem: No OLE DB connection object is created in ArcCatalog
An OLE DB connection object fails to be created in ArcCatalog.
A connection object is not created and a warning may not be returned, if the 'Allow saving password' option on the Data Link Properties menu is not selected when making a connection to a data source that requires a password, depending on which provider you use.
Solution or Workaround
The 'Allow saving password' option must be selected, if the connection requires a password, for the connection to open successfully.