Problem with Customized Crystal Reports using ODBC to an SQL da

Yahoo Archive
1
Gary, we've had the same issues with Support. Did you check to ensure the
sysprogress user is setup as a user in the SQL server and has "data reader"
rights to the DB? That's what fixed our issue.



Thanks,

Randy Stulce <http://www.companionsystems.com/>
<http://www.companionsystems.com/>

<http://www.companionsystems.com/>







_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Gary Franks
Sent: Friday, March 23, 2007 3:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Problem with Customized Crystal Reports using ODBC to
an SQL database



Well, we do have System DSN's setup. The System task agent has
'sysprogress', 'sysprogress' setup, which is what the Epicor install
tech configured. That's not the name of our ODBC connection's
account, though. It was explained that the above settings were needed
for Epicor, not for Crystal, so I haven't made any changes to those yet.

Epicor support has been almost completely 'silent' on this problem,
other than referring me to the 'odbc kit' that we already had. Pretty
lukewarm support, in my opinion. Also, IMHO, Epicor support seems
poorly equipped to handle anything SQL.....most of their answers are
forumulated in terms of Progress.

OK....I'm grumbling a bit much, just wish their support lived up to
their sales hype, I guess.

Gary

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Gary
Franks" <garyfr2003@...> wrote:
>
> VERY good point, Chris. I think my tech setup the DSN's in System,
> but I'll double-check that he didn't do so in USER instead. I'll also
> recheck the System Task Agent as well.
>
> I appreciate the quick reply...
>
> Cheers,
> - Gary -
>
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Chris
Clunn" <chris.clunn@> wrote:
> >
> > The only time I've had it ask for the login is when the ODBC Data
Source
> > wasn't loaded properly on the client. Did you possibly have the ODBC
> > data source setup under User DSN and not System DSN. This would
> > potentially explain why it works for you and not your users?
> >
> > Also, did you setup the odbcuser account and fill in the username and
> > password in the System Task Agent? This shouldn't be an issue if some
> > of your users are working properly but just in case.
> >
> > From the System Agent Maintenance help files:
> >
> >
> > Password
> >
> >
> > The password (corresponding to the User ID) for ODBC connections
to the
> > database. This field is valuable if you want to run Crystal Reports
> > directly from the menu, without first being prompted for the ODBC user
> > ID and password.
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
> > Of Gary Franks
> > Sent: Thursday, March 22, 2007 1:03 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Problem with Customized Crystal Reports using
ODBC to
> > an SQL database
> >
> >
> >
> > We are fairly new with Vantage, & now that we have multiple Crystal
> > Reports that have been customized by Epicor, we were told to install
> > the SQL ODBC drivers on all workstations that need to print these
> > reports. This seems to work on MOST machines, but on a few, we get an
> > additional (and, inappropriate) db login prompt. IF we first login on
> > those workstations with Domain Admin credentials, & then go into
> > Vantage, the reports print just fine, with no errors or additional
> > prompts. I'm also the Lan admin, as well as the SQL-admin, & thought
> > I could find this, no problem....wrong. I'm sure it must be something
> > stupid that I'm overlooking, but if anyone has any other suggestions,
> > I'd appreciate it. So far, the report author is unable to help at
> > all.....she isn't a lan admin type, unfortunately.
> >
> > Thanks in advance......Gary
> >
> >
> >
> >
> > This is an e-mail from Saab Barracuda LLC. It is for the intended
> recipient only and may contain confidential and privileged
> information. No one else may read, print, store, copy, forward or act
> in reliance on it or its attachments. If you are not the intended
> recipient, please return this message to the sender and delete the
> message and any attachments from your computer. Your cooperation is
> appreciated.
> >
> > ###########################################
> >
> > This message has been scanned by F-Secure Anti-Virus for Microsoft
> Exchange.
> > For more information, connect to http://www.f-
<http://www.f-secure.com/> secure.com/
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
2
We are fairly new with Vantage, & now that we have multiple Crystal
Reports that have been customized by Epicor, we were told to install
the SQL ODBC drivers on all workstations that need to print these
reports. This seems to work on MOST machines, but on a few, we get an
additional (and, inappropriate) db login prompt. IF we first login on
those workstations with Domain Admin credentials, & then go into
Vantage, the reports print just fine, with no errors or additional
prompts. I'm also the Lan admin, as well as the SQL-admin, & thought
I could find this, no problem....wrong. I'm sure it must be something
stupid that I'm overlooking, but if anyone has any other suggestions,
I'd appreciate it. So far, the report author is unable to help at
all.....she isn't a lan admin type, unfortunately.

Thanks in advance......Gary
3
The only time I've had it ask for the login is when the ODBC Data Source
wasn't loaded properly on the client. Did you possibly have the ODBC
data source setup under User DSN and not System DSN. This would
potentially explain why it works for you and not your users?

Also, did you setup the odbcuser account and fill in the username and
password in the System Task Agent? This shouldn't be an issue if some
of your users are working properly but just in case.

From the System Agent Maintenance help files:


Password


The password (corresponding to the User ID) for ODBC connections to the
database. This field is valuable if you want to run Crystal Reports
directly from the menu, without first being prompted for the ODBC user
ID and password.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Franks
Sent: Thursday, March 22, 2007 1:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Problem with Customized Crystal Reports using ODBC to
an SQL database



We are fairly new with Vantage, & now that we have multiple Crystal
Reports that have been customized by Epicor, we were told to install
the SQL ODBC drivers on all workstations that need to print these
reports. This seems to work on MOST machines, but on a few, we get an
additional (and, inappropriate) db login prompt. IF we first login on
those workstations with Domain Admin credentials, & then go into
Vantage, the reports print just fine, with no errors or additional
prompts. I'm also the Lan admin, as well as the SQL-admin, & thought
I could find this, no problem....wrong. I'm sure it must be something
stupid that I'm overlooking, but if anyone has any other suggestions,
I'd appreciate it. So far, the report author is unable to help at
all.....she isn't a lan admin type, unfortunately.

Thanks in advance......Gary




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
4
VERY good point, Chris. I think my tech setup the DSN's in System,
but I'll double-check that he didn't do so in USER instead. I'll also
recheck the System Task Agent as well.

I appreciate the quick reply...

Cheers,
- Gary -


--- In vantage@yahoogroups.com, "Chris Clunn" <chris.clunn@...> wrote:
>
> The only time I've had it ask for the login is when the ODBC Data Source
> wasn't loaded properly on the client. Did you possibly have the ODBC
> data source setup under User DSN and not System DSN. This would
> potentially explain why it works for you and not your users?
>
> Also, did you setup the odbcuser account and fill in the username and
> password in the System Task Agent? This shouldn't be an issue if some
> of your users are working properly but just in case.
>
> From the System Agent Maintenance help files:
>
>
> Password
>
>
> The password (corresponding to the User ID) for ODBC connections to the
> database. This field is valuable if you want to run Crystal Reports
> directly from the menu, without first being prompted for the ODBC user
> ID and password.
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Gary Franks
> Sent: Thursday, March 22, 2007 1:03 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Problem with Customized Crystal Reports using ODBC to
> an SQL database
>
>
>
> We are fairly new with Vantage, & now that we have multiple Crystal
> Reports that have been customized by Epicor, we were told to install
> the SQL ODBC drivers on all workstations that need to print these
> reports. This seems to work on MOST machines, but on a few, we get an
> additional (and, inappropriate) db login prompt. IF we first login on
> those workstations with Domain Admin credentials, & then go into
> Vantage, the reports print just fine, with no errors or additional
> prompts. I'm also the Lan admin, as well as the SQL-admin, & thought
> I could find this, no problem....wrong. I'm sure it must be something
> stupid that I'm overlooking, but if anyone has any other suggestions,
> I'd appreciate it. So far, the report author is unable to help at
> all.....she isn't a lan admin type, unfortunately.
>
> Thanks in advance......Gary
>
>
>
>
> This is an e-mail from Saab Barracuda LLC. It is for the intended
recipient only and may contain confidential and privileged
information. No one else may read, print, store, copy, forward or act
in reliance on it or its attachments. If you are not the intended
recipient, please return this message to the sender and delete the
message and any attachments from your computer. Your cooperation is
appreciated.
>
> ###########################################
>
> This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
> For more information, connect to http://www.f-secure.com/
>
> [Non-text portions of this message have been removed]
>
5
Well, we do have System DSN's setup. The System task agent has
'sysprogress', 'sysprogress' setup, which is what the Epicor install
tech configured. That's not the name of our ODBC connection's
account, though. It was explained that the above settings were needed
for Epicor, not for Crystal, so I haven't made any changes to those yet.

Epicor support has been almost completely 'silent' on this problem,
other than referring me to the 'odbc kit' that we already had. Pretty
lukewarm support, in my opinion. Also, IMHO, Epicor support seems
poorly equipped to handle anything SQL.....most of their answers are
forumulated in terms of Progress.

OK....I'm grumbling a bit much, just wish their support lived up to
their sales hype, I guess.

Gary

--- In vantage@yahoogroups.com, "Gary Franks" <garyfr2003@...> wrote:
>
> VERY good point, Chris. I think my tech setup the DSN's in System,
> but I'll double-check that he didn't do so in USER instead. I'll also
> recheck the System Task Agent as well.
>
> I appreciate the quick reply...
>
> Cheers,
> - Gary -
>
>
> --- In vantage@yahoogroups.com, "Chris Clunn" <chris.clunn@> wrote:
> >
> > The only time I've had it ask for the login is when the ODBC Data
Source
> > wasn't loaded properly on the client. Did you possibly have the ODBC
> > data source setup under User DSN and not System DSN. This would
> > potentially explain why it works for you and not your users?
> >
> > Also, did you setup the odbcuser account and fill in the username and
> > password in the System Task Agent? This shouldn't be an issue if some
> > of your users are working properly but just in case.
> >
> > From the System Agent Maintenance help files:
> >
> >
> > Password
> >
> >
> > The password (corresponding to the User ID) for ODBC connections
to the
> > database. This field is valuable if you want to run Crystal Reports
> > directly from the menu, without first being prompted for the ODBC user
> > ID and password.
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> > Of Gary Franks
> > Sent: Thursday, March 22, 2007 1:03 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Problem with Customized Crystal Reports using
ODBC to
> > an SQL database
> >
> >
> >
> > We are fairly new with Vantage, & now that we have multiple Crystal
> > Reports that have been customized by Epicor, we were told to install
> > the SQL ODBC drivers on all workstations that need to print these
> > reports. This seems to work on MOST machines, but on a few, we get an
> > additional (and, inappropriate) db login prompt. IF we first login on
> > those workstations with Domain Admin credentials, & then go into
> > Vantage, the reports print just fine, with no errors or additional
> > prompts. I'm also the Lan admin, as well as the SQL-admin, & thought
> > I could find this, no problem....wrong. I'm sure it must be something
> > stupid that I'm overlooking, but if anyone has any other suggestions,
> > I'd appreciate it. So far, the report author is unable to help at
> > all.....she isn't a lan admin type, unfortunately.
> >
> > Thanks in advance......Gary
> >
> >
> >
> >
> > This is an e-mail from Saab Barracuda LLC. It is for the intended
> recipient only and may contain confidential and privileged
> information. No one else may read, print, store, copy, forward or act
> in reliance on it or its attachments. If you are not the intended
> recipient, please return this message to the sender and delete the
> message and any attachments from your computer. Your cooperation is
> appreciated.
> >
> > ###########################################
> >
> > This message has been scanned by F-Secure Anti-Virus for Microsoft
> Exchange.
> > For more information, connect to http://www.f-secure.com/
> >
> > [Non-text portions of this message have been removed]
> >
>
6
I'm not sure if this is any help but I found it today while browsing the
Answerbook articles:


AnswerBook #:
5947MPS
Product:
Vantage


Added:
11/18/2005
Version:
8.00.807


Changed:
03/22/2007
Module:
Crystal Reports



Summary:
CR Bypass the login ID and prompt for a Crystal Report using an
ODBC connection.


Details:


PROBLEM: Bypass the login ID and prompt for a Crystal Report
using an ODBC connection.

A Crystal form that has been modified with a subreport written using an
ODBC connection continues to prompt for the ODBC System DSN login ID and
password parameters.

The ODBC Driver for Open Edge 10.0B must be installed on each client
that will be using an ODBC modified report.

For V8.03, an ODBC driver is not necessary for a customer Crystal
Report. See document 7931MPS for instructions on creating a Crystal
Report from a BAQ within V8.03.

RESOLUTION:
1. Go to Start->Run, and 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. Repeat the process for your Password.
9. Exit the Registry.
10. In the SystemTaskAgent (System Management->Utilities->System Agent),
under ODBC Connection, put in the User ID and Password above.
11. In the Progress Explorer Too, stop and start the TaskAgent and
ProcessServer for this database.
12. Test your report and you should not get prompted.

XA800
XA803

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Franks
Sent: Friday, March 23, 2007 5:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Problem with Customized Crystal Reports using
ODBC to an SQL database



Well, we do have System DSN's setup. The System task agent has
'sysprogress', 'sysprogress' setup, which is what the Epicor install
tech configured. That's not the name of our ODBC connection's
account, though. It was explained that the above settings were needed
for Epicor, not for Crystal, so I haven't made any changes to those yet.

Epicor support has been almost completely 'silent' on this problem,
other than referring me to the 'odbc kit' that we already had. Pretty
lukewarm support, in my opinion. Also, IMHO, Epicor support seems
poorly equipped to handle anything SQL.....most of their answers are
forumulated in terms of Progress.

OK....I'm grumbling a bit much, just wish their support lived up to
their sales hype, I guess.

Gary

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Gary Franks" <garyfr2003@...> wrote:
>
> VERY good point, Chris. I think my tech setup the DSN's in System,
> but I'll double-check that he didn't do so in USER instead. I'll also
> recheck the System Task Agent as well.
>
> I appreciate the quick reply...
>
> Cheers,
> - Gary -
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Chris Clunn" <chris.clunn@> wrote:
> >
> > The only time I've had it ask for the login is when the ODBC Data
Source
> > wasn't loaded properly on the client. Did you possibly have the ODBC
> > data source setup under User DSN and not System DSN. This would
> > potentially explain why it works for you and not your users?
> >
> > Also, did you setup the odbcuser account and fill in the username
and
> > password in the System Task Agent? This shouldn't be an issue if
some
> > of your users are working properly but just in case.
> >
> > From the System Agent Maintenance help files:
> >
> >
> > Password
> >
> >
> > The password (corresponding to the User ID) for ODBC connections
to the
> > database. This field is valuable if you want to run Crystal Reports
> > directly from the menu, without first being prompted for the ODBC
user
> > ID and password.
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of Gary Franks
> > Sent: Thursday, March 22, 2007 1:03 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Problem with Customized Crystal Reports using
ODBC to
> > an SQL database
> >
> >
> >
> > We are fairly new with Vantage, & now that we have multiple Crystal
> > Reports that have been customized by Epicor, we were told to install
> > the SQL ODBC drivers on all workstations that need to print these
> > reports. This seems to work on MOST machines, but on a few, we get
an
> > additional (and, inappropriate) db login prompt. IF we first login
on
> > those workstations with Domain Admin credentials, & then go into
> > Vantage, the reports print just fine, with no errors or additional
> > prompts. I'm also the Lan admin, as well as the SQL-admin, & thought
> > I could find this, no problem....wrong. I'm sure it must be
something
> > stupid that I'm overlooking, but if anyone has any other
suggestions,
> > I'd appreciate it. So far, the report author is unable to help at
> > all.....she isn't a lan admin type, unfortunately.
> >
> > Thanks in advance......Gary
> >
> >
> >
> >
> > This is an e-mail from Saab Barracuda LLC. It is for the intended
> recipient only and may contain confidential and privileged
> information. No one else may read, print, store, copy, forward or act
> in reliance on it or its attachments. If you are not the intended
> recipient, please return this message to the sender and delete the
> message and any attachments from your computer. Your cooperation is
> appreciated.
> >
> > ###########################################
> >
> > This message has been scanned by F-Secure Anti-Virus for Microsoft
> Exchange.
> > For more information, connect to http://www.f-secure.com/
<http://www.f-secure.com/>
> >
> > [Non-text portions of this message have been removed]
> >
>




This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

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