By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,066 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

DMSII database connection for an ASP.NET site

P: 1
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
  1. <%
  2. 'Constant declarations
  3. Const CstrConn = "Location=8.8.1.122;Port=1601;Data Source=DBWEB;UID=SHADY22;Password=PASSWORD;Provider=Unisys.DMSii;OLE DB Services=-2"
  4. 'The constant Cadminpassword is used by MRMC personnel to log in to user accounts
  5. Const Cadminpassword = "#admin"
  6. Const CfundNum = "M80 "
  7. Const CeerFundNum = "M80 "
  8. Const CstrFundNum = "M80_"
  9. %>
  10.  



This is my .ASPX File:

Expand|Select|Wrap|Line Numbers
  1. <%@ Page Language="VB" %>
  2.  
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4.  
  5. <script runat="server">
  6.  
  7. </script>
  8.  
  9. <html xmlns="http://www.w3.org/1999/xhtml">
  10. <head runat="server">
  11.     <title></title>
  12.     <style type="text/css">
  13.         .style1
  14.         {
  15.             font-size: x-large;
  16.             font-weight: bold;
  17.         }
  18.     </style>
  19. </head>
  20. <body>
  21.     <form id="form1" runat="server">
  22.     <div class="style1" style="text-align: center">
  23.         ASP.NET Test Site<form action="login_resp.asp" method="post" id="Form2" name="Form2">
  24.               <table border="0" width="100%" id="table2">
  25.                 <tr>
  26.                   <td width="50%" align="right"><strong>User Id&nbsp;&nbsp;</strong></td>
  27.                   <td width="50%"><input type="text" id="fuserid" name="fuserid" size="12" maxlength="12" /></td>
  28.                 </tr>
  29.                 <tr>
  30.                   <td width="50%" align="right"><strong>Password&nbsp;&nbsp;</strong></td>
  31.                   <td width="50%"><input type="password" name="fpswd" size="12" maxlength="12" /></td>
  32.                 </tr>
  33.                 <tr>
  34.                   <td width="50%"></td>
  35.                   <td width="50%"></td>
  36.                 </tr>
  37.                 <tr>
  38.                   <td width="50%" align="right"><input type="submit" value="Submit" name="B1" onclick="passedEdit()" /></td>
  39.                   <td width="50%"><input type="button" value="Reset" name="B2" onclick="clearText(document.Form2.fuserid,document.Form2.fpswd)" /></td>
  40.                 </tr>
  41.               </table>
  42.               <br />
  43.               <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 
  44.                   Shady Shades Members Area Login Page, for viewing your personal eligibility information.</p>
  45.               <p align="center">Or</p>
  46.               <p>If you would like to <a href="chgpswd.htm">change</a> the password for your existing Member Login Account.</p>
  47.               <p align="center">Or</p>
  48.               <p align="left">If you have <a href="fgtpswd.htm">forgotten </a>your password for your existing Login Account.</p>
  49.               <p align="center">&nbsp; </p>
  50.             </form>
  51.  
  52.     </div>
  53.     </form>
  54. </body>
  55. </html>
  56.  
Jan 23 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.