Application Connecting Oracle Database On Ibm Aix
Jul 5, 2011want to know how to connect database from window2008 server platform to ibm aix database is oracle 10g ..please anyone can help me here
View 2 Replies
ADVERTISEMENT
Asp.net - Connecting To Oracle Database
Apr 7, 2011Today 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]....
Published Application - Connect To An Oracle Database On The PC
Dec 2, 2009I have a vb.net application that will not connect to an oracle database on the PC that I publish the app too. It works fine under my pc both in design and when I publish it to myself. But it will not connect under the pc I publish it too. I do have oracle installed on the pc and have the connection setup exactly as I have on my own pc. I am sure it is a file path issue, or at least I believe it to be that.
View 5 RepliesConnecting To An Oracle DB Through VB 2010?
Feb 28, 2011I 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].....
Connecting To Local 10g Oracle DB?
Nov 3, 2009I am trying to connect a simple VB program (Form, button and label) to my local oracle 10g XE and keep getting errors. The most recent errors is the TNS listener
"Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified "
Here is what I have done:
Went to control panel > odbc and created a connection to 10g XE and called it:
oraconn (this was from other tutorial so it is not used in code but still resides)
Copied tutorial about connecting to oracle and have the following code:
Imports System.Data
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
[Code].....
Change Application Database From Access .accdb To Oracle?
Nov 22, 2011i have an application with access .accdb as backend.How can i convert the backend to OracleBL (Visual Studio 2010 Ultimate)
View 3 RepliesConnecting To Oracle On 64 Bit Machine With 32 Bit Client?
Apr 30, 2009I need to have a 32 bit oracle client installed my test PC which is acctually a 64 bit machine.when i try connecting to oracle in my window application in vb.net ,it does not open the connection.
Imports
Oracle.DataAccess.Client
Public
[Code].....
Create An Autonumber In Oracle Sql After Connecting?
Apr 20, 2009how i create an autonumber in visual basic statement for an oracle database??
View 1 RepliesApplication Development Connecting To A Database?
Apr 8, 2009With Use of VB.NET, SQL Server, ADO.NET How can I develop an application for video rental management with the following specifications:
1. Keeping track of available videos
2. Accumulating surcharges for detailed videos returned
3. Warning subscribers through emails when rental period expires
4. Generating monthly report for the transactions
Special respect to extended functionalities such as reports on customers with surcharges when two dynamically specifiable dates are entered
Oracle - Connecting Oraclewith 2010 In Window 7
Dec 13, 2011I have installed Visual Studio 2010 and Oracle 11g in my Window 7. Oracle seem to be fine because i can connect to System user, Create user and create database. But the problem is that I can not connect the Oracle to my VB.net project and there is no System.Data.OracleClient Namespace. Do I need to install Oracle Client in my computer even though i have installed Oracle Server?
View 2 RepliesSQL Select From A Table In An Oracle Database, And Show Results Of Query In VB Application
May 14, 2009I want to (SQL) select from a table in an Oracle database, and show the results of the query in the VB application, in a Excel like manner (rows, columns, selectable, etc.). Or in a SQL developer manner. How can I do that? Browsed through a lot of tutorials and howtos on the internet, did not get anywhere. I think (and correct me if I am wrong) that it's gotta be something with DataGridView. But I don't know how to create and populate a datatable with the result of as Select statement, how to create a dataset.
View 3 RepliesInstalling Application On Another Computer / Not Connecting To SQL Database?
Apr 22, 2012When I try to install the application from the files it produces when I follow the prompts from Build - > Publish (Visual Studio 2010) onto another computer, and then run the application on the other computer, it wont connect to the SQL database on the original computer. I've been receiving a timeout error or one which says it can't find the server.I have no idea where to start looking to fix this, both computers are running XP and 4.0 .NET Framework. The computers are linked on the same network.I think my connection string is the culprit, but I don't know how it should be set up to run on multiple computers. Here's my connection string:[code]The connection string works on the application I've installed on the original computer, but not the second computer I've tried installing the application on.My second thought was that it could be the server which is wrong, I've just used the name of my computer for that, is this correct? I thought it may be because all the computers are connected on the network.
View 3 RepliesApplication That Runs Queries From An Oracle Db?
Dec 27, 2010I have a problem related, not only to VB.net, but also Oracle.I have a simple application that runs queries from an Oracle db (Oracle 9i) and creates reports from it. I am using the official oracle.dataAccess component.I need a very simple report that returns a list of usernames. Something like "SELECT userName FROM users".(userName field is a VARCHAR2).Problem with this query:The top 50 rows are OK.All the remaining are strange characters.
[Code]...
Create Table In Oracle By Using Ado.net From .net Application
Jul 27, 2009I want to create Table in Oracle database from my asp.net application by using ado.net
View 1 RepliesSql - Retrieve Oracle DBMS_Output From A Application
Aug 4, 2010I'm working on a vb.net application that executes an Oracle stored procedure. The stored procedure displays a value using dbms_output.put_line. How do I retrieve that value from the oracle database into my vb.net code?
View 1 RepliesChanging The Database Name Of Oracle?
Jan 25, 2010I 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 RepliesOracle Database Back Up Using VB
Jun 27, 2011How can i take back up on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example
View 5 RepliesOracle Database Backup Using VB
Jun 10, 2011how can i take backup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example.
View 11 RepliesDynamic Connection With Oracle From Application In Windows CE 5
Nov 21, 2009I'm starting using a project for smart device in windows CE 5. I'm using visual basic of v. studio 2008.I need to create a dynamic connection between a PDA (codebar lector) and an server with ORACLE 9i. The PDA connected via WIFI. But in my vb project I don't find OLEDB or ODBC elements.
View 2 RepliesBinding Data From Oracle Database
Apr 25, 2009I developed an application with old VB form and binding the data from Oracle database into VB form. Actually, I tried to bind the data more than 35000 records in to grid. But, it takes more than half an hour and also form was hanged and there is no output. Can you please let me know the solution to fix it and bind the data without any hang in my application. What are the steps to be followed to fix it?
View 1 RepliesConnect To Oracle Database In Program?
May 12, 2011I have some deprecated code in visual basic when connecting to an oracle database. I am using a OracleDataAdapter but it says that this has been deprecated. Does anyone know what the new supported code is to connect to a database?
View 2 RepliesCreate Oracle Database For MS Platform?
Aug 2, 2011I'd like to test Oracle database connection via web service. Could I create Oracle database in MS development environment? Oracle version is 10.2... is it Oracle 10g. I'm familiar with MS SQL Server. Oracle is new for me.
View 1 RepliesCreating Connection To Our Oracle Database?
Jan 19, 2011I've been viewing the tutorial at [URL]...08-088541.html but I'm still having issues creating my connection to our Oracle database. Here's my code, which uses the same connection string as one of my VB6 programs (no password required for database--Oracle picks up windows name) :
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Create connection object
Dim OraDB As String = "Data Source=databaseneme;Persist Security Info=False"
Dim conn As New OracleConnection(OraDB)
conn.ConnectionString = OraDB
conn.Open()
Me.Show()
End Sub
I've been using .NET for all of 10 mins so the error may be painfully obvious!
Import Oracle Into Database Explorer
Mar 25, 2009I am creating a Reporting program in VB 2008. The first issue that I want to correct is in VB 2008 there is a Database Explorer. But whenever I try to create a new Data Connection in the Database Explorer it does not give me the option to connect to Oracle. How do I get my Oracle Database in the Database Explorer tab. All it gives my options for are Microsoft based database applications.
View 3 RepliesOracle Command Creating Database?
Mar 15, 2012I have this in creating table but did not work. Having invalid table name error.
Imports Oracle.DataAccess.Client
Imports Oracle.DataAccess.Types
Public Class dump
[code]......
Update Oracle Database In Vb Error?
Apr 22, 2010I want to update a particular row in the database table but no success,i keep on receiving this error One or more errors occurred during processing of command. ORA-00907: missing right parenthesis
Cmd = New OleDbCommand("UPDATE SUB_DETAIL SET (LECT_ID = " & TextBox3.Text & ") WHERE SUB_ID = " & cmb_subID.Text & ")", con)
con.Open()
[code].....
VS 2008 Connect To Database (Oracle 8i)
Aug 29, 2010If the following is my code in VB6 to connect to Database (Oracle 8i) then what would it be for VB.Net (VS 2008)....?
[Code]....
Bulk Insert From Datatable In To Oracle Using Oracle.DataAccess
Mar 4, 2010I 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 RepliesVisual Basic With Oracle Provider Oledb For Oracle?
Dec 29, 2009can 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 RepliesOracle Database - Multi Threaded Implementation?
Mar 12, 2011I have written a rather complex dll for processing a large volume of data (~4,000,000 records) from an Oracle database. It works well, but takes about 23 hours to run.Since I wrote the code fairly compartmentalized I realized that there are 6 routines that should be able to run concurrently, and I have a multi core processor,I decided to try my first multi-threaded implementation.
In the routine I am working on I am doing no I/O everything is in memory in variables. My data is already in dataTables and hashTables. Most of the data is defined as private in the class scope, but no conflicting updates should happen because the code segments works very distinct portions of the dataTables.The concept is simple, I have 2 routines that need to complete before launching my threads, and one routine that needs to run after all of the threads have completed. Here is what I am trying;
ProcessDXDate()
ProcessHistology()
aryThreads(0) = New Threading.Thread(AddressOf ProcessLaterality)[code].....