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

Can't figure out, why it is not working on this one. 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. RE: Server has Not Yet Been Opened LV (Programmer) 31 Mar 03 11:18 Rob,If I had to report off three joined tables, I would definetly create a stored procedure with parameters I'm using it to print data onto a pre-printed letterhead, so I don't need to display the header. --- or --- As an alternative, is there a way to automatically start Check This Out

It still tells me that "the server has not been opened".AAAGGGGHHHHI do have one DB that has more than one record, but it should loop through them shouldn't it?? About UsTell FriendsHow to AskHow to VolunteerFAQTech SupportTop ExpertsExpert LoginBrowse Answers:By CategoryAlphabeticallyFind expert answers to:Find This site uses cookies. You can through code determine the support capabilities of 'the requesting browser. Open your report in the Crystal Designer, got to "Database" menu and select "Set Location". find more info

Another .cab file? This tool will scan and diagnose, then repairs, your PC with patent pending technology that fix your windows operating system registry structure. This is the base exception class for the Crystal Report Engine.

Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 27 Mar 03 15:55 Thanks LV. RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 25 Mar 03 11:42 Thanks again LV. Also I am using Oracle 9i as the database.

Check your user name and password."); } } } [C++] Copy void crystalReportViewer1_HandleException (Object* sender, CrystalDecisions::Windows::Forms::ExceptionEventArgs * e) { try { EngineException* engEx; engEx = __try_cast(e->Exception); if (engEx->ErrorID == EngineExceptionErrorID::DataSourceError) { RE: Server has Not Yet Been Opened LV (Programmer) 22 Mar 03 00:19 Try giving administrative rights to the account, under which your web site is running, on your dev box. 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 http://forums.devshed.com/asp-programming-51/help-crystal-reports-asp-50574.html strCrxCabPath = "http://" + Request.ServerVariables("SERVER_NAME") strCrxCabPath = strCrxCabPath + "/viewer/activeXViewer/activexviewer.cab" ' The code to set up the ActiveX viewer has been modified from the Crystal ' default to ensure server independence

I'm just trying to get something to work before I go crazyyy. The Crystal Reports An Error Has Occurred On The Server In Attempting To Access The Data Source error is the Hexadecimal format of the error caused. Any experience with this? I don't have one listed in the box.

It provides the ErrorID property so the error type can be determined. http://www.tek-tips.com/viewthread.cfm?qid=506382 After I got the query to work, I used response.Write(Session("oRS").Fields("ClaimNO")) & Etc... RobJust my $.02. I don't have any Response.End in my files.

Yes, the report is still in the same directory with asp file, i dont make any changes in the file. his comment is here Exception Classes Exception Class Description DataSourceException Inherited from EngineException. PrintingFailed An error occurred while printing a report. Many thanks for any help given.

This can happen if an incorrect file name or path is given, a non-Crystal report is selected, or the report has been corrupted. This is to elimainate the overhead of loading and unloading the 'cpeaut32.dll in and out of memory. Generated Sat, 19 Nov 2016 22:11:58 GMT by s_wx1194 (squid/3.5.20) this contact form RDLC vs.

Join UsClose 418,854 Members | 815 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics > asp / active server I looked again, and I was. If I redirect to the ASP page calling the report, and pass a variable in the querystring, how do I get that perameter in the report's sql?

Posts: 30 Thanks: 0 Thanked 0 Times in 0 Posts koecrit, Which one of the several examples given was used by you?

I actually considered using a .ttx file, but ended up defining my querystring in the asp page before I launched the report. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Any help is greatly appreciated. I have 71 of them. 71 in the query, 71 in the sql statement, 71 in the .ttx file, and 71 on the report.

I know my recoreset is being returned correctly, because I took the time to check it with response.write for each field. RE: Server has Not Yet Been Opened LV (Programmer) 24 Mar 03 19:02 What data source does you report originaly report off, ODBC or native? HTML Page Smart Viewer ' 'The Smart Viewer that you use will based on the browser's display capablities. 'For Example, you would not want to instantiate the Java viewer if the navigate here 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.

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 If you are using oracle then teh database name should not be provide ie supply the DSN, UserID and Password only not the database name in the asp code. http://pub18.bravenet.com/forum/1478493774/show/143421 avidan View Public Profile Send a private message to avidan Find all posts by avidan #3 06-04-2008, 03:03 PM avidan Administrator Join Date: May 2007 Posts: 509 One table name stays the same, the other two change each time the app is used.

ActiveX Smart Viewer '2. The tables below show the different exception classes and enumeration values. Do not remove the last 2 include flies and just insert that code above, but add Response.End after so it'll look like this:for each crtable in Session("oRpt").Database.Tablescrtable.SetLogonInfo "Server", "DataBase", Cstr(crUserID), CStr(crPWord)Response.Write RE: Server has Not Yet Been Opened LV (Programmer) 26 Mar 03 13:55 Could you please do the following:1.

All other error messages will be left to the Crystal Report Engine to display. [Visual Basic] Copy Private Sub CrystalReportViewer1_HandleException(ByVal source As Object, _ ByVal e As CrystalDecisions.Windows.Forms.ExceptionEventArgs) Handles CrystalReportViewer1.HandleException If RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 25 Mar 03 20:52 I'm telling ya, this damn thing is killin' me. In my research on your issue, it seems to be a crystal specific issue. Faq Reply With Quote October 20th, 2003,09:35 AM #7 No Profile Picture aletheia2 View Profile View Forum Posts  Junior Member Devshed Newbie (0 - 499 posts)  Join Date

RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 29 Mar 03 14:11 Thanks LV, I'll try that. I had found some code examples at business objects that directed me in the same way your response did. Then go to Start...Settings...Control Panel..Administrative Tools...Component Services. This exception is thrown when an error occurs while printing a report.

ParameterFieldException Inherited from EngineException. I've done what you suggested. set session("oRptOptions") = Session("oRpt").Options session("oRptOptions").MorePrintEngineErrorMessages = 0 'These lines disable the Error reporting mechanism included the built into the 'Crystal Report Print Engine (CRPE32.DLL). This will give the user more detailed information.