Home > Crystal Reports > Crystal Reports An Error Has Occurred On The Server In Attempting To Access The Data Source

Crystal Reports An Error Has Occurred On The Server In Attempting To Access The Data Source

Thanks in advance Faq Reply With Quote October 20th, 2003,09:27 AM #6 No Profile Picture Keithb View Profile View Forum Posts  Junior Member Devshed Newbie (0 - 499 posts) It was worth it though if I could have give you 2. OutOfLicenseException Inherited from EngineException. Once the application object is created in 'memory for this session, you can run many reports without having to recreate it. ' CREATE THE REPORT OBJECT ' 'The navigate here

RobJust my $.02. So you can use the SmartViewer*.asp files to instantiate 'the smart viewer that you wish to send to the browser. I have an incident with Crystal Reports and they have suggested a few things too. For example, a string value passed to a numeric parameter will stop the report from running. https://forums.digitalpoint.com/threads/crystal-report-is-not-able-to-open-in-asp-page.578782/

Does the issue come up with any non-crystal reports? It was a DB that the name changes on when the report is run. ExportException Inherited from EngineException. That way if your ASP 'application freezes you will be able to view the error dialog (if one is displayed). '==================================================================================== ' Retrieve the Records and Create the "Page on Demand"

RE: Server has Not Yet Been Opened LV (Programmer) 26 Mar 03 13:55 Could you please do the following:1. I think the computer viewing the report thinks that it already has the viewer installed, so doesn't get prompted to download a new one. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Handling Exceptions for the Crystal Report Engine Visual Studio .NET 2003 When you run Crystal Reports through your application, there may be times when the Crystal Report Engine causes an exception.

Thanks Attached Images scr.jpg (29.6 KB, 702 views) Faq Reply With Quote November 12th, 2003,11:58 PM #13 No Profile Picture thelostone View Profile View Forum Posts  Junior Member Devshed Read that in the Reports.asp page. I have had it working earlier on a diiferent project. I am changing the tables at runtime but that should not affect reporting from a recordset, should it?

InternalException Inherited from EngineException. RE: Server has Not Yet Been Opened StevenK (Programmer) 21 Mar 03 12:57 Does your client machine have the required database access dll's ?I'm sure this message (Server has not yet About Us Contact us Privacy Policy Terms of use Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find Set the report up to use an "active file" define the field/report contects such as Field1String123 Field2Number Field3datetime you'll need to redefine your report source and fields Then in one asp,

RE: Server has Not Yet Been Opened LV (Programmer) 31 Mar 03 12:31 Rob,Going back to your original solution, I didn't see in the code that you're changing table names. Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts hi ros, thanks 4 reply... In the catch, you can reference one of the Crystal exception classes. What could be the reason?

Instead of changing tables using SetLogonInfo (your original solution, using the native SQL Server driver), you are now reporting off of an ADO recordset(active data driver, using a pre-structured ttx filew), http://comscity.net/crystal-reports/crystal-reports-error-occurred-reading-records.html I can't find the pdsmon.dll that it's supposed to be using?I'm going to give ya a star just for hangin in like you have. I haven't ever used one, but I'm sure I can figure it out. However that functionality is inherent in the Crystal 'Reports automation server and is beyond the scope of this demonstration app. ' 'We have chosen to leverage the server side include functionality

Compatibility: Windows 7, 8, Vista, XP Download Size: 6MB Requirements: 300 MHz Processor, 256 MB Ram, 22 MB HDD Limitations: This download is a free evaluation version. I tried "Set Table2 = "X123OnrVsl" but it won't work like that. "Object Required" Which report do you think I should be using?Thanks again and again LV. Some of the advantages of handling the exceptions programmatically are: You can customize the error message displayed to the user. his comment is here I looked again, and I was.

RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 3 Apr 03 19:35 I'm sorry LV. You can write an event to your application's log file. We've got a test environment set up now with the latest stable build, and are having fun with it. __________________ Drew Bell ____________________________ Workflow Consulting, Llc [email protected] DrewBell View Public Profile

The system returned: (22) Invalid argument The remote host or network may be down.

I donot see any difference in the code. If you have installed Crystal there is lots of ASP sample code (..at least in CR 7, there is). That way if your ASP 'application freezes you will be able to view the error dialog (if one is displayed). '================================================= =================================== ' Retrieve the Records and Create the "Page on RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 27 Mar 03 15:55 Thanks LV.

If an error is reported on the web server, the ' print engine will stop processing and you application will "hang". ' '2. If the report is passed to the viewer, and then the error occurs, then the viewer will catch the exception. Check your user name and password."); } catch (DataSourceException* engEx) { MessageBox::Show("An error has occurred while connecting to the database."); } catch (EngineException* engEx) { MessageBox::Show (engEx->Message); } }; [VJ#] Copy weblink Thanks.

Your cache administrator is webmaster. Try changing the line that defines the viewer, to use the SmartViewerJava. Dev Shed Forums Navigation Forums Tools Newsletter Signup Articles Help Devshed Network Developer Shed ASP Free Dev Shed Dev Articles Dev Hardware Tutorialized SEO Chat Scripts Codewalkers Web Hosters Dev Mechanic You may choose to let the Crystal Report Engine handle the exception itself, and display its own error message, or you may decide to handle the exception yourself.

All rights reserved Home Forums Articles Badges Privacy Policy Support Sitemap Newsletter Signup Free Web Developer Tools

How to fix Crystal Reports An Error Has Occurred On The Server View our list of code downloads. RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 25 Mar 03 11:49 Oh, I use a native connection and I'm pretty sure that's the way I did it in After I added the code you supplied, I went through the page and removed the last 2 include files, MoreRequiredSteps.asp and SmartVeiwerActiveX.asp so I could check what you suggested.

I don't have any Response.End in my files.