I am setting up a Value List with a connection to External Database. The database is our MAS90 accounting system. On the Data Link Properties, I have successfully entered 1. the Data Source Name, and 2. the user id and password. When I click the Test Connection button I get Successful Message. On the 3rd step to Enter the initial catalog to use, when I click the dropdown button, I get a message: [Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.] with subsequent message: [Login Failed. Catalog Information cannot be retreived.]
Does anyone know the solution? Thanks
