Changing database password in production dictionary file

[Peter Bateman]

Hi Syed:

    It has been awhile since I have used SQL Server or Axiant so what follows are rough
   ideas.

   You may be able to bury the password in the resource file or in the ODBC.ini entry for
   your database.

   If you leave the username and password out of the dictionary definition then
   MS SQL Server client should present the user with a login screen.

   Did you consider using Windows authentication instead of username/password?

   A good discussion can be found at:-

    http://databases.about.com/od/sqlserver/a/authentication.htm

Regards,
Peter

Date: Mon, 26 Apr 2010 13:48:01 +0300
Subject: Re: Changing database password in production dictionary file
From: sshahulgm at gmail.com
To: mgo at columbus.rr.com
CC: powerh-l at lists.sowder.com

Is there any way to change the password stored in the dictionary without recompiling the dictionary?


 
On Mon, Apr 26, 2010 at 1:46 PM, Syed Shahul Hameed Mustaffa <sshahulgm at gmail.com> wrote:



Thank you Mike.
 
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.

 
Br,
SYED.





 
On Sun, Apr 25, 2010 at 6:59 PM, Mike Godsey <mgo at columbus.rr.com> wrote:




You change it in the source code for the dictionary and then recompile the dictionary.
Mike
 
 

From: powerh-l-bounces+mgo=columbus.rr.com at lists.sowder.com [mailto:powerh-l-bounces+mgo=columbus.rr.com at lists.sowder.com] On Behalf Of Syed Shahul Hameed Mustaffa

Sent: Sunday, April 25, 2010 10:36
To: powerh-l at lists.sowder.com 

Subject: Changing database password in production dictionary file





 

 





Dear list,




 

Can anyone help me?

 

I want to change the database password stored in the dictionary file in the production.

I need to do it from time to time. 

 

My database is in SQL Server 2000.

I have a thick client environment and I am running POWERHOUSE/Axiant 4GL.

 

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?

 

Best Regards,

SYED.
 

 		 	   		  
_________________________________________________________________
Videos that have everyone talking! Now also in HD!
http://go.microsoft.com/?linkid=9724465
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100426/1a17fc04/attachment.htm