VB With Oracle 11g Using REF CURSOR NOT Working?
Oct 28, 2011
I am using Visual Basic 6 to connect to Oracle 11g.Yes, I can successfully connect to the database.The problem is to receive the recordsets from the database.I have created an oracle package like below:
Package:
CREATE OR REPLACE PACKAGE PKG_BASECODE AS
TYPE T_CURSOR IS REF CURSOR;
--// customer
[code]....
And I receive an error something about parameters.The error message is written in Korean language, so I cannot write straight away.
View 1 Replies
ADVERTISEMENT
Aug 4, 2011
I have the following code:
Dim PageNum AS Integer = 1
Dim ThePageSize As Integer = 30
Dim RowCT As Integer = 0
[Code]....
When I try to run it I get:
"System.Runtime.InteropServices.COMException: Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype."
The error page points to "Objrs.AbsolutePage = PageNum"
what I can do to get around it? It would kind of really stink to show 500 records on one page.
View 1 Replies
Mar 4, 2010
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Replies
Dec 29, 2009
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 Replies
Jan 14, 2010
how can i make my cursor to jump to the next textbox after i type the digit
View 3 Replies
Feb 16, 2011
This VS010 solution is not providing my intended outcome as a custom override of a 'crosshair' or 'reticle' cursor e.Graphics.DrawPath() is the function that isn't working. This
WORKING solution demonstrates how it's supposed to work. The additonal PictureBox added to a Panel is, for reasons I don't understand, not allowing the 'new' cursor to appear.
Option Explicit On
Option Strict On
Imports System.Drawing
[Code]....
View 2 Replies
Apr 28, 2009
I have a user control, and want to be able to update its cursor while it is disabled. For example, say that I have a user control whose cursor is Default. The below code works ONLY when the user control is already enabled; if it is disabled the below code doesn't work and the cursor remains Default: Me.MY_USER_CONTROL.Cursor = System.Windows.Forms.Cursors.WaitCursor
View 3 Replies
Jul 2, 2009
How can I set the curosr to 'cursor.wait' for the whole display screen and not just for the application form? I have tried "Windows.Forms.Cursor.Current = Cursors.WaitCursor" And several variations but without success.
View 5 Replies
Nov 6, 2009
I have a custom cursor that I have as a ico file as cur files are only mono coloured and 32x32.
The only problem in using a ico file is that I can't set where the hot spot is and at the moment it is set in the middle of the icon which is no help
I was looking on the msdn website and it said to set the hotspot like this
Dim instance As Cursor
Dim value As Point
value = instance.HotSpot But I don't know how to set the point value to (0,54) which is where I want the hotspot to be located.
View 6 Replies
Jul 17, 2011
I am currently writing a custom control, for a future project. The control uses custom cursors, but sometimes this strange error appears: Code generation for property 'Cursor' failed. Error was 'CursorConverter' is unable to convert 'System.Windows.Forms.Cursor' to 'System.ComponentModel.Design.Serialization.InstanceDescriptor'.
[Code]...
View 9 Replies
Jul 2, 2010
i Use "Imports System.Data.OracleClient .. Private conn As New OracleConnection()" to connect to my Oracle database..but when i put my program to another PC I need install Oracle Client on it...is there some other way how to connect to Oracle DB without installing oracle client to client PC?? (Database is on Server an program is on client´s PCs)
View 2 Replies
Jun 6, 2009
can i put my own custom cursor in ? so when the cursor is over form1 its my own custom one ?
View 6 Replies
Sep 3, 2009
I found on msdn samples and modified (add Thread.GetDomaind.UnhandledException)
<SecurityPermission(SecurityAction.Demand, Flags:=SecurityPermissionFlag.ControlAppDomain)> _
Public Sub Main()
' Add the event handler for handling UI thread exceptions to the event.[code].....
View 1 Replies
Jun 18, 2009
It appears that my favorite thing in the world is tackling projects that are beyond my current knowledge and abilities. I have a little project that I am working on which is a simple image viewer stocked with (upon completion) your standard Load..., Next/Previous, Zoom In/Out, Actual Size, and Full Screen capabilities. However, I am running into a few snags:
(1) I've been able to get my "Load..." button to display a file dialog box, but I cannot seem to get a working filter (with which only image file types are allowed to be selected) in working order.
(2) I have a PictureBox object (entitled PictureBox1) that displays the image selected via the file dialog box, but it loads images in their full size (1:1/100% zoomed) state without scrollbars, etc. to allow me to navigate the loaded image. I would like to have it load the image, initially, to fit within the dimensions of PictureBox1 and from there be able to zoom in/out via my "Zoom In/Out" and "Actual Size" buttons and be able to scroll if the zoom level is beyond the dimensions of PictureBox1.
(3) It dawned on me that I haven't the faintest idea how to get my "Next/Previous" buttons to allow the user (me) to navigate, in succession, the images contained in the folder in which the currently loaded image is stored. [code]
If it is deemed that this thread is inappropriately requesting help, I ask that it be locked/deleted quickly as I recognize that this is a large community with many discussions going without need of unwelcome posts.
View 9 Replies
May 7, 2010
i just want to ask a question.. what connector does oracle 10g uses?
View 3 Replies
Apr 2, 2011
I'm making an app where people need to log in, these data are on a Oracle 10g XE DB, I know how to access the data, but I don't know how to validate is the query returns something or doesn't (to validate the username and password, of course). I'm using an ODBC with VB.net to connect the DB.
View 1 Replies
Jul 20, 2010
I need to connect oracle to a .net application
View 3 Replies
Aug 27, 2009
how to connect oracle 8i in vb.net...what is the procedures for connection?
View 1 Replies
Apr 21, 2010
Currently we are using the Microsoft data access library Writen with a Oracle data provider for the framework 1.1. My customer has mandated that we upgrade from Oracle 10G to 11G release 2. 11G requires the .net framework 2.0 Is there a way to use the new Oracle data provider 11g release 2 with the older frame work. I have looked at/attempted changing the policy for oracle in the Windows assembly but my understanding is because its a third party DLL, I cannot.
View 4 Replies
Mar 27, 2012
I have put my tns connection into the .ora file and am now able to conenct to it using SQL plus and can ping it :tnsping myConn.I've also added the connection to the ODBC Manager and connecting successfully when tetsing conneciton through the ODBC tool.now i'm having an issue making a connection to it using vb.net..[code]
View 3 Replies
Jun 7, 2010
The Oracle.data-access reference dll is missing in my reference.How do I make get this dll or is there any other way to connect to oracle 10g.
View 2 Replies
Mar 6, 2009
i noticed in vb.net that when declaring new connection objects it creates a new session. and sometimes it reuses an existing one.is this an expected behavior?
in my application i created a global temporary table. in oracle, this acts like a table but session based. the behavior mentioned above is causing some issues with my temporary table as new sessions are being created and thus, i'm not able to get the desired data from the table.i thought of using a global connection but not sure if this is the best way.
View 4 Replies
Nov 4, 2009
how to use next & previous button in vb.net to get records from oracle xe code for getting records from database when next is pressed?
View 1 Replies
Apr 7, 2011
Today is my first day trying to use Oracle databases in Asp.NET so I have no idea of what I need to do. I have added this code
[Code]....
View 2 Replies
Aug 22, 2011
I am seeing a strange intermittent connection failure. My application works just fine and then starts throwing connection failure exceptions. A reset of IIS is required before the app will start working again.I've been able to trace a few of the failures back to an unexpected restart of the oracle cluster but not all of them. Has anyone else seen this problem? I've searched the web but haven't found anything.
Client - Win2003 server, IIS running ASP.net 2.0.50727, code is VB.NET, ODBC connection via Oracle Client 10.2.0.1.0 Server - Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production on a Linux cluster.
[Code]...
View 4 Replies
Nov 10, 2010
I have a few Oracle procedures that generate/return a large amount of data that I need to write out to a file.I'm currently trying to accomplish with a data-reader. It seems to be working, I've successfully generated a 479mb file without any trouble.It took less than 4 minutes from the time I retrieved the dataReader to complete the file.But the dataReader I get for a particular procedure is crawling.It's unbelievably slow.I modified my code to try and get a better idea of what is going on[code]I'm writing a PL/SQL block that will open that cursor to see if the performance issue exists when I remove the .Net code..
View 3 Replies
May 6, 2010
why can't i find oracle.dataaccess.dll in the .net tab of reference window in vb.net?
View 7 Replies
Apr 3, 2012
I receive the error below when running the following function. The catch says the line where it opens the connection (Me.OracleConn.Open()).
I have made sure that the server exists in the TNSNAMES.ora file.
Imports NetOracle = System.Data.OracleClient
...
Private Property OracleConn As NetOracle.OracleConnection
...
Private Function Connect_To_Oracle() As Boolean
[Code].....
View 2 Replies
Jan 25, 2010
I would like to change the Name of the oracle Db. How can i change it.if i change the database name what are the things i have to keep in mind.Will it Affect any system files or oracle dll files if i create wrongly.Will the name of the Db be same for all the Oracle 9i s/w?
View 1 Replies
Feb 28, 2011
I am after running into a problem with a project I am currently working on. I am trying to connect to an Oracle DB. I am running Oracle 10g Express.
Imports Oracle.DataAccess.Client
Module GlobalDefs
Public strSQL As String
[code].....
View 6 Replies
