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

X123Est). avidan View Public Profile Send a private message to avidan Find all posts by avidan #4 06-06-2008, 11:30 AM DrewBell Member Join Date: Jul 2007 Location: Connecticut Posts: 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. Read that in the Reports.asp page. check my blog

Anyway, all I did was make sure that the smartviewerjava.asp file was in the same directory as my report, and then I changed the include statement to the java viewer. HTML Frame Smart Viewer '4. Of course, the developer I replaced had already installed Crystal on the web server, and had done some development with it, but I don't think he did anything special to install In your previous posts you mentioned that those tables you report off are created on the fly from within the app.

When I start the asp page I set the table names in a variable named "OnrVslTable" and one named "EstTable" The OnrVslTable in the sql query is converted to (eg. In the IIS console, right-click on your web site/directory and in the "Home Directory" tab, under "Application Protection", set the level to "Medium(Pooled)". But I don't know how to set up the security rights on the Crystal reports .DLLs Runtime.

RE: Server has Not Yet Been Opened LV (Programmer) 28 Mar 03 14:25 Another way to filter records in your report (I think, that's what you are trying to achive by With each use of the app, it creates 2 new tables. Thanks again for all of the help you provided. ActiveX is especially designed for IE but you can use any of those.

Stay logged in Digital Point Home Forums > Development > Programming > C# > Log in to view your Analytics, AdSense & PayPal stats Home Forums Search Forums Recent Posts Spy 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 This what make me confused :( do you have any solution for me ? I appreciate it.

All rights reserved. I hadn't had any exposure to the new abilities, and find it swiss-army type reporting tool, where any system data from lease abstract details to je's to graphing agings by building InvalidExportOptions The export options values passed to the Report Engine are either incorrect, or missing data. Faq Reply With Quote February 7th, 2003,11:19 AM #4 No Profile Picture dc_OnTheEdge View Profile View Forum Posts Visit Homepage  Junior Member Devshed Newbie (0 - 499 posts) 

It works. http://www.tek-tips.com/viewthread.cfm?qid=506382 Error Number = -2147206460 Error Description = Invalid directory.' I can review tenant and other data, but the reports return this issue. If it's supposed to report off of a recordset, I don't really see the need to have it log onto the table at all. 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.

but still the report is not shown! click site Is there a good book for CR8.0 that you recommend?Thanks again. The database is accessable even over the web. 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 think I'm going to make a simpler report from one table and try it. I get the following error: -2147189176An Error has occured on the server in attempting to access the data source My code is based on the samples page that come with Crystal. You may even try putting the DSN name and the Database Name before providing your user ID and Password. http://ogdomains.com/crystal-reports/crystal-reports-an-error-has-occurred.php would anyone know how to fix th is?

I have a setup a System DSN for the report. NOT for ASP.NET 1.0, 1.1, or 2.0. You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions.

Creating the application object - session("oApp") 'loads the Crystal Reports automation server (cpeaut32.dll) into memory. ' 'We create it as a session variable in order to use it for the duration

It did write true 3 times on the page and I do have 3 tables.The report will open now, but it's with the data that I used to design the report, Posts: 7 Thanks: 0 Thanked 0 Times in 0 Posts Quote: quote:Originally posted by ros1188 The following link provides with examples when using CR10 http://support.businessobjects.com/c...spzone_default Ros1188 hi,.. I had put in the application path, and it wasn't supposed to be there for our purposes. I even read another article on the CR website, and did what it suggested.

These are the actual table names in the database. crtable.Name - authors, crtable.Location - authors_newif crtable.Name = "table2" then crtable.Location = "newTable2Name"if crtable.Name = "table3" then crtable.Location = "newTable3Name"nextI created a little sample and it works just fine. RobJust my $.02. More about the author It is identical to the code given with the examples for cr9, Most probably the way in which you are providing the database authentication is wrong.

I have the p2smon.dll in the system32 folder. These files are available at Microsoft's web site." CRViewer.ReportName = "<%Response.Write strAppPath%>rptserver.asp" else Dim webSource Set webSource = CreateObject("WebReportSource.WebReportSource") webSource.ReportSource = webBroker webSource.URL = "<%Response.Write strAppPath%>rptserver.asp" webSource.PromptOnRefresh = False CRViewer.ReportSource = LogOnException Inherited from DataSourceException. My accounts and options settings are as follows: reports path c:\voy_defpath\ reports temp path c:\voy_defpath\temp\ attachments path c:\voy_defpath\attach\ default path c:\voy_defpath\ I've tried changing it to unc, which is accepted for

RE: Server has Not Yet Been Opened rtshort (IS/IT--Management) (OP) 2 Apr 03 12:10 I change the table names in the SQL Query. If I want to use SmartViewerJava, what do I need? Advertising (learn more) Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. Thanks again for ALL of your help.

This exception is thrown when there is a problem formatting the report. 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.