• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • 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
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
Dim TESTDATA
Dim TESTDATA_cmd
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
 
Set TESTDATA = TESTDATA_cmd.Execute
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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
 
<body>
<table border="1">
  <tr>
  <% For Each fld in TESTDATA.Fields %>
     <td><%=(fld.Name)%></td>
  <% Next %>
  </tr>
  <% While ((Repeat1__numRows <> 0) AND (NOT TESTDATA.EOF)) %>
    <tr>
    	<% For Each fld in TESTDATA.Fields %>
        	<td><%=(TESTDATA.Fields.Item( fld.Name ).Value)%></td>
		<% Next %>
    </tr>
  <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  TESTDATA.MoveNext()
  Wend %>
</table>
</body>
</html>
<%
TESTDATA.Close()
Set TESTDATA = Nothing
%>

Open in new window

0
Michael Williams
Asked:
Michael Williams
  • 2
3 Solutions
 
SysExpertCommented:
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 !
0
 
brwwigginsCommented:
Are you trying to get domino to serve up and run an ASP page?
0
 
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.
0
 
brwwigginsCommented:
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

http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.help.domino.admin.doc/DOC/H_OVERVIEW_DOMINO_WEB_SERVER_WITH_MICROSOFT_IIS_5898_OVERVIEW.html

http://www-01.ibm.com/support/docview.wss?rs=899&uid=swg21260208
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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