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

LVL 1
Michael WilliamsApplication DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
brwwigginsIT ManagerCommented:
Are you trying to get domino to serve up and run an ASP page?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
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

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.