How to change sysprogress password?

From what I understand (and I may stand completely corrected on this), manager is a user id set on the Vantage application and sysprogress is a ODBC/ database (Progress/SQL userid) and is not the same as manager which is in the system agent window. But I don't know how you guys have it set up. But you can confirm this through odbc sql select * from pub.userfile
When creating new databases, I've always had to go into the Data Administration tool on Progress and add new user sysprogress to the database and grant select privileges to this user.
Some other vantage technical expert may be able to shed further light on this.
Thanks
RSN



[Non-text portions of this message have been removed]
Does anyone have instructions on changing the ODBC password?



Steve Ashton
Database Specialist
Decoustics Limited
65 Disco Road
Toronto, Ontario
Canada M9W 1M2
T (647) 259-4260
F (416) 679-8838

sashton@... <mailto:sashton@...>
Steve.Ashton@... <mailto:Steve.Ashton2@...>






[Non-text portions of this message have been removed]
Go in to System Management, Utilities folder and look at System Agent.
The account and password that vantage passes is defined there.



----- Original Message ----
From: "Ashton, Steve" <Steve.Ashton@...>
To: vantage@yahoogroups.com
Sent: Wednesday, June 11, 2008 1:29:04 PM
Subject: [Vantage] How to change sysprogress password?


Does anyone have instructions on changing the ODBC password?

Steve Ashton
Database Specialist
Decoustics Limited
65 Disco Road
Toronto, Ontario
Canada M9W 1M2
T (647) 259-4260
F (416) 679-8838

sashton@decoustics. com <mailto:sashton@decoustics. com>
Steve.Ashton@ saint-gobain. com <mailto:Steve.Ashton2@ saint-gobain. com>


[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Make sure the database is running. It is best not to have the
application servers running.



Run Open Edge Data Administration, connect to the database using the
sysprogress userid, then select Admin/Security/Edit User List. The
correct way to connect would be:



Physical Name <DataLocation>/mfgsys (do not include the
.db)

Network: TCP

Multiple User: Check this box if the application
servers are running

Service Name: 8300 (port for the database)

User Id: sysprogress

Password: <sysprogress password>



If you do not see any options other than Physical Name then click the
"Options >>" button.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ashton, Steve
Sent: Wednesday, June 11, 2008 1:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] How to change sysprogress password?



Does anyone have instructions on changing the ODBC password?

Steve Ashton
Database Specialist
Decoustics Limited
65 Disco Road
Toronto, Ontario
Canada M9W 1M2
T (647) 259-4260
F (416) 679-8838

sashton@... <mailto:sashton%40decoustics.com>
<mailto:sashton@... <mailto:sashton%40decoustics.com> >
Steve.Ashton@... <mailto:Steve.Ashton%40saint-gobain.com>
<mailto:Steve.Ashton2@...
<mailto:Steve.Ashton2%40saint-gobain.com> >


[Non-text portions of this message have been removed]



Charles Carden
Manager, MIS
Manitex, Inc.
Phone: 512-942-3086
Fax: 512-942-3089


DISCLAIMER:
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



[Non-text portions of this message have been removed]