I’ve written an agent to test an ODBC connection on a Domino Server to call a SQL query on an SQL Server 2005 box and all works well when stepping through the code in debugger.
Is there anything I need to be aware of when calling this agent from a web browser? The queries are only to read the data so the username connecting to the SQL server via the ODBC connection has readonly access to the tables. I’m aware that I can print from the agent directly to the browser so I can form my results and display them.
Is there a preferred way to pass parameters to the agent to then be included in the lookup SQL query?
Any advice on common problems would be a big help, thanks!