I am just beginning to experiment with using Excel Services with BI Dashboards in SharePoint 2010. I created a Excel Workbook that has a data connection using connection
type of OLE DB Query with a connection string of "Provider=MSDAORA.1;User ID=<username>;Data Source=<oracleEnvironment>". I have the Excel Services Authentication Settings set up for a specific SSS ID <mySSSID>.
This Excel Workbook has been Saved to SharePoint with an entire sheet published. The Excel Web App is displaying the sheet and the Slicers are functioning just
like they do in the Excel client. When I refresh the data on the client I get prompted for a password and it works fine. When I refresh on the Web App I have received a variety of errors depending on what I try but nothing has helped me track down
what I have missed.
View Complete Post
Hey guys, I'm running a query that brings millions of records and makes the server run out of memory. I'm thinking I should get the data in chunks. So I was wondering if someone could shed some light on this or point me to another place where I can read further.
Currently, I just implemented "paging". I can now pass a "page index" parameter and "page size". So I could call 1,000 times the stored procedure with a page size of 1,000 (for 1 million records). This might be an option, but I wanted to hear someone else's opinion on how to "stream" records from oracle to the web server and then to a file.
Hi I am Naveen, I am upgrading a internal website from .Net 1.1 to .Net2.0 in Vb.
The database is deployed in the server, but i could not connect to that database.
i have to connect database to few drop down lists,
my manager has given connection string to me... i have placed it in web.config and given that link properly in the code..
but the database is not connecting.. the list is showing empty..
my conn string is
<add key="D2" value="Provider=MSDAORA.1;Data Source=baan; User ID=xxxx; Password=xxxx;Persist Security Info=True"/>
can anyone help me,,, thanks in advance...
I am not able to connect oracle database from MS-Analysis Services.
All my Fact tables and Dimension tables are residing on Oracle database.Both the Oracle database and MS Analysis Services are on the same server.
I am working on the node and I was able to create the datasource using "Microsoft OLE DB Provider for Oracle " and the test connection also succedded but while creating the cubes using the cube wizard it throws error saying " Connection to the data source Failed".
Any one could help me in this regards.
What are the ways to connect the oracle DB from MS Analysis Services.
Is this problem becoz of any permission settings, how do I give permissions for the users.
I am novice user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.
The connection string that i setup as follows.
<?xml version="1.0"?><configuration> <system.web> <compilation debug="false" targetFramework="4.0" /> </system.web> <connectionStrings> <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings></configuration>
And i am using websecurity helper as well and the setup is as follows.
WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);
When i am trying to insert the user details into database i am getting the below error.
Format of t
I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where
i can just call the method with my SQL Query
Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");
Plz Post the link if there is any open source !
This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.
MSDN Magazine August 2009
The Excel Services architecture lets users design their own algorithms and share workbooks on a server.
Vishwas Lele and Pyush Kumar
MSDN Magazine August 2007
Excel 2003 lets you dynamically integrate the data provided by different Web services. It also lets you take advantage of the latest capabilities in Office 2003 to customize list views, graphs, and charts, and to catalog bulk items online or offline. Find out how you can makle the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API.
MSDN Magazine February 2005
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?
I am working on updating a reporting system that uses Crystal Reports. All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location. All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location. The reason I need to update the location is so that the .NET application will use the correct driver. Everything has worked fine up until I got to one stored procedure. The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.
First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report. It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure. Then I get the following error:
Query Engine Error: 'ADO Error Code: 0x
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'