Crystal subreports prompt for credentials

I appreciate everyone's replies.
I sort of thought we'd left ODBC behind in the dust a long time ago, but if that's all the choice I have, then what can I do.



----- Original Message ----
From: brad.ebright <bebright@...>
To: vantage@yahoogroups.com
Sent: Monday, June 2, 2008 9:12:41 AM
Subject: [Vantage] Re: Crystal subreports prompt for credentials


Problem Resolution:
1. Go to Start -> Run -> type in regedit 2. This will bring up your
Registry Editor.
3. Find the HKEY_LOCAL_MACHINE\ SOFTWARE\ ODBC\ODBC. INI.
4. Find your specific ODBC connection that is setup in your ODBC
datasources and double-click on it.
5. Go up to the Edit -> New -> String Value in the menu.
6. Give your New String Value the name of User ID.
7. Then double-click and give it a value of sysprogress. (Or
whatever your user id is setup to be.) 8. Exit the Registry.
9. Repeat the process for your Password.
10. In the SystemTaskAgent, under ODBC Connection, put in the User
ID and Password above.
11. Stop and start the TaskAgent and ProcessServer for this database.
12. Test your report and you should not get prompted.

--- In vantage@yahoogroups .com, Tony Hughes <thughes281@ ...> wrote:
>
>
> I need to run a Crystal report that has a subreport, and I need the
subreport to not prompt user for credentials.
> Can I embed them somehow? I tried everything that I could think of,
but user is still prompted.
>
> just curious, but
> Why do subreports prompt for credentials? ie, why doesn't the sub
run
> under the security context of the regular report with credentials
as defined in System
> agent?
>
> Thanks for any suggestions
>






[Non-text portions of this message have been removed]
I need to run a Crystal report that has a subreport, and I need the subreport to not prompt user for credentials.
Can I embed them somehow? I tried everything that I could think of, but user is still prompted.

just curious, but
Why do subreports prompt for credentials? ie, why doesn't the sub run
under the security context of the regular report with credentials as defined in System
agent?

Thanks for any suggestions
You need to add a key to the client registries to hold the password


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation


Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Monday, June 02, 2008 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal subreports prompt for credentials




I need to run a Crystal report that has a subreport, and I need the
subreport to not prompt user for credentials.
Can I embed them somehow? I tried everything that I could think of, but
user is still prompted.

just curious, but
Why do subreports prompt for credentials? ie, why doesn't the sub run
under the security context of the regular report with credentials as
defined in System
agent?

Thanks for any suggestions






[Non-text portions of this message have been removed]
You have to have the user id and the password in the registry entries
for the ODBC connection on that workstation.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Monday, June 02, 2008 8:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal subreports prompt for credentials




I need to run a Crystal report that has a subreport, and I need the
subreport to not prompt user for credentials.
Can I embed them somehow? I tried everything that I could think of, but
user is still prompted.

just curious, but
Why do subreports prompt for credentials? ie, why doesn't the sub run
under the security context of the regular report with credentials as
defined in System
agent?

Thanks for any suggestions



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]
Problem Resolution:
1. Go to Start -> Run -> type in regedit 2. This will bring up your
Registry Editor.
3. Find the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI.
4. Find your specific ODBC connection that is setup in your ODBC
datasources and double-click on it.
5. Go up to the Edit -> New -> String Value in the menu.
6. Give your New String Value the name of User ID.
7. Then double-click and give it a value of sysprogress. (Or
whatever your user id is setup to be.) 8. Exit the Registry.
9. Repeat the process for your Password.
10. In the SystemTaskAgent, under ODBC Connection, put in the User
ID and Password above.
11. Stop and start the TaskAgent and ProcessServer for this database.
12. Test your report and you should not get prompted.


--- In vantage@yahoogroups.com, Tony Hughes <thughes281@...> wrote:
>
>
> I need to run a Crystal report that has a subreport, and I need the
subreport to not prompt user for credentials.
> Can I embed them somehow? I tried everything that I could think of,
but user is still prompted.
>
> just curious, but
> Why do subreports prompt for credentials? ie, why doesn't the sub
run
> under the security context of the regular report with credentials
as defined in System
> agent?
>
> Thanks for any suggestions
>