Try going through everything in this document. No problem has to do with
permissions.
http://support.crystaldecisions.com/communityCS/TechnicalPapers/ce8_looping_
logon.pdf
Ted Kitch
ted@...
-----Original Message-----
From: Alan Williams [mailto:awilliams@...]
Sent: Monday, June 10, 2002 1:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Web Component & looping logins
This worked for me from within Access, Excel, and the Crystal Developer
component. Anytime anyone accesses (no pun) a web report however, they have
to logon-including if I run a report from the web server on the web server
itself. (Sigh) I was just hoping...
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, June 10, 2002 9:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Web Component & looping logins
I wish SQL-92 would give you the option of a blank username and password.
I think this would solve the error 990 on Vantage/ODBC reports. I use
Merant 3.5 drivers for that very reason, and it allows blank login so that
you don't have to type them in everytime.
Having said that, there is a workaround given by Epicor to (in certain
situations, of which ODBC in Crystal is NOT one of them if I recall) to
default the login for you in applications like Access). Maybe it will work
for ODBC now, I don't know.
*****************From Tim Ligas at Epicor**************
SQL-92 -- How to get it to not prompt for a password
Summary: ODBC - SQL92 How to save a password in a "File" DSN
Book: Support Solutions
Page: 1732MPS
How to save a password in a File ODBC Data Source that uses MERANT ODBC
driver (SQL-89 or SQL-92).
XA500
XA510
EXPLANATION:
Some customers ask how can they save the user id and password in the
ODBC Data Source in order to connect to the Progress Database from
another application through ODBC (using the MERANT driver) without any
user input.
SOLUTION:
This kb is valid for SQL-89 and SQL-92, it has been tested with ODBC
MERANT driver 3-60 SQL-89 and SQL-92.
You will have to create a File DSN (instead of a System DSN or User
DSN) through the ODBC Data Source Administartor.
Once you have created it and tested the connection you will modify the
file
just created. By default this file is kept in the directory: C:\Program
Files\Common Files\ODBC\Data Sources. Using Notepad or Wordpad edit and
add
(or modify) the following lines:
UID=<userID>
PWD=<password> <-- Must be in lower case
The UID will already be present as 'sysprogress'. Simply open a new line
just beneith it and add PWD=sysprogress
*** NOTE: Once you have done this, you can't modify or save the File DSN
again on this workstation through the ODBC DS Administrator because it
will
overwrite the file that you have modified and you will need to add one or
both of the lines again.
Afterwards if you, for example, use Excel to get the external data from a
Progress Database you will see that it doesn't ask for any user ID or
password.
==============================================
Example of a "SQL-92" File DSN after the modifications:
[ODBC]
Driver=MERANT 3.60 32-BIT Progress SQL92 v9.1A
UID=sysprogress
PWD=sysprogress
HOST=ntserver1
PORT=2550
DB=vantage
permissions.
http://support.crystaldecisions.com/communityCS/TechnicalPapers/ce8_looping_
logon.pdf
Ted Kitch
ted@...
-----Original Message-----
From: Alan Williams [mailto:awilliams@...]
Sent: Monday, June 10, 2002 1:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Web Component & looping logins
This worked for me from within Access, Excel, and the Crystal Developer
component. Anytime anyone accesses (no pun) a web report however, they have
to logon-including if I run a report from the web server on the web server
itself. (Sigh) I was just hoping...
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, June 10, 2002 9:38 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Web Component & looping logins
I wish SQL-92 would give you the option of a blank username and password.
I think this would solve the error 990 on Vantage/ODBC reports. I use
Merant 3.5 drivers for that very reason, and it allows blank login so that
you don't have to type them in everytime.
Having said that, there is a workaround given by Epicor to (in certain
situations, of which ODBC in Crystal is NOT one of them if I recall) to
default the login for you in applications like Access). Maybe it will work
for ODBC now, I don't know.
*****************From Tim Ligas at Epicor**************
SQL-92 -- How to get it to not prompt for a password
Summary: ODBC - SQL92 How to save a password in a "File" DSN
Book: Support Solutions
Page: 1732MPS
How to save a password in a File ODBC Data Source that uses MERANT ODBC
driver (SQL-89 or SQL-92).
XA500
XA510
EXPLANATION:
Some customers ask how can they save the user id and password in the
ODBC Data Source in order to connect to the Progress Database from
another application through ODBC (using the MERANT driver) without any
user input.
SOLUTION:
This kb is valid for SQL-89 and SQL-92, it has been tested with ODBC
MERANT driver 3-60 SQL-89 and SQL-92.
You will have to create a File DSN (instead of a System DSN or User
DSN) through the ODBC Data Source Administartor.
Once you have created it and tested the connection you will modify the
file
just created. By default this file is kept in the directory: C:\Program
Files\Common Files\ODBC\Data Sources. Using Notepad or Wordpad edit and
add
(or modify) the following lines:
UID=<userID>
PWD=<password> <-- Must be in lower case
The UID will already be present as 'sysprogress'. Simply open a new line
just beneith it and add PWD=sysprogress
*** NOTE: Once you have done this, you can't modify or save the File DSN
again on this workstation through the ODBC DS Administrator because it
will
overwrite the file that you have modified and you will need to add one or
both of the lines again.
Afterwards if you, for example, use Excel to get the external data from a
Progress Database you will see that it doesn't ask for any user ID or
password.
==============================================
Example of a "SQL-92" File DSN after the modifications:
[ODBC]
Driver=MERANT 3.60 32-BIT Progress SQL92 v9.1A
UID=sysprogress
PWD=sysprogress
HOST=ntserver1
PORT=2550
DB=vantage
----- Original Message -----
From: Dan Shallbetter
To: 'vantage@yahoogroups.com'
Sent: Monday, June 10, 2002 9:59 AM
Subject: RE: [Vantage] Crystal Web Component & looping logins
Good morning and thanks for the help in geting my web component up and
running. Next question. How can I get the web viewer to match format of
the
native report I see on my development machine. We use I.E 5.0 I think
the
default viewer is the Active X viewer. Also is there a way to provide
default values for the logon box for ODBC reports?
Thanks
Dan Shallbetter
-----Original Message-----
From: Alan Williams [mailto:awilliams@...]
Sent: Monday, June 10, 2002 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Web Component & looping logins
I'm not using the dos command since we went to 5.1, but here's the
content
of the batch file I used in 4.0:
-------------Begin Batch File---------------------------
cls
cd "c:\Program Files\Seagate Software\WCS\"
pageserver.exe -cache -deletecache -console
-------------End Batch File-----------------------------
I put a shortcut in my startup folder to this, set to run minimized.
This was run on a W2k machine, so if you're running on NT, you might
have to
change the "Program Files\Seagate Software\" to "Progra~1\Seagat~1\"
without the quotes.
Hope this helps,
Alan
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, June 07, 2002 9:43 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Web Component & looping logins
Dan,
You are on the right track. Try using a REAL Admin user for the
Service, rather than the CRUSER that crystal recommends. That worked
for
me.
As an alternative (workaround)...There is a DOS COMMAND you can use (I
think you have to turn the services off) that allows Crystal to run in
your
task bar. It was in some threads here over a year ago. Does anyone
still
have/use Crystal Web their task bar????
Troy Funte
Liberty Electronics
----- Original Message -----
From: Dan Shallbetter
To: 'vantage@yahoogroups.com'
Sent: Friday, June 07, 2002 2:45 PM
Subject: RE: [Vantage] Crystal Web Component & looping logins
Adam
Sopped the service cahnge the user to admin restatred the service
same
results. I can see sample reports usung I.E is the ODBC reports that
are
the
problem.
Dan
-----Original Message-----
From: Adam Ellis [mailto:adame@...]
Sent: Friday, June 07, 2002 1:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Web Component & looping logins
I believe I did the same thing when I set up my web component server
(creating the Crwebuser and such) and ran into the same problem. It
has
been a while, but I think that switching the user the service was
running
under to Administrator did the trick. Crwebuser may need to have
Log On
Locally rights? Regardless, try switching it to Administrator and
see
if it
works.
AE
-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Friday, June 07, 2002 2:13 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Web Component & looping logins
Adam the Crystal install doc had me create a user Crwebuser and make
him
a
member of the the admin group. This is the user they said to use for
the
web
component service. Is this incorrect?
Thanks
Dan
-----Original Message-----
From: Adam Ellis [mailto:adame@...]
Sent: Friday, June 07, 2002 1:01 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Web Component & looping logins
Dan,
Make sure the web component server is running as user
'Administrator'
under
NT Services.
AE
-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Friday, June 07, 2002 2:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Web Component & looping logins
Today's fun and games is setting up the web component in Crystal
8.0. I
am
getting a looping login when I try refreshing a O.D.B.C database
report.
I
think I have followed all the steps listed in the Crystal K.B.
c2009197
I
am a little confused by the step pertaining to NTFS file
permissions. We
are
running S.B.S 4.5 loaded on a NTFS partition. Has anybody already
discovered the correct fix for this problem. It's Friday and any
help
would
be greatly appreciated.
Dan Shallbetter
States Electric Mfg.
[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>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[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>
Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]