Crystal Report connect to different Db

Sorry, I attached my response to the wrong subject.



Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of CharlieSmith
Sent: Friday, February 26, 2010 2:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Report connect to different Db





What nobody else has said, the WIP stays open. Completing a job removes
any outstanding load for operations that are not complete and material
allocations for materials that are not issued complete. Closing the job,
you can no longer post costs against it and allows the WIP to be
processed by the Capture COS/WIP Activity which clears the WIP.

Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mark Wonsil
Sent: Friday, February 26, 2010 10:24 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Crystal Report connect to different Db

Steve wrote:
>
>Try:
>>sysprogress
>>sysprogress

Steve is correct. As a "best-practice" I like to create a new db login
that is READ-ONLY and leaves out tables that people shouldn't be seeing.
Once you create that user/password for the database in question then use
that user/password for your ODBC login (and set the isolation level to
READ-UNCOMMITTED). I'm not sure how many people actually change the
default passwords on their database but it might be a good idea in case
anyone ever compromises your network.

Mark W.

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





[Non-text portions of this message have been removed]
I'm on Vantage 6.1, and want to retrieve data using Crystal Reports from a
Database other than our live DB. How do I make the odbc connection to a
different Db?

thanks,



Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830



This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not
be reviewed, retransmitted, disseminated or otherwise used by persons or
entities other than the intended recipient. If you received this message
in error, please contact the sender and delete the material from your
computer system(s). Thank you.
Just create another datasource in the ODBC control panel that lists the
database you want to go to.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of norm.watkins@...
Sent: Wednesday, February 17, 2010 9:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report connect to different Db





I'm on Vantage 6.1, and want to retrieve data using Crystal Reports from
a
Database other than our live DB. How do I make the odbc connection to a
different Db?

thanks,

Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830

This message contains confidential and privileged information and is
intended only for the individuals to whom it is addressed. It should not

be reviewed, retransmitted, disseminated or otherwise used by persons or

entities other than the intended recipient. If you received this message

in error, please contact the sender and delete the material from your
computer system(s). Thank you.





[Non-text portions of this message have been removed]
Well, if you're just testing you can just change the port number on the ODBC
connection, otherwise, you need to create a new ODBC connection with a
different name and Port number, then change the report to use the new
connection.

ODBC Port numbers can be found with Progress Explorer under:
Databases->[Database
Name]->configurations->defaultConfiguration->ODBCGroup->Properties->Service
Name or Port Number


Bob
Vista 8.00.811b
Progress 10.0b
Windows XP SP3
Windows Server 2003


----- Original Message -----
From: <norm.watkins@...>
To: <vantage@yahoogroups.com>
Sent: Wednesday, February 17, 2010 9:52 AM
Subject: [Vantage] Crystal Report connect to different Db


I'm on Vantage 6.1, and want to retrieve data using Crystal Reports from a
Database other than our live DB. How do I make the odbc connection to a
different Db?

thanks,



Norm Watkins
Engineering Manager

SCHOTT ELECPAC, LLC
740 Industrial Drive
Cary, IL 60013
Phone: 847.639.2307
Fax: 847.639.3830
Hello,
I actually have a question along those lines but involving linking to my Vantage DB itself. I got the connection working fine. I got the report executing fine within Vantage as long as I am on the server. But when I try it from a user PC I get asked for a username and password. However no matter what password I enter nothing happens.

Does anyone have a clue?


Thanks.

--- In vantage@yahoogroups.com, "BobT" <bobt_vantage@...> wrote:
>
> Well, if you're just testing you can just change the port number on the ODBC
> connection, otherwise, you need to create a new ODBC connection with a
> different name and Port number, then change the report to use the new
> connection.
>
> ODBC Port numbers can be found with Progress Explorer under:
> Databases->[Database
> Name]->configurations->defaultConfiguration->ODBCGroup->Properties->Service
> Name or Port Number
>
>
> Bob
> Vista 8.00.811b
> Progress 10.0b
> Windows XP SP3
> Windows Server 2003
>
>
> ----- Original Message -----
> From: <norm.watkins@...>
> To: <vantage@yahoogroups.com>
> Sent: Wednesday, February 17, 2010 9:52 AM
> Subject: [Vantage] Crystal Report connect to different Db
>
>
> I'm on Vantage 6.1, and want to retrieve data using Crystal Reports from a
> Database other than our live DB. How do I make the odbc connection to a
> different Db?
>
> thanks,
>
>
>
> Norm Watkins
> Engineering Manager
>
> SCHOTT ELECPAC, LLC
> 740 Industrial Drive
> Cary, IL 60013
> Phone: 847.639.2307
> Fax: 847.639.3830
>
Try:
sysprogress
sysprogress




________________________________
From: Sebastien <sebastien.jean-felix@...>
To: vantage@yahoogroups.com
Sent: Fri, February 26, 2010 8:36:56 AM
Subject: [Vantage] Re: Crystal Report connect to different Db

Â
Hello,
I actually have a question along those lines but involving linking to my Vantage DB itself. I got the connection working fine. I got the report executing fine within Vantage as long as I am on the server. But when I try it from a user PC I get asked for a username and password. However no matter what password I enter nothing happens.

Does anyone have a clue?

Thanks.

--- In vantage@yahoogroups .com, "BobT" <bobt_vantage@ ...> wrote:
>
> Well, if you're just testing you can just change the port number on the ODBC
> connection, otherwise, you need to create a new ODBC connection with a
> different name and Port number, then change the report to use the new
> connection.
>
> ODBC Port numbers can be found with Progress Explorer under:
> Databases->[ Database
> Name]->configuratio ns->defaultConfi guration- >ODBCGroup- >Properties- >Service
> Name or Port Number
>
>
> Bob
> Vista 8.00.811b
> Progress 10.0b
> Windows XP SP3
> Windows Server 2003
>
>
> ----- Original Message -----
> From: <norm.watkins@ ...>
> To: <vantage@yahoogroups .com>
> Sent: Wednesday, February 17, 2010 9:52 AM
> Subject: [Vantage] Crystal Report connect to different Db
>
>
> I'm on Vantage 6.1, and want to retrieve data using Crystal Reports from a
> Database other than our live DB. How do I make the odbc connection to a
> different Db?
>
> thanks,
>
>
>
> Norm Watkins
> Engineering Manager
>
> SCHOTT ELECPAC, LLC
> 740 Industrial Drive
> Cary, IL 60013
> Phone: 847.639.2307
> Fax: 847.639.3830
>







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



Has the ODBC setup been done on the client computer?



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sebastien
Sent: Friday, February 26, 2010 8:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report connect to different Db





Hello,
I actually have a question along those lines but involving linking to my
Vantage DB itself. I got the connection working fine. I got the report
executing fine within Vantage as long as I am on the server. But when I
try it from a user PC I get asked for a username and password. However
no matter what password I enter nothing happens.

Does anyone have a clue?

Thanks.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"BobT" <bobt_vantage@...> wrote:
>
> Well, if you're just testing you can just change the port number on
the ODBC
> connection, otherwise, you need to create a new ODBC connection with a

> different name and Port number, then change the report to use the new
> connection.
>
> ODBC Port numbers can be found with Progress Explorer under:
> Databases->[Database
>
Name]->configurations->defaultConfiguration->ODBCGroup->Properties->Serv
ice
> Name or Port Number
>
>
> Bob
> Vista 8.00.811b
> Progress 10.0b
> Windows XP SP3
> Windows Server 2003
>
>
> ----- Original Message -----
> From: <norm.watkins@...>
> To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
> Sent: Wednesday, February 17, 2010 9:52 AM
> Subject: [Vantage] Crystal Report connect to different Db
>
>
> I'm on Vantage 6.1, and want to retrieve data using Crystal Reports
from a
> Database other than our live DB. How do I make the odbc connection to
a
> different Db?
>
> thanks,
>
>
>
> Norm Watkins
> Engineering Manager
>
> SCHOTT ELECPAC, LLC
> 740 Industrial Drive
> Cary, IL 60013
> Phone: 847.639.2307
> Fax: 847.639.3830
>





[Non-text portions of this message have been removed]
Steve wrote:
>
>Try:
>>sysprogress
>>sysprogress

Steve is correct. As a "best-practice" I like to create a new db login that is READ-ONLY and leaves out tables that people shouldn't be seeing. Once you create that user/password for the database in question then use that user/password for your ODBC login (and set the isolation level to READ-UNCOMMITTED). I'm not sure how many people actually change the default passwords on their database but it might be a good idea in case anyone ever compromises your network.

Mark W.
Well,
It works!
Thank you very much guys.

And I agree with you Mark. Changing the default password is a good idea. Along with creating the new db login.


Sebastien.-


But when I run the report I still endup with an the same problem
--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> Steve wrote:
> >
> >Try:
> >>sysprogress
> >>sysprogress
>
> Steve is correct. As a "best-practice" I like to create a new db login that is READ-ONLY and leaves out tables that people shouldn't be seeing. Once you create that user/password for the database in question then use that user/password for your ODBC login (and set the isolation level to READ-UNCOMMITTED). I'm not sure how many people actually change the default passwords on their database but it might be a good idea in case anyone ever compromises your network.
>
> Mark W.
>
What nobody else has said, the WIP stays open. Completing a job removes
any outstanding load for operations that are not complete and material
allocations for materials that are not issued complete. Closing the job,
you can no longer post costs against it and allows the WIP to be
processed by the Capture COS/WIP Activity which clears the WIP.



Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Friday, February 26, 2010 10:24 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal Report connect to different Db





Steve wrote:
>
>Try:
>>sysprogress
>>sysprogress

Steve is correct. As a "best-practice" I like to create a new db login
that is READ-ONLY and leaves out tables that people shouldn't be seeing.
Once you create that user/password for the database in question then use
that user/password for your ODBC login (and set the isolation level to
READ-UNCOMMITTED). I'm not sure how many people actually change the
default passwords on their database but it might be a good idea in case
anyone ever compromises your network.

Mark W.





[Non-text portions of this message have been removed]
You meant to reply to a different email, Charlie, didn't you?!







M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of CharlieSmith
Sent: Friday, February 26, 2010 1:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Crystal Report connect to different Db





What nobody else has said, the WIP stays open. Completing a job removes
any outstanding load for operations that are not complete and material
allocations for materials that are not issued complete. Closing the job,
you can no longer post costs against it and allows the WIP to be
processed by the Capture COS/WIP Activity which clears the WIP.

Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/
<http://www.vistaconsultant.com/> > /
www.2WTech.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mark Wonsil
Sent: Friday, February 26, 2010 10:24 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Re: Crystal Report connect to different Db

Steve wrote:
>
>Try:
>>sysprogress
>>sysprogress

Steve is correct. As a "best-practice" I like to create a new db login
that is READ-ONLY and leaves out tables that people shouldn't be seeing.
Once you create that user/password for the database in question then use
that user/password for your ODBC login (and set the isolation level to
READ-UNCOMMITTED). I'm not sure how many people actually change the
default passwords on their database but it might be a good idea in case
anyone ever compromises your network.

Mark W.

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





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