×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

"Server yet not opened" error with PDSSQL.DLL ....Help me....

"Server yet not opened" error with PDSSQL.DLL ....Help me....

"Server yet not opened" error with PDSSQL.DLL ....Help me....

(OP)
Hi All,
I am new to this forum and new to Crystal Reports too. I am facing problems in RPT to PDF conversion from ASP.

The project for which this conversion is to be provided has MS SQL Server 2000 backend and Crystal Reports 7.0 as reporting tool.

I found that there is no direct conversion possible with Crystal 7.0 runtime (tried with converting to XLS and RTF inbetween) from RPT to PDF. There is direct conversion possible with Crystal 8.5 runtime. So I tested it.

The original 7.0 reports have database driver as "PDSSQL.DLL" and when I tried either LogonServer or SetLogonInfo methods in ASP, it is getting me error "Server has not been opened yet."

When I prepared new report with 8.5 and set database driver to "PDSOLEDB.DLL", it is working fine and fluent. So it comes out like I have to create reports once again. Because when I upgrade 7.0 reports to 8.5 and set database driver to "PDSOLEDB.DLL", it is not working at all (even crystal report application is hanging when I refresh the upgraded report).

Here is the code I am using for it (I just got it from samples)
_______________________________________
<%
reportname = "VendorSchedule85.rpt"
<!--#include file="VendorSchedule.inc"-->

<%
Set session("oApp") = Server.CreateObject("CrystalRuntime.Application")

path = "D:\"
          
If IsObject(session("oRpt")) then
    Set session("oRpt") = nothing
End if

session("oApp").LogOnServer "pdssql.dll","server","db","sa",""

Set session("oRpt") = session("oApp").OpenReport(path & reportname, 1)

<<Setlogoninfo if not using logon server........>>>

session("oRpt").DiscardSavedData

<<making and giving report object query.......>>>>
session("oRpt").SQLQueryString = cstr(strSt)


session("oRpt").MorePrintEngineErrorMessages = False
session("oRpt").EnableParameterPrompting = False

session("filename") ="malay.pdf"
session("filetype") = "Adobe PDF"

Set session("ExportOptions") = Session("oRpt").ExportOptions

session("ExportFileName") =  "c:\" + cstr(session("filename"))


Select Case cstr(session("filetype"))
    Case "Adobe PDF" ExportType = 31
End Select

If (cint(ExportType) <> 24) then
    session("ExportOptions").DiskFileName = session("ExportFileName")
Else
    session("ExportOptions").HTMLFileName = session("ExportFileName")
End If

If cint(ExportType) = 10 then
    session("ExportOptions").NumberofLinesPerPage = 50
End if

session("ExportOptions").FormatType = cint(ExportType)
session("ExportOptions").DestinationType = 1

Session("oRpt").Export False

<end of sample code.......>
_______________________________________

Please guide me. I think that there is problem with the dll only (because in other cases it is working without logonserver method).

Thanks,
Malay M. Thakershi

RE: "Server yet not opened" error with PDSSQL.DLL ....Help me....

Never use the PD*.DLL's.  Use the P2*.DLLs.  The PD* DLLs are the 16-bit DLLs.

RE: "Server yet not opened" error with PDSSQL.DLL ....Help me....

(OP)
Hi Balves,

I know this, but still my question is up. Same thing is occurring with p2*.dll. Please get into this once more and try to pull me out of the pit.

One more thing. After I installed Crystal Report 8.5, still in the Convert Database Driver option I am not getting names of the p2*.dll. It is just showing the 16 bit dlls. What could be the reason? May be because I upgraded from 16 bit Crystal report to 32 bit (I didn't installed the fresh one, may be at that I did not had it). But that question is there, I am trying my best to get out myselt, but any type of help is going to help.

Anyway, thanks for your quick response.

Thanks Again,
Malay M. Thakershi

RE: "Server yet not opened" error with PDSSQL.DLL ....Help me....

The fact that the Convert Driver window shows the PD* names is a display bug on the window.  It's documented on the Crystal web site. Ignore it.

I've stuck with the ODBC driver, p2sodbc.dll, because it gives the least amount of problems.

RE: "Server yet not opened" error with PDSSQL.DLL ....Help me....

(OP)
Hi Balves,

Thanks for your suggestion. But p2sodbc.dll is more problematic when I have stored procedures in the query for that report. You know what? If that stored procedure contains select statements in the if or while loops the report builder won't allow to refer to those stored procedures. Hard luck for me is that, I have all the SPs running like that in the queries so if I change it to p2odbc.dll, I have to update at least 30 dirty SPs which are running fine till now and the project is on verge of release.

One more thing. I have to make DSN on the server for p2ODBC.dll to work.

If I could achieve the goal with p2odbc without facing this problems please tell me. If you are using p2odbc.dll how you are resolving the SPs with the features I mentioned above.

I am dragging you more and more, ain't I? Again post reply when you are ready with it. Right?

Thanks,
Malay M. Thakershi

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close