I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID
1 5
2 8
3 5
[code]....
I will try and explain my problem as simply as I can
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
CODE:
What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.
I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.
Below is the code for doing this in the same datasource:
Code:
I am using VB.Net 2005, just for info
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID1 52 83 5
e.g. SQL Table name DispTbl
[Code].....
I am using the following Select Statement to retrive data from my .csv file database:
Code:
Dim comm As New OleDb.OleDbCommand("Select *, Left([Street Full Address], IIF(InStr(12,[Street Full Address],'-')>0, InStr([Street Full Address],'-')-1, Len([Street Full Address]))) as StreetFullAddress From " &
[Code].....
Im writing a simple VB program that connects to an oracle DB which retreives and inserts data to a table I created.[code].....
I want to be able to search through a table I have created to store all the information.Rather than just searching for one variable which would be easy to do, I want to give the user the option to filter out the search from the form.So say the user hits "Find", they would be given access to 10 comboboxes, they would select the information they want to search for (They do not have to select every box) and then click "Do Find".Then the form would display all the results of the query in the form.
In my code I have an Oracle command that contains an INSERT statement. Here's a snippet from my SQL:
"'," & "To_Date('" & Format$(dtDateTime_Stamp, "MM/dd/yyyy hh:mm") & _
The value of strDateTime_Stamp is #1/19/2011 9:42:22 AM# I'm getting an error ( "ORA-01830: date format picture ends before converting entire input string") because I don't know how to correctly assign the AM/PM tag on the end -- you'll notice it just says "MM/dd/yyyy hh:mm" in my code. I've tried a bunch of different things but nothing works. I also find it odd that if I change the "MM/dd/yyyy hh:mm" to "mm/dd/yyyy hh:mm" (little m for month) it gives me a 42 for the month value, not a 1. The capital M's fix that but I'm curious to know why.how to I get it to show the AMPM on the end?
anyone know a good free reporting tool compatible with oracle database and visual studio express?
View 3 RepliesI have the following insert into statement. What I want to do is insert the values to gprdsql.TblOracleNos if TxtOracleNo is not empty, therefore if a user logs on and fill the textbox the values are saved to the table. However, if the oracle number exists in gprdsql.TblOracleNos (i.e, the values ) it should not insert the values, presently it creates the same record again with same values (when the save button is clicked) and this creates duplication. Instead probably bring a pop up message "Oracle number already exists. [Code]
View 6 RepliesI have a textbox and a datagrid. I am trying to enter a last name into the textbox and have that return the entire record from that last name into the datagrid from an oracle database. The code below currently returns all records in the table and is not searching by the last name. Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myString As String
[code].....
Currently working on a web-service with Oracle10g as back-end. Here is my problem.
1. The table I need to populate has 100 columns. I have no control over the design of the table.
2. I wanted to use the "deriveparameters" method of OracleCommandBuilder, but found out that this is "costly" in terms of performance. What I initially planned to do was to derive the parameters from an open connection, close the connection, then maybe cache the parameters obtained but I don't know if this is possible.
I am unsure how big of a hit the performance will get if I continue using the "deriveparameters" method WITHOUT caching the parameters driven. The environment is as follows
-intranet
-around 2000 users
-users spread out in different parts of the country
I am not familiar where they will put the web pages of the application, the web service and the database. I don't know if they'll be putting it in different servers or on one server, but that's something we cannot control too, that's why I am looking for the best approach.
I just don't want to hard-code all that parameters and if, for instance, we need to change some properties/parameters, it will be a pain to maintain the code. It would be nice if someone here can point a way to automate the whole thing w/o the performance of the system taking a hit.
I have a stored procedure on an oracle database called : GET_HVE_PACKAGE_VERSIONS This basically calls versions of PLSQL packages as stores the versions into a table. I am having big problems trying to call this procedure. I have tried everything. I am currently able to create and update etc etc using the executeNonQuery method and I thought that I would be able to call a procedure them same way, obviously not
the whole project depends on me being able to call procedures against the database.
[Code]...
I have a copy Oracle 11g which is now fully installed. Will it work with Visual Basic Express 2008 or just Visual Studio 2008 Professional? I have both Visual Basic Express 2008 and Visual Studio 2008 Professional. I really would like to know if it works with Visual Basic Express 2008.
View 2 RepliesI recently upgraded my system to Windows 7 64bit and ever since then I have had nothing but issues with my code attempting to access an Oracle database. I was using msdaora for my connection string however that does not work in 64bit. I changed over to OraOLEDB.Oracle which everything I can find on Google says to use however it fails every time. I have installed Oracle 11g 2 times now and even tried reinstalling VB.net 2010 and still no luck.
Here is my connection string....
Code:
MyConn.ConnectionString = "Provider=OraOLEDB.Oracle;Server=emsp.grhq.XXXX.com;Data Source=emsp;User Id=XXXX;password=XXXX"
And I am inporting....
Code:
Imports System.Data.OracleClient
Yet when I try it says...
Quote:
Provider cannot be found. It may not be properly installed.
I'm using Vb2005 and Db MS access Is it possible to use tow Select in same sql Statement like this example:
Code:
"Select....Select......."
I have the following Stored Procedures create or replace PROCEDURE WEB_AC
[Code]...
First one: At some point in the application I have the valor parameter (of the visual Basic Function) as a string with spaces that is something like "some string with spaces". When this happens, the stored procedure don't update the table. If I execute the SP directly in the DB (with SQL Developer) all works fine. I know it has something to do with the string missing some quotes(') but I haven't make it work yet. Some ideas on this?
Second problem: Sometimes, when debuging the application, if I interrupt the execution, I start getting the ORA-24338 'statement handle not executed' error for hours every time I try to execute it again. I believe it has something to do with an open transaction. But honestly, as I'm new in working with Oracle, I really have no idea what the problem could be.
[Code]...
"INSERT INTO Images (PicName) VALUES (" & TextBox1.Text & ") WHERE ImageID = " & Summary..if i run the statement without the WHERE clause it works fine, with it i get the error ' Missing ; at end of SQL statement'
View 4 Repliesi would like to ask if how can i call this SQL statement in my crystal report. im using Crystal Report 10.
Code:SELECT IF(out_balnce < 0, CONCAT(""("", FORMAT(ABS(out_balnce),2) ,"")""), FORMAT(out_balnce,2)) AS OutBalance, IF(acct_side < 1, CONCAT(""("", FORMAT(tran_amnt,2) ,"")""), FORMAT(tran_amnt,2)) AS TransAmount, user_code FROM LedgerHistory WHERE srvc_nmbr = '12345678' ORDER BY srce_date desc how can i place TransAmount and OutBalance in crystal report?
I have 2 functions that need to work together.1 function is to generate a chart number. The other function is to search via SQL to see if the chart number exists. if the chart number doesn't exist then i need function 2 to return a boolean value so function one can generate a new chart number example code: [code] Now i know that i am probably using the incorrect sql statement, my main issue is that i dont know how return available back to the function.
View 1 RepliesI try to update my data into Access using VB but I got the following error "Syntax error in UPDATE statement." [code]
View 4 RepliesI use the following code to add a record but get the error:"Missing semicolon ( at end of SQL statement. " I removed the semicolon, placed it before the SELECT but it seems to continuously cause problems.
Quote:
Public Sub AddAccountRecord(ByVal name As String, ByVal type As String, ByVal user As String, ByVal balance As String)
Dim strSQL As String
Dim objConnection As New OleDbConnection(strConnection)
Dim objCommand As New OleDbCommand(strSQL, objConnection)
[code]....
I'm running into a slight problem with an SQL INSERT INTO statement. I've tried setting this up first as a command statement and now as a stored procedure. When the process runs it's not signaling any errors and it appears that it's working properly. However when I check the database nothing new has been added. I have the statement within a try catch and it's not catching any errors. I've gone so far as to delete the table and recreate it, still nothing. I should also point out that this entire statement was essentially a copy & paste from another program that's working perfectly.
vb.net code below
Code:
Try
Dim cmd As New SqlCommand
cmd.Connection = con
[code]....
How do I list the SQL statement in my crystal report. I have the report loaded etc using
Dim DA As New SqlDataAdapter
Dim DS1 As New DataSet
DA.SelectCommand = New SqlCommand(gSQL, SQLConn)
DA.Fill(DS1, "JobID")
Dim CR1 As New ShowFiles
cr1.Load(gActiveReport)
cr1.SetDataSource(DS1.Tables("JobID"))
CRV1.ReportSource = cr1
This shows my report But how do I reference the SQL Statement, I can see in in report design but cant find it in the loaded report
I build a command.text that looks like this.
UPDATE a_list Set NOTE = 'This is text in a memo type field.' where index = 2;
I get the error --- Syntax error in UPDATE statement.
The provider is jet and the table is in an ACCESS MDB. I get the same thing on a DBF file.
I keep getting the following error when inserting in to my Access DB using VB.
THe code I use is:
Code:
Dim code As String = "INSERT INTO tblUser(Username, Password, Forename, Surname) VALUES('" + txtrEmail.Text.Trim + "','" + "dfd" + "','" + txtrForename.Value.Trim + "','" + txtrSurname.Value.Trim + "');"
[Code].....
I got the sql code to write in a text box and executed i manually in to Access DB and it works perfectly.
I keep getting this error "Syntax error in INSERT INTO statement." on this line "da.Update(ds, "Llenar")" when i try to update a microsoft access 2003 database with this app.
Code:
1.Imports System.Data
2.Public Class A�adir
3.Dim coneccion As New OleDb.OleDbConnection
[code]....
What iam trying to do is selecting rows on multiple column values. But the statement below doesn't preform like i thought it would...
Code:
Select Distinct Variable From TableName Where (ColumnA Like"%AAA%") And (ColumnA Like"%BBB%")
I have developed an ASP page in Visual web developer that retrieves the data usingan AccessDataSource object. I have the following UPDATE Command:
[Code]...
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 RepliesI 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 Repliescan 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