DMSII database connection for an ASP.NET site

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.

Expand|Select|Wrap|Line Numbers

 
<%

'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:

Expand|Select|Wrap|Line Numbers

 
<%@ 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>

Jan 23 '12 #1

Follow Post Reply

2387

DMSII database connection for an ASP.NET site

Post your reply

Similar topics