Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Enterprise 8.0 + IIS 4.0 + SQL Designer query problem :-(

Status
Not open for further replies.

mnemonik23

Programmer
Feb 24, 2002
3
US
Hi all,

The "old" Cannot Open SQL Server error... But very ineresting:

On server:
----------
NT Server 4.0
Crystal Enterprise 8.0
IIS 4.0
Database : Informix 8 on other server.

Report:
-------
with external qurey implemented to SQL Designer

I already updated P2SODBC.DLL and patch for changing NT permission... It doesn't help.

It happened ONLY with access through the web server if report has external query(SQL Designer). All other reports are working perfect.

Another interesting thing:
I "created" another NT Server with the same componets + Crystal Reports 8.5. Result was the same - "Cannot Open SQL Server error".
But after I've updated P2SODBC.DLL - report started work !
On support.crystaldecisions.com I saw about this only for Reports 8.0 version. They are saying that this problem already fixed in 8.5 but looks like not for Enterprise...

So, Crystal Enterprise 8.0 + external query + web access doesn't work.

How to resolve this problem ?
My client doesn't have a Crystal Reports 8.5 and will not buy it. He has only Crystal Enterprise 8.0...

Thanks for any help !
Axel,
mnemonik23@yahoo.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top