You'll be logging into the ACT framework as an ACT user not as the SQL 'sa' - with that Users rights and permissions.
//Example 2 //This example logs the famous Chris Huffman into the ACT9Demo database using no password. string xmlPADFile; string userName; string password; xmlPADFile = "C:\\Documents and Settings\\All Users\\Documents\\ACT\\ACT for Windows 9\\Databases\\ACT9Demo.PAD"; userName = "Chris Huffman"; password = ""; ActFwk.LogOn(xmlPADFile, userName, password);
If you don't know what your ACT users are launch the ACT program as an Administrator or Manager and go to Tools > Manage Users > And the screen that comes up should tell you what users exist in your Database.
Ok. Thanks. That helps. However, the application in question will be automated importing of outside leads into ACT. What is the recommended practice for such a scenario? Create a new user to log in and accomplish this task?
Ok So I'm borrowing someones logon. Same error. ACTFM.LogOn("John Aram", "", "SQL", "sjc-sql02", "OURDBNAME"); His password is blank. Should I be doing something different with OURDBNAME or HOST? The DB server is on a remote machine.
Message Edited by JohnPettit on 03-13-200801:39 PM