DMSII database connection for an ASP.NET site

**MiltonCogswell** · Jan 23 '12, 03:33 PM

I am currently attempting to convert my Classic ASP site to a ASP.Net site. The current .asp site connects to a DMSii Unisys database, so I am having trouble converting to asp.net so I can connect to the database and retrieve all the info.

This is my current connection using Classic ASP.

Code:

<%
'Constant declarations
Const CstrConn = "Location=8.8.1.122;Port=1601;Data Source=DBWEB;UID=SHADY22;Password=PASSWORD;Provider=Unisys.DMSii;OLE DB Services=-2"
'The constant Cadminpassword is used by MRMC personnel to log in to user accounts
Const Cadminpassword = "#admin"
Const CfundNum = "M80 "
Const CeerFundNum = "M80 "
Const CstrFundNum = "M80_"
%>

This is my .ASPX File:

Code:

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            font-size: x-large;
            font-weight: bold;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div class="style1" style="text-align: center">
        ASP.NET Test Site<form action="login_resp.asp" method="post" id="Form2" name="Form2">
              <table border="0" width="100%" id="table2">
                <tr>
                  <td width="50%" align="right"><strong>User Id&nbsp;&nbsp;</strong></td>
                  <td width="50%"><input type="text" id="fuserid" name="fuserid" size="12" maxlength="12" /></td>
                </tr>
                <tr>
                  <td width="50%" align="right"><strong>Password&nbsp;&nbsp;</strong></td>
                  <td width="50%"><input type="password" name="fpswd" size="12" maxlength="12" /></td>
                </tr>
                <tr>
                  <td width="50%"></td>
                  <td width="50%"></td>
                </tr>
                <tr>
                  <td width="50%" align="right"><input type="submit" value="Submit" name="B1" onclick="passedEdit()" /></td>
                  <td width="50%"><input type="button" value="Reset" name="B2" onclick="clearText(document.Form2.fuserid,document.Form2.fpswd)" /></td>
                </tr>
              </table>
		      <br />
              <p>Click on the underlined text to<a href="createlogin.htm"> Create a Member Login Account </a>if this is your first visit to the 
                  Shady Shades Members Area Login Page, for viewing your personal eligibility information.</p>
		      <p align="center">Or</p>
		      <p>If you would like to <a href="chgpswd.htm">change</a> the password for your existing Member Login Account.</p>
		      <p align="center">Or</p>
		      <p align="left">If you have <a href="fgtpswd.htm">forgotten </a>your password for your existing Login Account.</p>
		      <p align="center">&nbsp; </p>
	        </form>
    
    </div>
    </form>
</body>
</html>