Does the Progress license let you install it on another Server?
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 9:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: ODBC calls from an IIS web server [SMC WIRE
FABRICATORS]
Paul,
So to be clear... You use the Vantage CD to install Progress on the Web
Server computer? Do you use the default settings... are there any changes
from a typical server install?
Also, what exactly does doing this help resolve with Crystal Web Component?
Is it mainly ADO connections that are the problem?
Troy Funte
Liberty Electronics
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 9:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: ODBC calls from an IIS web server [SMC WIRE
FABRICATORS]
Paul,
So to be clear... You use the Vantage CD to install Progress on the Web
Server computer? Do you use the default settings... are there any changes
from a typical server install?
Also, what exactly does doing this help resolve with Crystal Web Component?
Is it mainly ADO connections that are the problem?
Troy Funte
Liberty Electronics
----- Original Message -----
From: concentriccontrols
To: vantage@yahoogroups.com
Sent: Wednesday, November 27, 2002 7:42 AM
Subject: [Vantage] Re: ODBC calls from an IIS web server
Chris,
I think I have found a solution that doesn't force you to change the
security settings. By installing a local copy of Progress on the web
server rather than using the progress network client I've got our IIS
web reports working fine using the default anonymous access settings.
Paul.
--- In vantage@y..., "Gitzlaff, Christopher" <cgitzlaff@m...> wrote:
> Paul,
>
> I have a workaround, but I'm still searching for a good solution to
this
> problem. The only way I've been able to get it to work (after many
hours of
> head pounding), is to create an administrator account (try yours for
> starters) and use that for the Directory Security account for
Anonymous
> access. That doesn't even quite do it. The account you create has
to be
> logged on locally to the IIS server before the connection will
work. I just
> lock the screen on that computer. It is a permissions issue. I
believe an
> administrator has to be logged on to get access to a database on
another
> server (at least for Progress).
>
> Hope this helps, and if you find a better way, please let me know.
>
> Chris
>
>
> Christopher Gitzlaff
> Manager - Information Systems & Technology
> Major Industries, Inc.
> Phone: 715-842-4616
> Fax: 715-848-3336
>
>
>
> -----Original Message-----
> From: Paul Oliver [mailto:p.oliver@c...]
> Sent: Tuesday, November 12, 2002 6:03 AM
> To: vantage@y...
> Subject: [Vantage] ODBC calls from an IIS web server
>
>
> We are in the process of setting up an internal web server (IIS
runing ASP
> scripts) to run simple web reports from our Vantage database. This
is a
> technology we have used extensively in the past for producing simple
> end-user information from databases however I've run into a
problem... When
> I try to create an ADODB connection to Vantage from an ASP script I
get this
> error:
>
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> Specified driver could not be loaded due to system error 5 (MERANT
3.60
> 32-BIT Progress SQL92 v9.1D). "
>
> I know that the ODBC drivers are working on the server as I have
tested the
> connections with both Visual Basic code and VB Script (using the
Windows
> Scripting Host), in both cases the ADODB connections work correctly.
>
> I believe that system error 5 indicates that the server's IUSR
account
> doesn't have
> the correct permissions on certain files to be able to launch the
driver?
> Can anyone point me in the direction of the security permissions
that need
> changing to get this to work?
>
> Paul Oliver
> Concentric Controls Ltd.
[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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/