Prompted for 'sysprogress' password in linked Access database 8

Yahoo Archive
1
Bingo...I had to delete the link and then check the save password when recreating the link. Thanks guys.

From: Vic Drecchio [mailto:vic.drecchio@...]
Sent: Friday, April 26, 2013 10:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Prompted for 'sysprogress' password in linked Access database 8.03.409C



Just confirming that it *is* "PWD".

DSN=MyVantageDSN;HOST=MyVantageServer;DB=MfgSys;UID=sysprogress;PWD=sysprogr
ess;PORT=8350;

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
b_ordway
Sent: Friday, April 26, 2013 11:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Prompted for 'sysprogress' password in linked Access
database 8.03.409C

>>every time you access the table it prompts for the ODBC password.
I assume this is on a client PC and you have already set up an ODBC DSN.

You could try adding a registry string for the ODBC password.
Off the top of my head, I can't remember if the string name is "PWD" or
"Password". You can put both in without hurting anything.

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\xxxxxxx]
"Driver"="d:\\oe101b\\bin\\pgoe1022.dll"
"Description"="OE10"
"HostName"="xxxxxxx"
"PortNumber"="8350"
"DatabaseName"="mfgsys"
"LogonID"="sysprogress"
"StaticCursorLongColBuffLen"="4096"
"UseWideCharacterTypes"="0"
"EnableTimestampWithTimezone"="1"
"DefaultIsolationLevel"="READ UNCOMMITTED"
"ArraySize"="400"
"DefaultLongDataBuffLen"="2048"
"Workarounds2"="8192"
"Password"="sysprogress"
"PWD"="sysprogress"

You may want to add the Workarounds2 string too.
Some versions of Progress won't allow adding of tables link in Access
without it.

And for Access, you should see a checkbox to save the password when adding
new table links.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "Mark"
<mtellefson@...<mailto:mtellefson@...>> wrote:
>
> I have an Access database that is linked to the Vantage customer table.
The link was setup using dbvisualizer (thanks to help from here) and works
fine but every time you access the table it prompts for the ODBC password.
On my computer I am also prompted for it when working on crystal reports but
when running any custom crystal reports from within Vantage it does not
prompt anyone. Any ideas how I can past this?
>
> Mark
>

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

_____________________________________________________________________________________________________

[http://www.rapat.com/download/logoflat.jpg%5d<http://www.rapat.com>

Mark Tellefson | Global IT Director | www.rapat.com<http://www.rapat.com>

Phone: (218) 483-3344 | Toll Free: (800) 325-6377

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient and received this in error, please contact the sender by reply e-mail. You are hereby notified that the copying, use or distribution of any information or materials transmitted in or with this message is strictly prohibited.


[Non-text portions of this message have been removed]
2
I have an Access database that is linked to the Vantage customer table. The link was setup using dbvisualizer (thanks to help from here) and works fine but every time you access the table it prompts for the ODBC password. On my computer I am also prompted for it when working on crystal reports but when running any custom crystal reports from within Vantage it does not prompt anyone. Any ideas how I can past this?

Mark
3
I searched the registry and found 2 entries that had the UserID set to sysprogress and added the Password string sysprogress but I am still getting prompted to enter it every time.

--- In vantage@yahoogroups.com, "Mark" <mtellefson@...> wrote:
>
> I have an Access database that is linked to the Vantage customer table. The link was setup using dbvisualizer (thanks to help from here) and works fine but every time you access the table it prompts for the ODBC password. On my computer I am also prompted for it when working on crystal reports but when running any custom crystal reports from within Vantage it does not prompt anyone. Any ideas how I can past this?
>
> Mark
>
4
>>every time you access the table it prompts for the ODBC password.
I assume this is on a client PC and you have already set up an ODBC DSN.

You could try adding a registry string for the ODBC password.
Off the top of my head, I can't remember if the string name is "PWD" or "Password". You can put both in without hurting anything.


[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\xxxxxxx]
"Driver"="d:\\oe101b\\bin\\pgoe1022.dll"
"Description"="OE10"
"HostName"="xxxxxxx"
"PortNumber"="8350"
"DatabaseName"="mfgsys"
"LogonID"="sysprogress"
"StaticCursorLongColBuffLen"="4096"
"UseWideCharacterTypes"="0"
"EnableTimestampWithTimezone"="1"
"DefaultIsolationLevel"="READ UNCOMMITTED"
"ArraySize"="400"
"DefaultLongDataBuffLen"="2048"
"Workarounds2"="8192"
"Password"="sysprogress"
"PWD"="sysprogress"

You may want to add the Workarounds2 string too.
Some versions of Progress won't allow adding of tables link in Access without it.

And for Access, you should see a checkbox to save the password when adding new table links.

--- In vantage@yahoogroups.com, "Mark" <mtellefson@...> wrote:
>
> I have an Access database that is linked to the Vantage customer table. The link was setup using dbvisualizer (thanks to help from here) and works fine but every time you access the table it prompts for the ODBC password. On my computer I am also prompted for it when working on crystal reports but when running any custom crystal reports from within Vantage it does not prompt anyone. Any ideas how I can past this?
>
> Mark
>
5
Just confirming that it *is* "PWD".







DSN=MyVantageDSN;HOST=MyVantageServer;DB=MfgSys;UID=sysprogress;PWD=sysprogr
ess;PORT=8350;



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
b_ordway
Sent: Friday, April 26, 2013 11:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Prompted for 'sysprogress' password in linked Access
database 8.03.409C





>>every time you access the table it prompts for the ODBC password.
I assume this is on a client PC and you have already set up an ODBC DSN.

You could try adding a registry string for the ODBC password.
Off the top of my head, I can't remember if the string name is "PWD" or
"Password". You can put both in without hurting anything.

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\xxxxxxx]
"Driver"="d:\\oe101b\\bin\\pgoe1022.dll"
"Description"="OE10"
"HostName"="xxxxxxx"
"PortNumber"="8350"
"DatabaseName"="mfgsys"
"LogonID"="sysprogress"
"StaticCursorLongColBuffLen"="4096"
"UseWideCharacterTypes"="0"
"EnableTimestampWithTimezone"="1"
"DefaultIsolationLevel"="READ UNCOMMITTED"
"ArraySize"="400"
"DefaultLongDataBuffLen"="2048"
"Workarounds2"="8192"
"Password"="sysprogress"
"PWD"="sysprogress"

You may want to add the Workarounds2 string too.
Some versions of Progress won't allow adding of tables link in Access
without it.

And for Access, you should see a checkbox to save the password when adding
new table links.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Mark"
<mtellefson@...> wrote:
>
> I have an Access database that is linked to the Vantage customer table.
The link was setup using dbvisualizer (thanks to help from here) and works
fine but every time you access the table it prompts for the ODBC password.
On my computer I am also prompted for it when working on crystal reports but
when running any custom crystal reports from within Vantage it does not
prompt anyone. Any ideas how I can past this?
>
> Mark
>





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