Conncecting to ODBC through ASP - ReCrystallize - Vantage 6.1

Yahoo Archive
1
Hi
When a Vantage user calls a crystal report, Vantage creates small sets
of data that the crystal report uses together with the *.rpt file to
generate the report. the *.RPt file may also call extra data from the
Vantage DB directly.

i can't see how you Client side S/W is going to get data from the
*.RPT uses unless vantage has generated it, unless you are only trying
to create total stand alone reports connecting directly to the RAW
Vantage DB.

Sorry this does not help, hopefully i have not miss read the situation.

Dave
2
Since my Crystal Enterprise Server is dying and I can't get the new
one working I'm trying a different application to distribute my
Crystal Reports.

There is a product called ReCrystallize that has a "Wizard" that you
run each rpt through. It creates the ASP code to call the report
through the Web Server.

I'm having problems with this connecting to my ODBC connection.

If I try a direct connection by trying to use database info in a
parameter lookup I get the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 5 (MERANT
3.60 32-BIT Progress SQL92 v9.1D).
/accounting/Labor Edit by Office Dept-parameters.asp, line 38

If I let the code try to open the DB through the embedded Crystal
Viewer I get the following.

ReCrystallize Warning: Unable to connect to data source using the
following information.

Server/ODBC data source:Progress91D
Database/Table:Customer
User Name:ODBCUSER
Please Verify the database user passowrd in this ASP file.

I get that once for each table in the report.

In the wizard it has a step that asks you for the ODBC logon
credentials and pulls most of it from the Rpt you are working with.
I just add the password.

Along with this error I get another dialog:

CRAXDRT Error Occured on Server. -2147192184 : Server has not yet
been opened.

Has anyone used ReCrystallize to distribute reports?

Has anyone used ASP code to connect to the DB?

I have support with ReCrystallize but according to them, they've
never had a customer try to use it with a Progress DB before.

Keep in mind I know very little about ASP.

Thanks,

Brian Stenglein
3
Brian...this is way out on a limb because I've not used ReCrystallize or very much ODBC from Crystal for that matter but....does ReCrystallize auto-startup any services that run in the background? If so with other applications I have occasionally had issues with the logon credentials for services and needed to give them an Administrator login. A long shot but easy to experiment with just incase.
-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian Stenglein
Sent: Wednesday, May 14, 2008 8:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Conncecting to ODBC through ASP - ReCrystallize - Vantage 6.1


Since my Crystal Enterprise Server is dying and I can't get the new
one working I'm trying a different application to distribute my
Crystal Reports.

There is a product called ReCrystallize that has a "Wizard" that you
run each rpt through. It creates the ASP code to call the report
through the Web Server.

I'm having problems with this connecting to my ODBC connection.

If I try a direct connection by trying to use database info in a
parameter lookup I get the following error.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 5 (MERANT
3.60 32-BIT Progress SQL92 v9.1D).
/accounting/Labor Edit by Office Dept-parameters.asp, line 38

If I let the code try to open the DB through the embedded Crystal
Viewer I get the following.

ReCrystallize Warning: Unable to connect to data source using the
following information.

Server/ODBC data source:Progress91D
Database/Table:Customer
User Name:ODBCUSER
Please Verify the database user passowrd in this ASP file.

I get that once for each table in the report.

In the wizard it has a step that asks you for the ODBC logon
credentials and pulls most of it from the Rpt you are working with.
I just add the password.

Along with this error I get another dialog:

CRAXDRT Error Occured on Server. -2147192184 : Server has not yet
been opened.

Has anyone used ReCrystallize to distribute reports?

Has anyone used ASP code to connect to the DB?

I have support with ReCrystallize but according to them, they've
never had a customer try to use it with a Progress DB before.

Keep in mind I know very little about ASP.

Thanks,

Brian Stenglein





[Non-text portions of this message have been removed]
4
Thanks Todd, but ReCrystallize isn't server side software. It is a
tool installed on my workstation that writes ASP code based on the
selections I choose in the Wizard. As long as all of the files exist
on in the Virtual Directory on the web server it is supposed to work
by calling the ASP file it creates in a web URL.

Brian


--- In vantage@yahoogroups.com, Todd Caughey <caugheyt@...> wrote:
>
> Brian...this is way out on a limb because I've not used
ReCrystallize or very much ODBC from Crystal for that matter
but....does ReCrystallize auto-startup any services that run in the
background? If so with other applications I have occasionally had
issues with the logon credentials for services and needed to give
them an Administrator login. A long shot but easy to experiment with
just incase.
> -Todd C.
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Brian Stenglein
> Sent: Wednesday, May 14, 2008 8:16 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Conncecting to ODBC through ASP - ReCrystallize -
Vantage 6.1
>
>
> Since my Crystal Enterprise Server is dying and I can't get the new
> one working I'm trying a different application to distribute my
> Crystal Reports.
>
> There is a product called ReCrystallize that has a "Wizard" that you
> run each rpt through. It creates the ASP code to call the report
> through the Web Server.
>
> I'm having problems with this connecting to my ODBC connection.
>
> If I try a direct connection by trying to use database info in a
> parameter lookup I get the following error.
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> Specified driver could not be loaded due to system error 5 (MERANT
> 3.60 32-BIT Progress SQL92 v9.1D).
> /accounting/Labor Edit by Office Dept-parameters.asp, line 38
>
> If I let the code try to open the DB through the embedded Crystal
> Viewer I get the following.
>
> ReCrystallize Warning: Unable to connect to data source using the
> following information.
>
> Server/ODBC data source:Progress91D
> Database/Table:Customer
> User Name:ODBCUSER
> Please Verify the database user passowrd in this ASP file.
>
> I get that once for each table in the report.
>
> In the wizard it has a step that asks you for the ODBC logon
> credentials and pulls most of it from the Rpt you are working with.
> I just add the password.
>
> Along with this error I get another dialog:
>
> CRAXDRT Error Occured on Server. -2147192184 : Server has not yet
> been opened.
>
> Has anyone used ReCrystallize to distribute reports?
>
> Has anyone used ASP code to connect to the DB?
>
> I have support with ReCrystallize but according to them, they've
> never had a customer try to use it with a Progress DB before.
>
> Keep in mind I know very little about ASP.
>
> Thanks,
>
> Brian Stenglein
>
>
>
>
>
> [Non-text portions of this message have been removed]
>