Databases :: Using An Oracle Database Causing Exception

Nov 5, 2010

I'm a little confused as to what is causing the following error is a very simple application: System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB The code-behind has this:

OleDbConnection conn = new
OleDbConnection(ConfigurationManager.ConnectionStrings["db_conn_qa"].ConnectionString);

In the Web.Config, the following is present (note the Provider is clearly there):

<configuration>
<appSettings/>
<connectionStrings>
<add name="db_conn_qa" connectionString="Data Source=xx;Persist Security Info=True;User ID=xx;Password=xx;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>
<system.web>
...

View 2 Replies


Similar Messages:

Databases :: Causing Oracle Database Table Failing To Save Inserted Record Permanently?

Sep 29, 2010

I have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?

View 4 Replies

Databases :: Custom Oracle Exception Handling?

Jul 23, 2010

I have a web page with 5 textboxes (for branch_id, street, city, state, and zip) and a button. When data is entered in the textboxes, the button is clicked and the data is populated in the database. I have the sql INSERT statement ("insert into branch values(:branch_id,
location_type(:street, :city, :state, :zip), staff_nested())") in both the SELECT command and INSERT command. It was originally in just the SELECT command, but I also added into the INSERT command in case I need to do something in the on_insert or on_inserting event. I'm not sure if that would actually work since I click the button to enter.

Anyway, if a duplicate key is entered in branch_id the error "ORA-00001: Unique constraint violated" is raised. I would like to change this and put my own error message, such as "ID is already used, select another." What I have so far is below. I do still get the same message.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
Catch ex As OleDbException [code]....

View 10 Replies

Databases :: SQL Server Database Dependency In Oracle Database?

Feb 27, 2010

I'm working with Oracle database and I want to improve performance of my website.I read about caching. So is it possible to implement caching (SQL Server Database Dependency) with oracle?

View 2 Replies

Databases :: Use Oracle Database With Mvc 2 Web Application?

Oct 2, 2010

how i can use Oracle database with asp.net mvc 2 web application?

View 3 Replies

Databases :: Inserting The Record In Tp Oracle Database Using Vb?

Mar 22, 2010

i am inserting a record into oracle database using vb.net,there is a password field by using md5 i am generating it and taking tht value as string(ex: "16D78A6B10D631C8C86397C35A3CCD57") now my requirement is i should insert it into database(oracle) & in database that field is "RAW" how to do this?and the error msg is
Type of value has a mismatch with column typeCouldn't store in Col_Pass Column. Expected type is Byte[].

View 1 Replies

Databases :: Inserting Operation On Oracle 10G Database Using 3.5?

Jun 6, 2010

i hv been trying to perform insert operation on Oracle 10G database using asp.net 3.5. So far i m new to oracle and i m confused as back end queries seems different froms sql server. this code is in submit button click event:-

[code]....

View 2 Replies

Databases :: Inserting Images Into Oracle Database?

Feb 25, 2010

am trying to insert images into oracle database using c#.net.but am getting error "ORA-01465: invalid hex number".Here is the code.

if (FUcontrol.HasFile)

View 4 Replies

Databases :: Increase The Database Size In Oracle Manually?

Jul 7, 2010

Can anybody tell me how can I increase the size of the database in oracle manually.

View 2 Replies

Databases :: How To Check Space On Oracle Database Server

Jan 27, 2010

I have to automate one database process in .Net web applicaiton which uses Oracle 11g Database as Backend.

I need to know two things:

(1) How to check space on Oracle database server? I need space on server and not in the Database itself. My process creates few tables so I want to make sure that we have sufficient space before the process starts.

(2) Also I need to create script to backup Indexes and Triggers on the table so that I can recreate them after data transfer process is completed. Any idea how to create script form c# code?

View 2 Replies

Databases :: How To Read Excel Using C# And Store In Oracle Database

Jun 9, 2010

How do I read excel(with many worksheets) using asp.net c# and load the data into oracle database?

View 2 Replies

Databases :: Cannot Read CLOB Data From Oracle Database In C# 4.0

Feb 4, 2011

am in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:

PROCEDURE p_GetData (
ivar_id IN id_n%TYPE,
oclb_owners OUT CLOB,
onum_sqlcode OUT NUMBER,
[code]...

View 8 Replies

Databases :: Developing A Web Application Using Csharp And Oracle As Database?

Dec 3, 2010

I am developing an web application using csharp and oracle as database. I have table with columns like below. How can I ensure that sql selects from one table column but it shows two columns depending weather it is Debit or credit. How can I come up with something Statement of Account ?

Number Amount Type


2 6000 Dr

3 4500 Cr

4 2300 Dr

5 1200 Dr

6 1300 Cr

Now I want the sql out put to be as below. How can I achieve?

NUMBER Dr CR Balance

2 6000 1000

3 4500 5500

4 2300 3200

5 1200 2000

6 1300 3300

View 4 Replies

Databases :: Unable To Insert Into Oracle Database - ORA-00911 Error

Jul 26, 2010

I am trying to insert values into oracle database using visual studio 2010 express edition. find the below code I used:

[Code]....

View 2 Replies

Databases :: Oracle Database Failover Not Working With Pooled Connections?

Feb 22, 2010

We have an Oracle 11g database with two nodes. On occasion, one of the nodes goes down and for some reason one of my applications starts throwing this exception:

Error Message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because
all pooled connections were in use and max pool size was reached.
at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)
at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
Out IT group says that this is a program bug because the failover isn't working, but I am thinking that this is a function of the database.What is the cause, and if it is an application bug, what can be done code-wise to fix this problem? The connection string doesn't specify a particular node.

View 1 Replies

Databases :: Check Sufficient Space Exist In Oracle 10g Database Before Executing Script

Jan 12, 2010

I have .Net web application which connects to Oracle 10g database. I want to check for space availibility before creating Indexes. Also if space is not sufficient then I would like to send an Email message to admin. How to do that from .Net web application?

View 2 Replies

Event Causing Error But Can't Catch Exception

Apr 22, 2010

A developer has created a custom control in ASP.NET using VB.NET. The custom control uses a repeater. In certain scenarios, the rpt_ItemDataBound event is encountering a data error. My goal is rather than having the user see the yellow screen of death, give the user a friendlier error explaining exactly what the data error is. I figured I would be able to use a Try/Catch block as shown below throw the exception, however, it appears that the event has nowhere to be thrown to and stops executing at the "End Try" line.

Protected Sub rpt_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles rpt1.ItemDataBound, rpt2.ItemDataBound
Try
ProcessBadData...
Catch ex As Exception
Throw ex
End Try
End Sub

In VB.NET, I can find where the repeater's DataSource is being set, however, I can not find a DataBind event. how I can capture the exception in this ASCX control so I can report it to the user? Edit: The stack trace looks like this. There is another repeater within the repeater that is actually causing the error (rptOther) and I'm able to catch the error, but I can only throw it to the rpt_ItemDataBound. I can't figure out how rpt_ItemDataBound is getting called without a DataBind event.

at Company.WebForms.Control.rptOther_ItemDataBound(Object sender, RepeaterItemEventArgs e)
at System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e)
at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.Repeater.DataBind()
at Company.WebForms.Control.rpt_ItemDataBound(Object sender, RepeaterItemEventArgs e)

View 1 Replies

Web Forms :: User Control Causing Null Reference Exception?

Oct 19, 2010

I am stuck into a problem, i have a user control ProductListing.ascx that contains ListView binded to an object datasource, SelectMethod and SelectCountmethod are provided as well. Everything works fine but the problem started when i add another user control declarativlly Filter.ascx in the productListing.ascx. I want to assign value to a public property MaxPrice in Filter.ascx. I am trying to set this property in the SelectMethod of ObjectDataSource. Usercontrol "Filter.ascx" throws null reference exception when i try to set its MaxPrice Property.

I tried to acced the usercontrol in Databind method of ListView , it is accessible here but viewstate is empty at this point, i saved the value in viewstate in SelectMethod of objectDatasource but i cant access viewstate in ListView Databind. Its empty. Its a simple code and no rewriting to viewstate elsewhere.

Important: My Codebehind files are in a seperate project and .ascx files in seperate project

View 1 Replies

Web Forms :: Page.FindControl Causing Null Reference Exception?

Aug 20, 2010

I developed a page in VWD 2008 and it works perfectly locally, but when I deployed it on the server every Page.FindControl() call is causing the NullReference Exception "Object reference not set to an instance of an object. " Can anyone help me out? Code is below

[Code]....

View 1 Replies

DataSource Controls :: Get Column Name Causing Exception To Create Log File?

Mar 19, 2010

I am writing queries with CONVERT function. I have more than 200 columns in query. I am processing each row and write it to file.I need to log all errors occured during process. I need to capture column which is causing exception (Arithmetic overflow error converting numeric to data type varchar.) and log it in other file and send to administrator.

How can I get Column which is causing exception?

View 5 Replies

BadImageFormat Exception With Oracle 64 Bit Client Running On Win 7 X64

Jun 30, 2010

I've run into a problem after installing the 64 bit Oracle client onto my Win 7 x64 dev box. I have installed and configured the oracle client and added a reference to it in my library project and it runs without problems when deployed to a Win 2008 R2 server; however I cannot run it in the built-in VS2010 debugger.

The code throws a BadImageFormatException when the .open() statement is called on the connection object.

I figured out that if I will run it in IIS and move the application out of the default application pool, the error goes away for some reason.

However, I can't do this when I'm running the test project (MSTest) and I the result is that I cannot run unit tests against this code. Yes, I can mock it, but I would really like to understand and eliminate this error. There are several cases where I would like to test against some test data in the database.

View 1 Replies

Databases :: How To Use Oracle 10g Using Toad

Jan 27, 2010

how we can use oracle 10g in asp.net 3.5 using toad

View 1 Replies

Databases :: How To Run The Oracle 32 And 64 Bit Clients

Feb 22, 2011

As the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g which Oracle clients do I need to run? Do I need to run the Oracle 32 and 64 bit clients? And if so what versions?

View 1 Replies

Databases :: Connect To Oracle Without DSN?

Oct 4, 2010

I need to find a way to connect to the remote Oracle server without a DSN. There are some practical problem for accessing the server using a DSN. I need a way to connect to Oracle server like I connect to SQL Server etc. For example, in SQL server, I can connect directly with server using Servername (IP adress) + Username + Password + DB Name. Any way to connect to the Oracle server like in SQL Server we do ??

View 6 Replies

Databases :: SqlDataSource On Oracle 64 Bit?

Aug 2, 2010

I have an Asp.net web application targeting .Net2.0 and my databse is oracle, I used SqlDataSource Control to communicate with oracle database its working fine on my development server, but on my production Oracle is 64 bit so im getting an error like

"<asp:ControlParameter doesnot have a property DbType="Int32"> "
i tried with Int64 also but still im getting the same error

following is the markup of sqldatasource i used
<
asp:SqlDataSource
ID="sdsEmployees"
runat="server"
ConnectionString="User Id=user;pwd=user1;server=prod" ProviderName="System.Data.OracleClient"
SelectCommand="GetEmployeeInfo" SelectCommandType="StoredProcedure"
OnSelecting="sdsEmployees_OnSelecting">
<SelectParameters> <asp:ControlParameter
ControlID="txtNumber"
DbType="Int32"
/> </SelectParameters> </asp:SqlDataSource>

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved