Search the Community

I'm having difficulties with connecting Collabion Charts to an Oracle DB, and I'm hoping I can get some help here as I like this product a lot, and so do my superiors I researched all the other forum content here in regard to Collabion/Oracle. I've installed the Oracle 11G client on both my Web and App servers (as I was not sure how Collabion would be routed to connect to the Oracle DB). Do I need to install on the SQL server? I would prefer to connect to the server directly in the web part, but it only asks for the server, username and PW which I understand will not allow a connection, but one of the forum posts I read here suggested to connect via putting a string in the server field such as: (Description=(Address_List=(Address=(Protocol=TCP)(Host=[serverName])(Port=1523)))(Connect_Data=(Service_Name=[service Name])(Instance_Name=[Your instance name]))) I tried the following and was not successful: (Description=(Address_List=(Address=(Protocol=TCP)(Host=X.X.X.X)(Port=1523)))(Connect_Data=(SID=CDW10B)) After install of the 11G client, I've managed to connect to the Oracle DB in question via the MS ODBC Data Sources (64bit) connection on each of those two servers. Also, our Oracle consultant was able to connect via the command prompt. I can connect to the Oracle DB in Collabion Charts via inputting a connection string, but no queries work (either they get a "Arithmetic operation resulted in an overflow" or an "ERROR [HYT00} {Oracle][ODBC}[Ora] ORA-01013: user requested cancel of current operation" Am I doing something wrong with the above material? I would definitely be grateful for assistance on this!

Hi Team, I have a requirement where we want to renders the pie chart in the JSP page using Fusioncharts. The data should populate dynamically using the Restfiul webservices. The service response will come in JSON format & the database is Oracle. I have a working example, where able to show it from the json file in the html page, which is using the dummy data. Can you please share any working example with above requirement. Here am attaching the html page & json file that used in the server to render data. We have to fulfill the same requirement where the data should come from the service/database and populate dynamically. Regards, RaviauditReport_json.txt linkedParent.html

Hi there, I have several posts in this forum asking about tactical questions, however with time I learned that I have to start with a question about the best practice as I am not aware about FusionCharts capabilities with regard to the development technology I am using. My solution and used technology: I am developing Visual Studio C# 2010 project to create a report web page that has several buttons (each present a country) and a graph (column 3d showing countries versus balance) in the middle of the page. Each time the user clicks on one of the buttons, the graph filter changes and display the new results accordingly. The page loads the country buttons dynamically using C# code that connects with an Oracle DB (11g on Unix) to get the list of countries. The Country balance is also in Oracle DB. So basically I have a web page with a main table that looks like the following: <%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="360MainScreenUserControl.ascx.cs" Inherits="_360Report._360MainScreen._360MainScreenUserControl" %> <%@ Register assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.DataVisualization.Charting" tagprefix="asp" %> <asp:TableRow ID="TableRow2" runat="server"> <asp:TableCell> <asp:Table ID="CountrySection" runat="server"> </asp:Table> </asp:TableCell> <asp:TableCell> <asp:Table ID="GraphSection" runat="server"> </asp:Table> </asp:TableCell> <asp:TableCell> <asp:ListBox ID="lbAgreement" runat="server" onselectedindexchanged="lbAgreement_SelectedIndexChanged" onprerender="lbAgreement_PreRender" AutoPostBack="True" ForeColor="#006F5F" Width="180" Height="750" Font-Names="Calibri" Font-Size="14" > </asp:ListBox> </asp:TableCell> </asp:TableRow> each section (table) is filled by C# code that connects to Oracle. What I need is to use FusionChart to fill the GraphSection (show the graph in a table cell) and make it sensitive to user selection (when choosing any of the buttons that are dynamically created and shown in the CountrySection in the above code). Now my questions are: 1- What is the best practice or recommended approach? - Do I use the SharePoint collaboration to create my chart as a web part and then use it from the code to show this web part in the cell in GraphSection? - Or I should only work with FusionChart XT for .net and create and render to chart into the cell in GraphSection using C# code? 2- Following one of the practices above, how can I pass the parameters to the chart and refresh it? 3- The most important question: I am facing difficulties as I am trying both solutions and found no complete example. Can you please lead me to one. Many thanks,