• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 603
  • Last Modified:

System DSN / Web Browser / Lotus Notes

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
Dim TESTDATA_numRows
Set TESTDATA_cmd = Server.CreateObject ("ADODB.Command")
TESTDATA_cmd.ActiveConnection = "dsn=NBTSQL;uid=testid;pwd=testid;"
TESTDATA_cmd.CommandText = "SELECT [901_Abbreviation] as State, [901_Name] as Name FROM dbo.[901-GeoState]" 
TESTDATA_cmd.Prepared = true
TESTDATA_numRows = 0
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
TESTDATA_numRows = TESTDATA_numRows + Repeat1__numRows
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<table border="1">
  <% For Each fld in TESTDATA.Fields %>
  <% Next %>
  <% While ((Repeat1__numRows <> 0) AND (NOT TESTDATA.EOF)) %>
    	<% For Each fld in TESTDATA.Fields %>
        	<td><%=(TESTDATA.Fields.Item( fld.Name ).Value)%></td>
		<% Next %>
  Wend %>
Set TESTDATA = Nothing

Open in new window

Michael Williams
Michael Williams
  • 2
3 Solutions
I would think so, if you want to access them similarly.

Otherwise you will need to access via Notes session or other Notes methods, not as a SQL type DB.

I hope this helps !
brwwigginsIT ManagerCommented:
Are you trying to get domino to serve up and run an ASP page?
Michael WilliamsApplication DeveloperAuthor Commented:
Yes I am. I believe I need to istall IIS or Apache on the domino server. I just assumed you didn't need to install that on the domino server.
brwwigginsIT ManagerCommented:
Domino won't serve up ASP pages. If you install IIS and Domino on the same machine they will both compete for port 80. They either need to be on different machines or different ports. IBM makes an ISAPI filter you can use with IIS to make it forward requests for NSF files to the domino server while still serving other IIS content.

These links might help


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Managing Security Policy in a Changing Environment

The enterprise network environment is evolving rapidly as companies extend their physical data centers to embrace cloud computing and software-defined networking. This new reality means that the challenge of managing the security policy is much more dynamic and complex.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now