<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi Syed:<br><br> It has been awhile since I have used SQL Server or Axiant so what follows are rough<br> ideas.<br><br> You may be able to bury the password in the resource file or in the ODBC.ini entry for<br> your database.<br><br> If you leave the username and password out of the dictionary definition then<br> MS SQL Server client should present the user with a login screen.<br><br> Did you consider using Windows authentication instead of username/password?<br><br> A good discussion can be found at:-<br><br> http://databases.about.com/od/sqlserver/a/authentication.htm<br><br>Regards,<br>Peter<br><br><hr id="stopSpelling">Date: Mon, 26 Apr 2010 13:48:01 +0300<br>Subject: Re: Changing database password in production dictionary file<br>From: sshahulgm@gmail.com<br>To: mgo@columbus.rr.com<br>CC: powerh-l@lists.sowder.com<br><br><div dir="ltr"><div>Is there any way to change the password stored in the dictionary without recompiling the dictionary?</div>
<div><br><br> </div>
<div class="ecxgmail_quote">On Mon, Apr 26, 2010 at 1:46 PM, Syed Shahul Hameed Mustaffa <span dir="ltr"><<a href="mailto:sshahulgm@gmail.com">sshahulgm@gmail.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;" class="ecxgmail_quote">
<div dir="ltr">
<div>Thank you Mike.</div>
<div> </div>
<div>Does that mean, if I want to have a different password in the production from development, i have to first set the intended production password in development and compile the dictionary. After compilation and copying change the development password back to the old one.</div>
<div> </div>
<div>Br,</div>
<div>SYED.</div>
<div>
<div></div>
<div class="h5">
<div><br><br> </div>
<div class="ecxgmail_quote">On Sun, Apr 25, 2010 at 6:59 PM, Mike Godsey <span dir="ltr"><<a href="mailto:mgo@columbus.rr.com">mgo@columbus.rr.com</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;" class="ecxgmail_quote">
<div lang="EN-US">
<div>
<p class="ecxMsoNormal"><span style="color: rgb(31, 73, 125); font-size: 11pt;">You change it in the source code for the dictionary and then recompile the dictionary.</span></p>
<p class="ecxMsoNormal"><span style="color: rgb(31, 73, 125); font-size: 11pt;">Mike</span></p>
<p class="ecxMsoNormal"><span style="color: rgb(31, 73, 125); font-size: 11pt;"> </span></p>
<p class="ecxMsoNormal"><span style="color: rgb(31, 73, 125); font-size: 11pt;"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="ecxMsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> powerh-l-bounces+mgo=<a href="http://columbus.rr.com/">columbus.rr.com</a>@<a href="http://lists.sowder.com/">lists.sowder.com</a> [mailto:<a href="mailto:powerh-l-bounces%2Bmgo">powerh-l-bounces+mgo</a>=<a href="http://columbus.rr.com/">columbus.rr.com</a>@<a href="http://lists.sowder.com/">lists.sowder.com</a>] <b>On Behalf Of </b>Syed Shahul Hameed Mustaffa<br>
<b>Sent:</b> Sunday, April 25, 2010 10:36<br><b>To:</b> <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>
<div><br><b>Subject:</b> Changing database password in production dictionary file</div></span>
</p><BR>
<BR><BR></div>
<p class="ecxMsoNormal"> </p>
<div>
<p class="ecxMsoNormal"> </p>
<div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); border-width: medium medium medium 1pt; padding: 0in 0in 0in 6pt; margin-left: 4.8pt; margin-right: 0in;">
<div>
<div>
<p class="ecxMsoNormal">Dear list,</p></div>
<div>
<div></div>
<div>
<div>
<p class="ecxMsoNormal"> </p></div>
<div>
<p class="ecxMsoNormal">Can anyone help me?</p></div>
<div>
<p class="ecxMsoNormal"> </p></div>
<div>
<p class="ecxMsoNormal">I want to change the database password stored in the dictionary file in the production.</p></div>
<div>
<p class="ecxMsoNormal">I need to do it from time to time. </p></div>
<div>
<p class="ecxMsoNormal"> </p></div>
<div>
<p class="ecxMsoNormal">My database is in SQL Server 2000.</p></div>
<div>
<p class="ecxMsoNormal">I have a thick client environment and I am running POWERHOUSE/Axiant 4GL.</p></div>
<div>
<p class="ecxMsoNormal"> </p></div>
<div>
<p class="ecxMsoNormal">I can change the password in the database. But how do i change the password in the dictionary to make it same as the password i have set in the database?</p></div>
<div>
<p class="ecxMsoNormal"> </p></div>
<div>
<p class="ecxMsoNormal">Best Regards,</p></div>
<div>
<p class="ecxMsoNormal">SYED.</p></div></div></div></div></blockquote></div>
<p class="ecxMsoNormal"> </p></div></div></div></blockquote></div><br></div></div></div></blockquote></div><br></div> <br /><hr />Videos that have everyone talking! Now also in HD! <a href='http://go.microsoft.com/?linkid=9724460' target='_new'>MSN.ca Video.</a></body>
</html>