Search results matching tags 'Oracle' and 'oracleconnection'

Oracle Change Password Dialog Box Not Prompting

satishreddy — Wed, 24 Jun 2009 04:00:00 GMT

Hi all,

I am using oraOledb.oracle as My Provider in my asp.net 3.5 application for connecting to my oracle database . In my application the user login is the same as oracle login, Means i need to validate the user login with my oracle user login. On every successfull login I need to show a message box to display the remaining days for the password expiry. If the password is already expired the default prompt which oracle will through when we try to login using toad should be displayed from my application also. I am able to get that change password dialog box when i am running it from visual studio while development, But after deploying it into the IIS it is not able to show that dialog box and the application is getting hanged. Please guide me where i am going wrong and what permission do i need to check.

my connection string is

connectionString="Provider=OraOLEDB.Oracle;Data Source= MVNOODSD;PLSQLRSet=1;pwdchgdlg=1;"

Thanks In advance..

Re: Oracle Report

mr_karachi92@yahoo.com — Wed, 22 Apr 2009 04:00:00 GMT

The above url post me back to Oracle Forums main page

unable to see Oracle Forums help. Still require your guidence.

Regards

regarding connection pooling in oracle for my .net application

shivarlakrishna — Mon, 12 May 2008 04:00:00 GMT

actually we are using microsoft entireprise library for connecting to sql server database which is giving good performance for my application.Here I had a problem for my new application where I am using Oracle database as back end.To increase the performance of my application which library I need to use.whether that library overcome the connection pooling problems of my application.wht r the connection classes and methods that library conatains,which of the classes and methods I have to use to get good perfomance my application.please give brief description about that library so that i can find out the methods and classes of that library easily.......

Oracle 11G and IIS 7.0

FuGoAlberto — Wed, 07 May 2008 04:00:00 GMT

Hello .... I have an application server with Windows Server 2008, IIS 7 and Oracle Data Provider 11G. The website was set up. NET 2008 has made reference to the oracle, and to run from the application working properly executes the SQL without problem, but to make the creation of a website The IIS 7, and test its functionality, displays the following error

Could not load file or assembly 'Oracle.Web, Version = 2.111.6.20' or one of its dependencies. The system can not find the file specified.

The problem may be a compatibility between the version of Oracle 11G and IIS 7.0, I do not know if there is an additional component to the IIS 7.0 can recognize the version of Oracle as a provider of data? Please I am attentive to their solutions .... Thank you

Insert not inserting to Oracle db

asp.newtome — Wed, 23 Apr 2008 04:00:00 GMT

Hi,

I am just trying to learn ASP.NET but have run into a problem when attempting to insert data into my database.

I am using Oracle 10g Express Edition, Visual Studio 2005 and the code is in C#.

Here is the code I am using to call the insert statement;

        string sql = "INSERT INTO offices (office_number, city, address, tel_number) VALUES (45, 'London', 'Tottenham', '2342234234');";
        OracleCommand command = new OracleCommand();

        using (OracleConnection myConnection = new
            OracleConnection(ConfigurationManager.ConnectionStrings[
            "connectionString"].ConnectionString))
        {
            command.CommandText = sql;
            command.Connection = myConnection;

            try
            {
                myConnection.Open();
                command.ExecuteNonQuery();
                myConnection.Close();

            }
            catch (Exception ex)
            {
                 ...
            }
        }

The connection string is;

</connectionStrings>

I have created a function that retrieves data from the database OK which is displayed in a grid view, but when I run the insert nothing is inserted into the database. I don't get any errors and I'm confident that the connection to DB is OK as I have already been able to retrieve data as mentioned, I just dont know if there is something I am missing such as a commit for example? Have looked on the web and tried it a couple of different ways but still can't find a solution.

Any help would be gratefully received.

Regards

Re: The database DLL 'crdb_oracle.dll' could not be loaded.

Kellem00 — Tue, 01 Apr 2008 04:00:00 GMT

I had the same issue when upgrading a project from Asp.net 1.1 to Asp.net 2.0

The report was built in crystal Reports XI however when I included it in my Asp.net 2.0 project I got this error.

The solution for me was to reinstall crystal http://support.businessobjects.com/downloads/service_packs/crystal_reports_en.asp

I installed Crystal Reports XI Release 2 and Crystal Reports for Visual Studio .NET 2005

When installing Crystal Reports XI Release 2 I did a custom install. In this custom install I selected anything that related to oracle.

I'm not 100% sure why I needed to do all this but all I know is that the project ran in Visual Studio 2005 after I had completed this.

Hope this helps anyone who might be unfortunate enough to be getting this error

How to make a oracle package call and receive the return values as dataset

kabir.khan.net — Tue, 12 Feb 2008 05:00:00 GMT

Here is My Problem, I have a complicated login porcess, there are two seperate databases involve in it. Firstly, I will search the userid in the local sql server 2005 database, if not found I will call an oracle package which is being develop by a third party(none comercial) and that package will verify the userid and password and return me user's present credentials (rolse, orgs, etc) as dataset. My question is how do a call that oracle package from asp.net application and how do a recieve a oracle dataset or cursor at the asp.net. Sorry if i wasnt clear. I really do need help on this, any help will be appreciated.

I will like to use ODP.net if at all possible.

Thanks

Kabir

Setting a variable package on logon

jflopezv — Thu, 06 Sep 2007 04:00:00 GMT

Hello All,I have this problem:

I have many tables that have a field to identify users data ("ME" field) and for each table there is a view that filter the data for that user (user logged on). Here's an example of a table with it's view:

CREATE TABLE esquema_me (codigo VARCHAR2(3) NOT NULL, descripcion VARCHAR2(50) NOT NULL, me number NOT NULL)/ CREATE OR REPLACE VIEW esquema ( codigo, descripcion) ASSELECT a.codigo, a.descripcion FROM cmp_esquema_me a WHERE me = session_info.getmultisession/Here is the code of the SESSION_INFO package:CREATE OR REPLACE PACKAGE session_info IS MultiSession number := 0; function GetMultiSession return number; procedure SetMultiSession(nData number);END; -- Package spec/ CREATE OR REPLACE PACKAGE BODY session_info IS function GetMultiSession return number is begin return MultiSession; end; procedure SetMultiSession(nData number) is begin MultiSession := nData; end;END;/ As you can see, the data returned from the view depends on the MULTISESSION package variable value.

I would like to know if the database session established at first remains all the user web session, so I just need to set the variable once, and all data returned belongs that user for along database session. In other case, I’d have to set that variable on each query to database.

When i use datasource control binding with no code, how asp.net manage the connection to database?? Does it connect every time that the control queries data?

I'll appreciate your suggestions

Thanks in advanced,Fernando

Re: OracleTable to C# Class

opethema — Wed, 13 Jun 2007 04:00:00 GMT

i have developed this tool myself!

thanks for no help.

"Specified slot number was invalid" when open OracleConnection

lectrung — Thu, 07 Jun 2007 04:00:00 GMT

Hi All,

OracleConnection ocon = new OracleConnection(ConnectionString);

ocon.Open();

I got the error message:

System.ArgumentException: Specified slot number was invalid.\r\n
at System.LocalDataStoreMgr.ValidateSlot(LocalDataStoreSlot slot)\r\n
at System.Threading.Thread.GetData(LocalDataStoreSlot slot)\r\n
at Oracle.DataAccess.Client.OracleConnection.get_InternalContextConnection()\r\n

How to fix this error?

Thanks

Trung