System DSN / Web Browser / Lotus Notes

Posted on 2008-11-12
Last Modified: 2013-12-18
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:, 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" "">

<html xmlns="">


<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

Question by:fantasycommish
    LVL 63

    Assisted Solution

    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 !
    LVL 20

    Accepted Solution

    Are you trying to get domino to serve up and run an ASP page?

    Author Comment

    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.
    LVL 20

    Assisted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack or Above. The following steps a…
    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now