asked on

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

SOLUTION

SysExpert

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION