I’m currently running IIS on my machine, which allows me to view ASP and PHP files in the browser. These various pages have a ODBC System DSN connect to a SQL Server. I want to put these files in my Lotus Notes database and then access them. When I put these files in the Shared Resources - Files portion of the Notes Design. When I put in the URL (example: https://www.WEBSITE.com/NOTES.NSF/SQLQueryAll.asp), I receive the File Download prompt.
- Since I’m using a DSN to access SQL Server on the ASP page, do I need this DSN to be on the server where the NOTES.NSF database resides ?
ASP Code Below
Thanks in advance