System.Exception: Unexpected Return Code: 1 At System.Data.OracleClient.DBObjectPool.GetObject Error
Jul 13, 2010
I have a windows service written in .NET 2.0 that will run every 5 minutes and executes bunch oracle SQL/PLSQL scripts based on time/validation, it throws the above said error some times against some SQLs, the same SQLs run fine at later point without any error, I have no idea what is going on with the app. I am not sure if this has any thing to do with oracle connection pool as I am properly closing the connections after every SQL execution.
Exception:
System.Exception: Unexpected return code: 1 at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString,
[CODE]............................
View 1 Replies
ADVERTISEMENT
Sep 2, 2011
I've spent a substantial amount of time trying to figure this out, but I keep getting the same error
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
A first chance exception of type 'System.NullReferenceException' occurred in project1.exe
This happens when I try to use the DataReader.my code is
Public Function Identification() As List(Of Integer)
Dim returnIndex As New List(Of Integer)
Dim dbCount As String = "SELECT Bookingid FROM bookdetail WHERE Date =" & getCurrentTimeString() & " 12:00:00 a.m."
Dim count As Integer = 0
[code]....
View 10 Replies
May 5, 2011
I am using VS 2008, Office 2007, and Win7 Home Premium on my system.I have a simple application which should be a breeze to build. All I am attempting to do is pull data from an Access database with four small tables into a data grid on a windows project. Should be simple, set up the data connection, choose a datagrid from the table in the data source view, drag it onto the page and done, right?I can't get it to work. It will all work fine until I attempt to run or debug the project. The data will not show up. The data grid does, but I get this error: A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll
As I said, the project seems to build fine, but it will not pull the data. After the initial build I get the message that Windows will show this page in Compatibility View. Is it something with Win7 Home Premium, or a setting somewhere?
View 4 Replies
Jan 27, 2010
Do While rdr2.Read()
Dim var1 As String = rdr2.Item("Week").ToString
Dim var2 As String = rdr2.Item("L1").ToString
Dim var3 As String = rdr2.Item("L2").ToString
It generates the following error: A first chance exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Interestingly, if I use a numeric value for the variable it for LSArraytemp, it writes to the database no problem at all.
View 11 Replies
Sep 27, 2008
I am trying to perform a simple bound connection between an Access database and a text box on a form. This is actually Chapter 18 of the "Microsoft Visual Basic 2008" book.I get the same error message when trying to create my own project "MY ADO Form" or the "ADO Form" project supplied from the DVD provided with the book. I am running the 90 Day Trial Version of Visual Studio 2008 with SP1 and Net 3.5 SP1.
My operating system is the 64 bit Version of Vista with all updates.The error when I try to run the application in the debug mode is:"A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll"and as a result no data shows up in the text box from the database and the data selection bar is grayed out in the form. The underlying database "Students Data Set" appears to be fine as I have seen the correct data for the fields "Instructor" and "PhoneNumber" prior to running the program and when connecting with the database.
View 1 Replies
Mar 28, 2011
I can't seem to get it to recognize System.Data.OracleClient. I downloaded and installed the 11gR2, added a reference to Oracle.DataAccess. Looks like there is a 4.112.1.2 and a 2.112.1.2 versions. I'm tried adding both to the project, but neither are giving me access to that assembly. i.e.
[Code]...
View 1 Replies
Oct 8, 2009
Trying to write a list of oracle commands to XML but keep getting this error. "There was an error reflecting type 'System.Data.OracleClient.OracleCommand'."
Friend Sub WriteDataToFile(ByVal Commands As List(Of System.Data.OracleClient.OracleCommand))
Try
Dim PathName As String = OffloaderDataPath() & "Commands " & Now.ToLocalTime.Ticks.ToString & ".XML"
[code]....
View 1 Replies
Apr 18, 2011
I installed .net 2010 ultimate but my proble is i cannot find a reference to System.Data.OracleClient.
View 1 Replies
Mar 26, 2010
Trying to insert 315K Gif files into an Oracle 10g database. Everytime I get this error "ora-01460: unimplemented or unreasonable conversion requested" whe I run the stored procedure. It appears that there is a 32K limit if I use a stored procedure. I read online that this does not apply if you are doing a direct insert, but I do not know how to create the insert string for a Byte Array. This is a thick client running on the server so not worried about SQL Injection attacks.
View 1 Replies
Sep 11, 2009
I am constructing a search function in a class to be used by several of our asp pages. The idea is simple, take a search term from the user and query the database for the item. Currently I am doing this the wrong way, which is vulnerable to SQL injection attacks (and ELMAH is in there to save the day if something goes wrong):
[Code]...
The problem is since I am using a like statement, I need to be able to have % on either side of the search word, and I can't seem to do that with '%:searchterm%', it just gives an error of ORA-01036: illegal variable name/number.Can I parameterize but still have my flexible like statement be a part of it?
View 2 Replies
Jan 15, 2009
I have a web site that I developed on Vista using Vb.net9. It makes a connection to Oracle. for the connection I use System.Data.OracleClient. It works fine on my machine, and our test server, but it does not work on the production server. We installed the Oracle Client 11 on the server. The error is System.Data.OracleClient requires Oracle client software version 8.1.7
We've tried, making a console app that opens the connection, connection runs fine, opens, displays a message and all is well there.Then we make a simple web form, put it in the directory of the program, just a button, opens the connection, try..catch, grabs error, same error.The console app was running under an Administrator, web site running under iwam. Is it possible that iwam has a different path?
View 5 Replies
Mar 21, 2011
get out from the below loop
Shared Function GetIPAddress() As String
Dim sam As System.Net.IPAddress
Dim sam1 As String
[code]....
View 4 Replies
Feb 19, 2010
When I run my project I get "An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll"
Public Class frmViewReport
Dim objForm As New frmViewReport
Private Sub frmViewReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
objForm.ViewReport("C:a2.rtp", , "@parameter1=test�mter2=10")
[code]....
View 1 Replies
Nov 16, 2009
I have the following code running, the first time I change the selected index, everything runs smoothly. However, if I try to change the selected index again, nothing happens and the subcategories combobox values do not change.
Private Sub cboMainCategory_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboMainCategory.SelectedIndexChanged
'* make sure the combobox is fully loaded
[code]....
View 2 Replies
May 6, 2009
I keep getting an eroor this error says: An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in system.windows.forms.dll Additional information: Specified argument was out of the range of valid values.
Option Strict On
Public Class frmWeeklyReport
Inherits System.Windows.Forms.Form
[code].....
View 7 Replies
Feb 6, 2010
I am working on a card game, and i get this werid error:
A first chance exception of type 'System.Reflection.TargetParameterCountException' occurred in System.Windows.Forms.dll
The code that is cousing this error is:
Private Delegate Sub ShowcardDelegate(ByVal test As String, ByVal objtest As Object, ByVal value As Boolean)
Private Sub Showcard(ByVal test As String, ByVal objtest As Object, ByVal value As Boolean)
If objtest.InvokeRequired Then
[code].....
View 10 Replies
Sep 4, 2011
i need to clear this error
A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
View 3 Replies
Jan 22, 2009
I am just trying to get the system to open a database and I get this error:
A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
here's the entire code of the main form
=======================================
Imports System
Imports System.Data
Imports System.Data.SqlClient
[code]....
the error is generated at the open method note* this same code works fine in another computer, the main difference is that this one has a 64 bit OS.
View 5 Replies
Dec 1, 2011
I'm using a 64 Bit Windows 7 system and trying to use PrintDialog. I know it doesn't work on Windows 7 unless you add this
PrintDialog1.UseEXDialog = True
So I have added that code but then I get this error for the following
Dim result As DialogResult = PrintDialog1.ShowDialog()
And the error:
"An exception of type 'System.Runtime.InteropServices.SEHException' occurred in System.Windows.Forms.dll but was not handled in user code
Additional information: External component has thrown an exception."
View 5 Replies
Oct 12, 2009
I am using VS 2008 with frame work 2.0. On my development machine I am using Oracle 9 as database. When I deploy my application where Oracle 9 is installed it works properly. but it gives error on oracle8 NT installed machine as follow.
"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater "I can get rid from this error.
View 1 Replies
Apr 10, 2009
i was under the impression that using the System.Data.OracleClient namespace will allow me to deploy my application without having the client machine install any OracleClient software besides the .Net Framework 2.0 which if i'm not mistaken, contains the System.Data.OracleClient.dll.
but after creating a WinForm application and then publishing it thru ClickOnce , i found myself getting this error when running the application on the client machine. is this a normal behavior or did i do something wrong in the process?
View 1 Replies
Aug 5, 2009
Error 1 Custom tool error: Failed to generate code. Exception of type 'System.OutOfMemoryException' was thrown. C:Documents and Settingsmiller_aDesktopFront End FCOMOctobaseOctobasefcomDataSet.xsd 1 1 Octobase
What does this mean? I have this error after i tried to add a database to my project in vb.net.If you're not living on the edge, you're taking up too much room
View 1 Replies
Apr 14, 2011
An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll it also says make sure you do not have infinate loop or infinate recursion il give all code in order that they are executed in Check the chechbox and it disables all irelevent stuff and populates the combobox
Private Sub CheckBox_Spray_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox_Spray.CheckedChanged
If Me.CheckBox_Spray.Checked = True Then
[code]....
View 4 Replies
Jan 26, 2009
i am trying to connect to an MS Access database and I am getting an erro message on the following line of
searchtable_command = New SqlClient.SqlCommand(searchtable_string, testsearch_connection)
Error:'System.Data.Odbc.OdbcConnection' cannot be converted to 'System.Data.SqlClient.SqlConnection'.
Here my connection string:
Dim testsearch_connection As New Odbc.OdbcConnection("Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=C:CesarAccessdatabase.mdb;Uid=admin;Pwd=;")
What am I missing?
View 1 Replies
Sep 2, 2009
I have a large project where we have 2-3 dll projects that are converted from VB6 to VB.NET. We have fixed all the issues that caused compilation errors, and most of obvious issues in running, so now we have basically a program up and running. The exe is created from scratch in VB.NET, using a lot of functionality from the converted dll's (including GUI forms). What I wonder is when I run the program in debug mode, I get a bunch of warnings in the "Immediate Window" saying:
A first chance exception of type 'System.Exception' occurred in Microsoft.VisualBasic.dll
...and some of other type (but most of them in Microsoft.VisualBasic.dll).I was wondering if this is common in projects converted from VB6, or if it is caused by bad design in our code...
View 2 Replies
Mar 4, 2010
I have developed a windows application which connects to Oracle Database and upload and retrieve data (using System.Data.OracleClient). It is working fine in my developement system. When I build a setup and deploy in another system, it is giving error that Oracle Client is missing.
Do I have to install Oracle Client in the client system to run my application?
(When I visit Oracle site for Oracle Client, it is asking me to download a 200 MB file)
Is there any other way to do this with out installing Oracle Client in the client system?
View 4 Replies
Jun 12, 2009
I am creating a application in VB.net. I've just managed to get a mssql connection going with the many people on this forum. I am now trying to establish a connection with Sybase server/db. Upon entering the username and password from my application front end, I get the following message:
[Code]...
View 1 Replies
Mar 30, 2009
I am creating a application in VB.net. I've just managed to get a mssql connection going with the rom many people on this forum. I am now trying to establish a connection with Sybase server/db. Upon entering the username and password from my application front end, I get the following message:
View 1 Replies
Aug 10, 2010
I'm getting 'Catch' cannot catch type 'Object' because it is not 'System.Exception' or a class that inherits from 'System.Exception'. and 'Expression detected' Code underlined in blue: Catch obj1 As Object When (?)
Private Sub OpenJAMem()
Dim num3 As Integer
Try
[code]....
View 2 Replies
Dec 22, 2009
I'm using express 2008 build the windows app. and in the app, it calls a webservice which was built by VS2003.It works fine on most PCs. however, there is one PC, it always shows this error:
System.TypeInitializationException: The type initializer for 'System.ServiceModel.ClientBase' 1' threw an exception
....
System.configuration.ConfigurationErrorException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException:
Unrecognized configuration section system.serviceModel
.....
however, the configuration file was generated by express 2008, and it seems there is no error.
View 2 Replies
