Crystal Report asking for database login

system · September 7, 2011, 11:34am

Thanks for the help. I thought that may be what is happening.

Beth

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cubcrafters_it
Sent: Wednesday, September 07, 2011 11:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report asking for database login

If you're using the ODBC driver to pull additional tables for your report
you'll need to have it configured as a DSN on the local system. On EpicWeb
there's documentation on how to do that via a registry entry.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"c.krusen1" <ckrusen1@...> wrote:

>
> And the userid on the clients ODBC settings set to "sysprogress' (or

whatever yours is)?

>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"cooner_55421" <cooner_55421@> wrote:

> >
> > Hi Bethany,
> >
> > >and we use the ODBC driver.
> > Is the ODBC data source set up on the client PCs?
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,

"Bethany Rye" <brye@> wrote:

> > >
> > > Can anyone tell me why my Crystal report would be asking for a

database

> > > login and password? It runs fine on the report writer's computer and

on the

> > > IT Director's computer but anyone else gets a box that asks for a

login and

> > > password.
> > >
> > >
> > >
> > > We have created a new subreport in the Priority Dispatch Report and we

are

> > > accessing only one table, JOBPROD, and we use the ODBC driver. Any

help

> > > would be appreciated.
> > >
> > >
> > >
> > > Beth Rye
> > >
> > > IT Director
> > >
> > > CIGNYS
> > > Email: <mailto:brye@> brye@
> > >
> > >
> > >
> > > ***ITAR NOTICE***
> > >
> > > This e-mail and/or the attached documents may contain technical data

within

> > > the definition of the International Traffic in Arms regulations, and

are

> > > subject to the export control laws of the US Government. Transfer of

this

> > > data by any means to a foreign person, whether in the US or abroad,

without

> > > an export license or other approval from the US Department of State,

is

> > > prohibited. No portion of this e-mail or its attachment(s) may be

reproduced

> > > without written consent of CIGNYS. If you are not the intended

recipient or

> > > believe that you may have received this document in error, please

notify the

> > > sender and delete this e-mail and any attachments immediately.
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>

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

system · September 7, 2011, 10:39am

Can anyone tell me why my Crystal report would be asking for a database
login and password? It runs fine on the report writer's computer and on the
IT Director's computer but anyone else gets a box that asks for a login and
password.

We have created a new subreport in the Priority Dispatch Report and we are
accessing only one table, JOBPROD, and we use the ODBC driver. Any help
would be appreciated.

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

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

system · September 7, 2011, 10:49am

Hi Bethany,

>and we use the ODBC driver.

Is the ODBC data source set up on the client PCs?

--- In vantage@yahoogroups.com, "Bethany Rye" <brye@...> wrote:
>
> Can anyone tell me why my Crystal report would be asking for a database
> login and password? It runs fine on the report writer's computer and on the
> IT Director's computer but anyone else gets a box that asks for a login and
> password.
>
>
>
> We have created a new subreport in the Priority Dispatch Report and we are
> accessing only one table, JOBPROD, and we use the ODBC driver. Any help
> would be appreciated.
>
>
>
> Beth Rye
>
> IT Director
>
> CIGNYS
> Email: <mailto:brye@...> brye@...
>
>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad, without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> without written consent of CIGNYS. If you are not the intended recipient or
> believe that you may have received this document in error, please notify the
> sender and delete this e-mail and any attachments immediately.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 7, 2011, 11:04am

And the userid on the clients ODBC settings set to "sysprogress' (or whatever yours is)?

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi Bethany,
>
> >and we use the ODBC driver.
> Is the ODBC data source set up on the client PCs?
>
>
> --- In vantage@yahoogroups.com, "Bethany Rye" <brye@> wrote:
> >
> > Can anyone tell me why my Crystal report would be asking for a database
> > login and password? It runs fine on the report writer's computer and on the
> > IT Director's computer but anyone else gets a box that asks for a login and
> > password.
> >
> >
> >
> > We have created a new subreport in the Priority Dispatch Report and we are
> > accessing only one table, JOBPROD, and we use the ODBC driver. Any help
> > would be appreciated.
> >
> >
> >
> > Beth Rye
> >
> > IT Director
> >
> > CIGNYS
> > Email: <mailto:brye@> brye@
> >
> >
> >
> > ***ITAR NOTICE***
> >
> > This e-mail and/or the attached documents may contain technical data within
> > the definition of the International Traffic in Arms regulations, and are
> > subject to the export control laws of the US Government. Transfer of this
> > data by any means to a foreign person, whether in the US or abroad, without
> > an export license or other approval from the US Department of State, is
> > prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> > without written consent of CIGNYS. If you are not the intended recipient or
> > believe that you may have received this document in error, please notify the
> > sender and delete this e-mail and any attachments immediately.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

system · September 7, 2011, 11:12am

If you're using the ODBC driver to pull additional tables for your report you'll need to have it configured as a DSN on the local system. On EpicWeb there's documentation on how to do that via a registry entry.

--- In vantage@yahoogroups.com, "c.krusen1" <ckrusen1@...> wrote:
>
> And the userid on the clients ODBC settings set to "sysprogress' (or whatever yours is)?
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > Hi Bethany,
> >
> > >and we use the ODBC driver.
> > Is the ODBC data source set up on the client PCs?
> >
> >
> > --- In vantage@yahoogroups.com, "Bethany Rye" <brye@> wrote:
> > >
> > > Can anyone tell me why my Crystal report would be asking for a database
> > > login and password? It runs fine on the report writer's computer and on the
> > > IT Director's computer but anyone else gets a box that asks for a login and
> > > password.
> > >
> > >
> > >
> > > We have created a new subreport in the Priority Dispatch Report and we are
> > > accessing only one table, JOBPROD, and we use the ODBC driver. Any help
> > > would be appreciated.
> > >
> > >
> > >
> > > Beth Rye
> > >
> > > IT Director
> > >
> > > CIGNYS
> > > Email: <mailto:brye@> brye@
> > >
> > >
> > >
> > > ***ITAR NOTICE***
> > >
> > > This e-mail and/or the attached documents may contain technical data within
> > > the definition of the International Traffic in Arms regulations, and are
> > > subject to the export control laws of the US Government. Transfer of this
> > > data by any means to a foreign person, whether in the US or abroad, without
> > > an export license or other approval from the US Department of State, is
> > > prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> > > without written consent of CIGNYS. If you are not the intended recipient or
> > > believe that you may have received this document in error, please notify the
> > > sender and delete this e-mail and any attachments immediately.
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>