Forum Topics Tagged [oracle-11g]

Hello Everyone I want to take a backup of the oracle database using c# am using the code below but give this error: System.InvalidOperationException: 'The Process object must have the UseShellExecute property set to false in order to redirect IO streams. any help please????????? System.Diagnostics.Process p = new System.Diagnostics.Process(); string strexp = "exp userid='system/M19871991b@orcl as sysdba' full=yes file='c:\qw.dmp'"; p.StartInfo.FileName = "cmd.exe"; p.StartInfo.UseShellExecute = true; p.StartInfo.RedirectStandardInput = true; p.StartInfo.RedirectStandardOutput = true; p.StartInfo.RedirectStandardError = true; p.EnableRaisingEvents = true; p.StartInfo.CreateNoWindow = true; try { p.Start(); p.StandardInput.WriteLine(strexp); p.StandardInput.WriteLine("exit"); p.WaitForExit(); MessageBox.Show("s"); } catch (Exception ex) { throw ex; }

Hi Group, I'm attempting to pull info from our database to populate a combo-box in VB.net (Visual Studio Express 2015). Here's my first attempt at the connection: Dim conn As New Oracle.DataAccess.Client.OracleConnection() conn.ConnectionString = oraDB From here I'm not sure how to pull the data into the combobox. I do have my code written to find the information: Dim sql As String = "select dw01.RP_ID" _ & "from donacwil.RATE_PLANS_SSB dw01" _ & "where dw01.PROP_ID in ('" & propID & "')" _ & "And dw01.DW_RCRD_STS_CD in ('A')" _ & "Order by dw01.RP_ID" Does anyone know what to do from here? Thanks …

heY guys, I just step to oracle database system. so I'm new to this. I'm trying to make connection oracle db with vb.net. I saw below connection string on web. But I dont know it's keywords. So please teach me. SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID))); uid=myUsername;pwd=myPassword;