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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR8 ASP - Logon Syntax

Status
Not open for further replies.
Sep 13, 2001
11
US
Trying to find correct syntax for using RDC via ASP to run reports via Web.

I have looked at the Crystal Samples, the Seagate KnowledgeBase, and now here with no luck at finding something that would help - so I post.

Here is my code - with the "suggested" modifications per Seagate KB article C2006178 - the nice window opens up the Seagate Icon spins for a short time and then - nuthin. The report works fine in Ver8 design but will not open via the Web. Also, I am running Crystal 7 on my production box using the CRPE and it runs just fine. Any thoughts on this appreciated - here is my code:

'--> CREATE THE APPLICATION OBJECT
If IsObject(oApp) then
Set oApp = nothing
End if
Set oApp = Server.CreateObject("CrystalRuntime.Application")
if ((Err <> 0) or (not IsObject(oApp))) then
set oApp = nothing
response.redirect &quot;intro.htm&quot;
end if


If IsObject(oRpt) then
Set oRpt = nothing
End if
Set oRpt = oApp.OpenReport(Path & reportname, 1)
if ((Err <> 0) or (not IsObject(oRpt))) then
set oApp = nothing
set oRpt = nothing
response.redirect &quot;intro.htm&quot;
end if

oRpt.MorePrintEngineErrorMessages = False
oRpt.EnableParameterPrompting = False

'--> SET THE LOCATION
oApp.LogonServer &quot;p2sodbc.dll&quot;, CStr(DSN2), CStr(DatabaseNam), Cstr(uid), Cstr(pword)

set crtable = oRpt.Database.Tables(1)
crtable.SetLogonInfo CStr(DSN2), CStr(DatabaseNam), Cstr(uid), Cstr(pword)

 
Hi:

A long shot, but check the browser version number on the PC where you are trying to run the WEB based version.

Good luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top