Its because they loose Maintenance $$$$ for those users who get their support from just this group.
I think its ok to post solutions, just not copy and paste it from Epicor Documents. I know its a big no no to share files that Epicor produced such as patches and programs.
-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Wednesday, November 03, 2004 3:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report ODBC Login
I had no idea.... I've seen other similar post, so hopefully Epicor will
forgive me this time.
-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: Wednesday, November 03, 2004 2:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report ODBC Login
A word of warning....
I would be careful sharing copies of Epicor documents. Epicor WILL come
after you. Several users on this list have gotten nasty grams from Epicor
Attorneys.
Jeremy
-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Wednesday, November 03, 2004 3:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report ODBC Login
See if this information helps
Paul L.
AnswerBook #: 3478MPS Product: Vantage
Date Added: 12/12/2003 Version:
Date Changed: 4/27/2004 Module: ODBC
_____
Summary:
ODBC How to setup a file DSN for ODBC for 6.0 and 6.1
Details:
This is as designed and required to meet the SQL-92 standard. However some
administrators would liketo hide the prompt for the password and supply that
behind the scenes. This does reduce the security, but can be done by using a
File DSN.
How to create a file DSN for 6.0 or 6.1
Go to Control Panel -> Admin Tools -> Data Source ODBC
Go to the File DSN tab, Click Add
Select MERANT 3.60 32-BIT Progress SQL92 v9.D
Give it a name: e.g. Mfgsys60 or Mfgsys61
Then
Host Name: < name of database computer running vantage>
Port Number: < port used for the group under the progress explorer tool
supporting SQL users e.g. 6050 or 6150
Database Name: mfgsys
User ID: sysprogress
password: sysprogress
click OK to finish creating the file DSN
Once you have created it, you will need to modify the file. By default this
file is kept in the directory: C:\Program Files\Common Files\ODBC\Data
Sources.
Open the file using Notepad and add the following line:
PWD=<password> <-- THIS IS CASE SENSITIVE, so you will likely use lowercase
BEFORE EDIT
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D
UID=SYSPROGRESS
DB=mfgsys
PORT=6050
HOST=mntech
AFTER EDIT
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D
UID=SYSPROGRESS
PWD=sysprogress
DB=mfgsys
PORT=6050
HOST=mntech
The UID will already be present as 'sysprogress'. Simply open a new line
just beneath it and add 'PWD=sysprogress'
then save the file
To test the file create a quick Crystal report using the Report Expert and
Standard format, then choose Database ODBC then choose your
file e.g. 'Mfgsys61.dsn' it should connect without asking you to supply the
password.
PLEASE NOTE: Crystal Decisions does not support using a file DSN in compiled
reports.
This has also not been tested with MSAccess.
-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Wednesday, November 03, 2004 2:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report ODBC Login
Currently we create a crystal report in version 8.5 using the Report
Compiler. We save the "compiled" report to the server, and users can
run the report anytime without Crystal or being in Vantage. Problem is
every time you run the report and want to refresh the data; you have to
type in the ODBC password. Is there a way to automatically run the ODBC
password when you first open the report?
Jim Horton
Jim.horton@...
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Sponsor
<
http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
http://clk. <http://clk.>
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099512849824083>
<
http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
http://clk. <http://clk.>
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099512849824083>
Get unlimited calls to
U.S./Canada
< http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=10995128
<
http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
< http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=129fgu2qh/M=281955.5530326.6602771.3001176/D=gr
oups/S=1705007183:HM/EXP=1099600858/A=2343726/R=0/SIG=12iln5t2h/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099514458981340>
<http://us.ard.yahoo.com/SIG=129fgu2qh/M=281955.5530326.6602771.3001176/D=gr
oups/S=1705007183:HM/EXP=1099600858/A=2343726/R=1/SIG=12iln5t2h/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099514458981340>
Get unlimited calls to
U.S./Canada
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=10995144
58981340>
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=
:HM/A=2343726/rand=965495699>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
I think its ok to post solutions, just not copy and paste it from Epicor Documents. I know its a big no no to share files that Epicor produced such as patches and programs.
-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Wednesday, November 03, 2004 3:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report ODBC Login
I had no idea.... I've seen other similar post, so hopefully Epicor will
forgive me this time.
-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: Wednesday, November 03, 2004 2:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report ODBC Login
A word of warning....
I would be careful sharing copies of Epicor documents. Epicor WILL come
after you. Several users on this list have gotten nasty grams from Epicor
Attorneys.
Jeremy
-----Original Message-----
From: Paul Lipham [mailto:pml@...]
Sent: Wednesday, November 03, 2004 3:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report ODBC Login
See if this information helps
Paul L.
AnswerBook #: 3478MPS Product: Vantage
Date Added: 12/12/2003 Version:
Date Changed: 4/27/2004 Module: ODBC
_____
Summary:
ODBC How to setup a file DSN for ODBC for 6.0 and 6.1
Details:
This is as designed and required to meet the SQL-92 standard. However some
administrators would liketo hide the prompt for the password and supply that
behind the scenes. This does reduce the security, but can be done by using a
File DSN.
How to create a file DSN for 6.0 or 6.1
Go to Control Panel -> Admin Tools -> Data Source ODBC
Go to the File DSN tab, Click Add
Select MERANT 3.60 32-BIT Progress SQL92 v9.D
Give it a name: e.g. Mfgsys60 or Mfgsys61
Then
Host Name: < name of database computer running vantage>
Port Number: < port used for the group under the progress explorer tool
supporting SQL users e.g. 6050 or 6150
Database Name: mfgsys
User ID: sysprogress
password: sysprogress
click OK to finish creating the file DSN
Once you have created it, you will need to modify the file. By default this
file is kept in the directory: C:\Program Files\Common Files\ODBC\Data
Sources.
Open the file using Notepad and add the following line:
PWD=<password> <-- THIS IS CASE SENSITIVE, so you will likely use lowercase
BEFORE EDIT
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D
UID=SYSPROGRESS
DB=mfgsys
PORT=6050
HOST=mntech
AFTER EDIT
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D
UID=SYSPROGRESS
PWD=sysprogress
DB=mfgsys
PORT=6050
HOST=mntech
The UID will already be present as 'sysprogress'. Simply open a new line
just beneath it and add 'PWD=sysprogress'
then save the file
To test the file create a quick Crystal report using the Report Expert and
Standard format, then choose Database ODBC then choose your
file e.g. 'Mfgsys61.dsn' it should connect without asking you to supply the
password.
PLEASE NOTE: Crystal Decisions does not support using a file DSN in compiled
reports.
This has also not been tested with MSAccess.
-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Wednesday, November 03, 2004 2:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report ODBC Login
Currently we create a crystal report in version 8.5 using the Report
Compiler. We save the "compiled" report to the server, and users can
run the report anytime without Crystal or being in Vantage. Problem is
every time you run the report and want to refresh the data; you have to
type in the ODBC password. Is there a way to automatically run the ODBC
password when you first open the report?
Jim Horton
Jim.horton@...
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Sponsor
<
http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
>oups/S=1705007183:HM/EXP=1099599249/A=2343726/R=0/SIG=12irvshq1/*
http://clk. <http://clk.>
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099512849824083>
<
http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129g88j77/M=281955.5530326.6602771.3001176/D=gr
>oups/S=1705007183:HM/EXP=1099599249/A=2343726/R=1/SIG=12irvshq1/*
http://clk. <http://clk.>
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099512849824083>
Get unlimited calls to
U.S./Canada
< http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=10995128
> &time=1099512849824083>
<
http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=
>:HM/A=2343726/rand=947351020>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
< http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=129fgu2qh/M=281955.5530326.6602771.3001176/D=gr
oups/S=1705007183:HM/EXP=1099600858/A=2343726/R=0/SIG=12iln5t2h/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099514458981340>
<http://us.ard.yahoo.com/SIG=129fgu2qh/M=281955.5530326.6602771.3001176/D=gr
oups/S=1705007183:HM/EXP=1099600858/A=2343726/R=1/SIG=12iln5t2h/*http://clk.
atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1099514458981340>
Get unlimited calls to
U.S./Canada
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=10995144
58981340>
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=
:HM/A=2343726/rand=965495699>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links