Alan,
I'm not sure about the Web Component (Crystal 8), but in Crystal Enterprise (CR 8.5) you can use the Report Wizard in CE to embed the login, including username and password, in the Report itself. You have to go through the steps for each report you design, however (although you can do them in a batch, I think).
Troy
I'm not sure about the Web Component (Crystal 8), but in Crystal Enterprise (CR 8.5) you can use the Report Wizard in CE to embed the login, including username and password, in the Report itself. You have to go through the steps for each report you design, however (although you can do them in a batch, I think).
Troy
----- Original Message -----
From: Alan Williams
To: vantage@Yahoogroups. com
Sent: Friday, November 30, 2001 9:43 AM
Subject: [Vantage] Re: Web Server and 3.6 sql92 drivers
Actually, I have that working for everything, including Crystal, on the
report server, but it only works in the report designer. Every time a user
tries to access a report from the web server, they get the user/password
request. The reports still work (after some tweaking), but it's annoying
that they have to login to each report.
Thanx,
Alan
--------------------Original message--------------------------------
Message: 14
Date: Thu, 29 Nov 2001 20:11:25 -0500
From: "Troy Funte" <tfunte@...>
Subject: Re: Web Server and 3.6 sql92 drivers
There is a way to do it for Access and Excel, but not in Crystal. Here are
the instructions...
Troy Funte
Liberty Electronics
--------------Begin of Instructions ------------------
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 Administrator.
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 beneath 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
-------------------------End of Instructions-----------------------------
----- Original Message -----
From: Alan Williams
To: vantage@Yahoogroups. com
Sent: Thursday, November 29, 2001 7:35 PM
Subject: [Vantage] Web Server and 3.6 sql92 drivers
Hi, all.
Anybody have any luck getting the Crystal Web Server to NOT ask for
a
password using the 3.6 drivers? (5.10.107--jumped from 4.00.904 last
Friday.
yeesh)
Thanx,
Alan
Thanx,
Alan
Yahoo! Groups Sponsor
ADVERTISEMENT
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]