23 Topics
 | |
| | I wonder if there is any solution to drop an oracle table trigger using c# windows application project |
| | 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 …  |
| | Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here … |
| | I had c# application that has registration form and another from that user use to sigin in into my application i wonder how to check if user its register or not my login form has to textbox username and passpwrd and im trying this code i gusse its wrong can … |
| | hi all I had make this samll method to insert data from c# forms into my oracle database the code processed fine but when I go to sql developers software to check if the record has been inserted or not I found nothing... so whats wrong with it please thanks … |
| | Hey everyone I need some urgent help please. I don't know how but I need make a Time Dimension of an Oracle Table using c#. What needs to happen is: -I want to use Order_Table's Date Column to Create a new table Time_Dim with columns OrderID, Year, Month, Week, Day. …  |
| | Hi everyone I need help please. I need to create a Time Dimension of an Oracle Table using C#. I have no idea how to do it. Any Suggestions? Thanks in Advance |
 | Does anyone know how to connect an oracle object oriented database to c#? Using ADO.NET Entity Data Model, i see just relational tables, and i need to work with object tables. Thank you verry much! |
| | I used following code to connect oracle database from C#. But i get this error "**invalid login credentials**" using (Oracle.DataAccess.Client.OracleConnection cn = new Oracle.DataAccess.Client.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;") { cn.Open(); } While if i try following code to connect database from C# I succeed. using (System.Data.OracleClient.OracleConnection cn = new System.Data.OracleClient.OracleConnection("Data Source=abcSource;User Id=abcUserId;Password=abcPassword;")); … |
| | I have the following code for connecting to an Oracle DB [code] using Oracle.DataAccess.Client; // C# ODP.NET Oracle managed provider OraDb= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=ORCL) ) ) string oradb = "Data Source=//192.168.100.108;User Id=hr;Password=hr;"; // C# string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=hr;Password=hr;"; …  |
| | Hellow. I have 3 variables 1. string query; 2. public static OracleCommand oracmd; 3. public static OracleDataReader reader; I have used these variables in a function [CODE=C#] . . . public void PreviousValue() { query = " select * from....... "; oracmd = new OracleCommand(); .... .... reader = oracmd.ExecuteReader(); … |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : …  |
| | Hi Guys, I am trying to make a connection with Oracle 11g which is installed on a server 2008 BUT have problems with the ConnectionString. Could you please let me know how I set a correct connection String while I have parameters like these: Database name: GISData Server Name : …  |
| | Hello, How to run command SQLLoader Oracle in c#. I try my sourcode for run this SQLLoader, but nothing happen and error "No process is associated with this object.". Please tell me how i fix it. Thanks. This is my code: [CODE] System.Diagnostics.Process process1; process1 = new System.Diagnostics.Process(); process1.EnableRaisingEvents = … |
| | please help me to solve this problem,i want to insert data by checking the multiple entries in my form and retrieve the same data, the check box must checked the corresponding field retrieved. |
| | Hi I am getting weird error with oracle connectivity. Immediately after the open() call, the connection shows as closed. I am not able to figure out whats going wrong. The same code works if executed differently. Line: This piece of code throws error [CODE=syntax] bool objState = false; if (Program.orConn … |
| | Hi I use the following code to connect to an orace database in Visual Studio 2008 and it is falling over with the exception of ServerVersion threw an invalid operation exception at line 3: [CODE=C#]m_strConnectionString = Settings.GetMandatoryConfig("databases", "SourceDB"); m_strQueryTerminator = Settings.GetConfig("databases", "QueryTerminator"); m_odbConn = new OleDbConnection(m_strConnectionString); m_sql = new SQL(DatabaseType.AnsiSQL, …  |
| | I am trying to accomplish a Master Detail Display here. The master item is ProductName and Child items are the details of the Product. Example: Dell Desktop V305 - Model: Black - 23877487y24y - Mother Board - Intel .... - RAM - 3 GB DDR HP Printer - Ink Jet … |
| | I am trying to accomplish a Master Detail Display here. The master item is ProductName and Child items are the details of the Product. Example: Dell Desktop V305 - Model: Black - 23877487y24y - Mother Board - Intel .... - RAM - 3 GB DDR HP Printer - Ink Jet … |
| | Hi, All. Actually i m creating a program using C# which connects to the database (oracle) and checks for the given table "OPC_GROUP". if the table doesnt exists then it creates the table else it updates all field with provided values I used following command to query [CODE]cmd.CommandText = "SELECT … |
| | hello all, for few days i have been trying to connect with my oracle 9i database with visual studio 2005 using c#. i tried all the processes that i found in internet. but i fail to connect with my oracle database. i have service named GLOBAL USERNAME: first password: first …  |
| | I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when … |
| | Hi All, I'm trying to call a parameterized stored procedure in C# using microsoft ODBC .NET. Could you please give me some help or hint? Thank you very much! C# code: ... //connection code odbcCommand.CommandType = CommandType.StoredProcedure; odbcCommand.CommandText = "BEGIN myProc(?, ?); END;"; odbcCommand.CommandTimeout = 0; OdbcParameter paramA = odbcCommand.Parameters.Add("@A_CNT", … |