Browse by Tags

Related Posts

  • Re: Connection with oracle9i

    Hey buddy! The above link given by praveen is indeed very informative. As an addon to the explanation you can find a crisp example here:- 1 string ConnString = "data source=dsn1;user id=user1;password=pwd1;" ; 2 OracleConnection NewConn = new OracleConnection(ConnString); 3 string sql= "SELECT * FROM...
    Posted to Oracle (Forum) by veeaar on 03-29-2007, 12:00 AM
    Filed under: Oracle, example, oracleconnection, datagrid, oraclereader, c#, .net
  • Re: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

    System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersio n() at System.Data.OracleClient.OracleInternalConnection. OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity...
    Posted to Oracle (Forum) by Basaveswari on 04-18-2007, 12:00 AM
    Filed under: Oracle, .net 2.0, Web Services, VS.2005, SQLDataSource, oracleconnection, c#
  • Inserting dropdown list numeric value to oracle database

    Hi Everybody! In dropdown list i have 1. USA 2. Japan 3. UK Now, when i select on Japan, in the database say there is table name COUNTRY with column name ID. How can i store the corresponding country value in the ID column? I mean I have to store 2 when i select Japan. I would appreciate your suggestion...
    Posted to Oracle (Forum) by sthauttam on 04-19-2007, 12:00 AM
    Filed under: Oracle, .net 2.0, c#
  • Re: Inserting dropdown list numeric value to oracle database

    Wow! Excellent Thanks pixelsyndicate. thank you! pixelsyndicate: One suggestion: generate your SQL for the insert based on the value of the dropdownlist: protected void DropDownList1_SelectedIndexChanged( object sender, EventArgs e) { if (((DropDownList)sender).SelectedIndex > 0) { string sql = "insert...
    Posted to Oracle (Forum) by sthauttam on 04-19-2007, 12:00 AM
    Filed under: Oracle, c#, .net
  • Parameters in OracleCommand CommandText ?

    Hi I'm really hoping someone can help with this, I am trying to add parammeters to a sql statement that is inside a OracleCommand CommandText. I get them from the queryString initially, I know that in oracle you must put a : before the variable name What would the syntax of MyCommand.Paramters.Add...
    Posted to Oracle (Forum) by aidoco on 05-23-2007, 12:00 AM
    Filed under: .net 2.0, Oracle, OracleCommand, c#
  • How to write Commit trasction

    Note from moderator XIII : this message was moved from the Oracle forums : i have create Business logic layer i want to implement begin transaction commit transaction. if data is not properly updated -> Rollback trasaction thank you vijaya@jyothy.com
    Posted to Data Access and ObjectDataSource Control (Forum) by vijaya123 on 06-02-2007, 12:00 AM
    Filed under: C#, .net 2.0, Oracle, .net
  • "Specified slot number was invalid" when open OracleConnection

    Hi All, OracleConnection ocon = new OracleConnection (ConnectionString); ocon.Open(); I got the error message: System.ArgumentException: Specified slot number was invalid.\r\n at System.LocalDataStoreMgr.ValidateSlot(LocalDataStoreSlot slot)\r\n at System.Threading.Thread.GetData(LocalDataStoreSlot slot...
    Posted to Oracle (Forum) by lectrung on 06-07-2007, 12:00 AM
    Filed under: Oracle, .net 2.0, oracleconnection, c#
  • Re: "Specified slot number was invalid" when open OracleConnection

    If you have found the problem, for others who might get this error. It is likey a dll conflict. Some assemblies are using one version of the dll and others another. For example the ODP provider Oracle.DataAccess version 10.1.0.400 in one and 10.2.0.200 in another. Be sure you have referenced the same...
    Posted to Oracle (Forum) by tlstanlet on 07-31-2007, 12:00 AM
    Filed under: Oracle, .net 2.0, c#
  • OracleCommandBuilder.DeriveProperties throws OracleException "ORA-00942: table or view does not exist"

    A call to OracleCommandBuilder.DeriveParameters in my application is throwing the above Oracle error. The stored procedure within the command exists, so it must be a permissions issue. The .NET app connects to SchemaA, which has a stored procedure that references a table in SchemaB. SchemaB's user...
    Posted to Oracle (Forum) by jimbobmcgee on 08-13-2007, 12:00 AM
    Filed under: Oracle, c#, asp.net 2.0
  • Inserting Data into multiple tables in Oracle Database by pressing single "Insert" button in FormView

    Hi,I am totally new in ASP.NET.I have a query which may be very foolish to all of you but despite I'll be really thankfull if I get the answer urgently. PROBLEM: described in following steps... 1) I have 3 tables in database A) employees : containing columns :: (emp_code,emp_name,dept) B) emp_prof_qualifications...
    Posted to Oracle (Forum) by Tapamay on 08-17-2007, 12:00 AM
    Filed under: Oracle, VS.2005, c#, and SqlDataSource Control, asp.net 2.0
Page 1 of 2 (20 items) 1 2 Next >