Post New Web Links

Need Oracle Data Provider .CS File for Oracle 10g Database connection !

Posted By: Posted Date: August 21, 2010 Points: 0 Category :ASP.Net

Hi.,

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

(eg)

Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");

Gridview1.DataBind();

Plz Post the link if there is any open source !

View Complete Post

More Related Resource Links

SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider

Hi,

I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

Trying to run a stored procedure from vb code with oracle data provider.

Hello,

Here is my SP:

create or replace
PROCEDURE ZGETUSERSSIGNONS (vUid IN VARCHAR2, p_getuserssignon_recordset1 OUT SYS_REFCURSOR) AS
BEGIN
Open p_getuserssignon_recordset1 for
SELECT Distinct(Userid), UserPassword, SecurityLevel, ActiveStatus
FROM ZSIGNON
WHERE substr(UserId,1,2) <> vUid
Order By UserId;
END ZGETUSERSSIGNONS;

I would like to run this SP from code and fill a gridview with the result.

I am not sure how to go about this, as I have found several different examples, other than the one I think I need.

I am using the oracle data provider and I have an input parameter (vUid, which will equal "zz").

First question. When filling a gridview with a result set from a stored procedure should the recordset OUT be defined as a REFCURSOR (like i did above)?

Second:

Do you have example code as to how to execute the SP and fill a gridview? I keep trying different variations of code i've found on the internet without any success other than getting more confused.

(I am using VS 2005, VB).

Thank you.

Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' cou

Hi. I have connected my SSAS in SQL server 2008 to an Oracle database. I have installed the Oracle ODAC to enable me to set up the Data Source, the Data Source View and the Cube. Now everything was going fine. I could connect to the Oracle Database and I could see my tables and pull them into the DSV. But. When I come to process the Cube it throws these errors. Why all of a sudden do the connection objects stop working? Errors in the back-end database access module. The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'DBIBGEORAclients', Name of 'DBIBGEORAclients'. Can anyone help here please? Thanks, David.

missing oracle provider for ole db in data link properties of adodc1 in my vb with already installed

missing oracle provider for ole db in data link properties of adodc1 in my vb with already installed oracle client...

please help how to have this "oracle provider for ole db"

Server Explorer Data Connection to ORACLE in VS2008 on Vista x64?

How do I set up a connection to an ORACLE database from Visual Studio 2008's Server Explorer in Vista x64?

If I install the 32-bit ORACLE client, I can configure a Data Connection in Server Explorer, but I can't use it to connect to the database because I can't setup a DSN in the Control Panel (the Oracle provider doesn't show up because it's a 64-bit OS).

If I install the 64-bit ORACLE client, I can configure a DSN in Control Panel, but I can't configure a Data Connection in Server Explorer, because VS2008 is a 32-bit app and throws a BadImageFormatException when it tries to load the 64-bit OCI.

Is there a way to do this without moving to a 32-bit development environment?

Oracle connection fail with Microsoft OLEDB provider for Oracle MSDAORA.1

Hello,

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 [1]]: 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

Problem in connecting to oracle database,which is using Provider=MSDAORA.1

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...

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server

Dear All,
please to try to help me what could be the problem ?. when i try to excute my stored proc in my sqlserver management studio it excuting fine when i trying to Excute using Asp.net application it giving Error. iam working on Sql Server, mt linked server is Oracle. my proc is like :
select ID,Name from OPENQUERY(TEST, ''
SELECT
ID ,
Name from Details)
Error:Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "TEST".
OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" returned message "ORA-01017: invalid username/password; logon denied".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Please try to guide me i unable run using asp.net App

thanking you,

santhosh

Oracle Data Provider for .NET error

Hi Members,

I'm trying to invoke an procedure in Oracle with my C# code and it keeps erroring out as "Invalid number or type of argument".

I've passed my statement as query string and try executing it. It worked fine but it keep failing when I call it via a Procedure. I've copied the procedure, source and the error message as well.

Kindly suggest.

Source Code:

using (IMTConnection conn = ConnectionManager.CreateConnection())
                    {
                        ((BasePage)this.Page).GeneralInformation = a + "-" + ucAdjustmentSettings.Settings.InvoiceID.GetType() + "-" + b + "-" + ucAdjustmentSettings.Settings.AccountID.GetType() + "Done";
                        string callStatement = "SP_ADJUST_INVOICE";
                        //string qrystr = "SELECT id_view FROM t_prod_view

access Oracle database

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?

Thank you.


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All