How to create a source component using Oracle oledb connection in x64??
View Complete Post
I'm trying to create an Oracle data source object, using Sharepoint Designer 2010, and getting nothing but vague errors.
Here's what I'm doing:
1. In Data Source Library I tried to establish a new database connection.
2. Checkmark the "Use custom connection string"
3. Selected "Microsoft .NET Framework Data Provider for Oracle" OR "Microsoft .NET Framework Data Provider for OLE DB" and specified the Connection String as
Data Source=<<TNS ENTRY>>;User Id=<<>>;Password=<<>>;Provider=OraOLEDB.Oracle
4. After defining the string I clicked Ok.
5. After click Next it gives the message “The selected authentication option saves the user name and password as clear text in the data connection. Other authors of this website can access this information.”
6. I clicked on Ok and it gives me the message “Server Error: An error occurred while retrieving the list of table from root database. The query you are trying to execute contains syntax errors.”
7. The "Select Database and Table, View, or Stored Procedure" step comes up, with a Database of "root", and no tables listed.
Does a "root" table have any meaning in Oracle? Why aren't I getting a list o
I copied an old report and changed the data sources. The report works fine in the designer and on the report server. But when I run it from the server on which the database is located it gives me the following error. Works fine when I use 'Store credentials
in report server'. tried anonymous login too. Doesnt work.
On my dev serverÃÂ I have working ssis packages that use connections Microsoft OLEDB provider for Oracle MSDAORA.1 and Oracle provider for oledb and OracleClient data provider.
I use one or the other according to my needs.
In anticipation and to prepare for the build of a newÃÂ production server, I have build a test server from scratch and deployed to it the entire dev.
Almost everything works except Microsoft OLEDB provider for Oracle.
ssis packages on the test machine will return an error
Error at Pull Calendar from One [OLE DB Source ]: The AcquireConnection method call to the connection manager "one.oledb" failed with error code 0xC0202009.
Error at Pull Calendar from One [DTS.Pipeline]: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
[Connection manager "one.oledb"]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".
I have used the same installers for OS, SQL and Oracle SQL*Net on both dev and test machines. The in
SQL Server 2008 using Report Builder v2.0 (Microsoft SQL Server Reporting Services Version 10.0.2531.0)
We have several reporting service apps with many reports in each one. There is a set of 4 reports that all report on similar info (but grouped differently) that can be run by me and other network administrators but not any "regular" users. On these
reports only, they are getting "Cannot create a connection to data source ... Login failed for user...". As I've said there are other reports that regular users can run just fine!? ALL reports use the same Shared Connection Data Source on the server
that is set up as Windows Integrated Security. The Data Source's Security allows Domain Users to browse.
I've uploaded a test report to SSRS whos SQL is "SELECT 'test' as testField" and that's it: and is connected to this same Data Source and users still get the Login Failed error... even tried creating and using a new Data Source that points to the same SQL
Server DB to no avail. Examining the rdl's XML doesn't reveal anything either.
Reporting Server is a different machine than the SQL Server DB holding the data.
The only clue is that working reports were created a year before now.
I have the command ICommand::Execute()- this is supposed to execute a select statement that has to return 2545 rows.
But I have limited my row set to contain 256 rows at a time through: IRowSet::GetNextRows(NULL,0,256,&Active,hrow);
After that another command executes in ICommand :: Execute() which is another select statement.
Immediately i get an exception whose description says "Cannot create new connection because in manual or distributed transaction mode"
I checked the execution in sql profiler, and i found that the first select statement got aborted during the flow. After that i tried to increase the maximum rowsize from 256 to 2545, here it worked fine without the exception. But i need
to keep max rowsize as 256 due to design reasons.
I tried to do the operation on another table, where the select command returned 375 rows and the max rowsize was kept at 256. Here it executed fine without any exceptions
I checked the MSDN article 272358 (
http://support.microsoft.com/kb/272358 ) which states : With the Microsoft OLE DB Provider for SQL Server (SQLOLEDB), when you try to run multiple commands in the same session within the scope of a trans
Is it possible to set the Connection property of an OLE DB Source component at run-time using a script task? The Connection Manager exists at design time but based on different development/production databases, I need to set which connection manager should
be used for the OLE DB source at rum time. If possible, how do I accomplish this?
(Visual Studio 2005)
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 !