ADO: Yet another ora-12154 error.

Keywords & Tags: ora-12154, error, ado

ADO Related Links

ADO Hot Answers

• Identity using Table Adapter

  I'm using an access database for my website and have been creating table adapters as per the Data Access tutorials.However I can't work out how to return a new record's ID after inserting it since access won't accept multiple statements. I have a query in the tableadapter which i...

• Identity or Return value from table adapters.Update

  How the hell do you access the identity or return value from a stored procedure that is called by a tableAdapter.Update? I have the following code to add a new row to my db..DomainsTableAdapter Domain =newDomainsTableAdapter();UserManagementDAL.DomainsRow DomainRow;UserManagementDAL.DomainsDataT...

• IDENTITY INSERT with Access and ADO.NET

  I'm using ADO.NET (using a dataadapter update) to update data in an Access data table. One of the columns is an Autonumber column, but I want this column to contain the values I sepcifically want inserted, not the autonumbers generated. I know you can achieve this in SQL Server by using the...

• IDENTITY INSERT with Access 2000 and ADO.NET

  I'm using ADO.NET (using a dataadapter update) to update data in an Access data table. One of the columns is an Autonumber column, but I want this column to contain the values I sepcifically want inserted, not the autonumbers generated. I know you can achieve this in SQL Server by using the...

• Identity from Access

  Hi, I have been searching around for a solution to this problem with not much luck. From what I have read, I don't like the answer, but I thought I would check just in case.I have been given the impression it is impossible to retrieve the identity value from an Access database after an insert. ...

ADO New questions

• IDENTITY_INSERT with ADO.NET

  Hi there.I am trying to Sync 2 Databases (online db and the offline using web services)using the DataSet's Merge. The problem is merge method cant force IDENTITY_INSERT. How do I force IDENTITY_INSERT using ADO.net ?Below is my sample code :'========================================== DA = New ...

• Identity column wont let me autogenerate

  Hi,I'm using C# against MS SQL server. My table, "Contacts", has an "ID" column that is a primary key and Identity...simple int. When I try to add a row from my code, I'm getting a runtime error:"Column 'ID' does not allow nulls."Why do I need to provide an ID value when th...

• Identity Column in Datagrid

  Hello,I have an Identity column 'FormNo'...'autogenerated/seeded' column in my (SQL Server) database. I am using datagrid to display the records. My 'Insertvalues' with codebehind is working since the FormNo is automatically incremented on saving. But my 'Updat...

• Identity column and adding new row to an SqlDataAdapter's dataset

  If I add a new row to an SqlDataAdapter's dataset, will my identity column be updated immediately to reflect its value ? I have an identity column which also serves as a unique key and I need to be able to find the rows in a dataset by their identity after adding a new row to the dataset. ...

• Identifying the datagrid from where a control was clicked

  I have several Editable datagrids (dg_JOB, dg_CLIENT, dg_ACCOUNT) on the one form.How can I identify from which datagrid a particular EDIT,CANCEL or UPDATE control came?I'm trying to write a method to simplify all this datagrid business (in my own mind at least).Thanks in anticipation....

• Identifying row position on OledbDataReader

  HiIs there any way to identify the first row on a OledbDataReader?I know that I can use a int32 variable while reading a OledbDataReader but is there another way?Thank you very much.ofsouto...

• identify which cell did you click from the datagrid

  hello therei have 2 forms.. form1.aspx and form2.aspx and my form1 has a datagrid & command button to confirm , then i clicked 1 cell then after i click button to confirm the selected item then transfer to textbox in form2. is it possible?tnx.. need it badly.. thx!...

• Identifier int out of scope

  I'm debugging an application and I get this message: Identifier 'int' out of scope, but the datagrid cell has the value "4", and I'm trying to save it in an integer variable. Something like this:int cellvalue = int.Parse(e.Item.Cells[0].Text);Why can this be?...

• IDbCommand and other commands

  I find some are using IDb(like command,connection,...)what is the main difference between IDb and others (Sql,OleDb,Odbc)?should i use IDb or OleDb when i use oledb source?...

• iDB2Command parameters

  Hi all, I am trying to write an asp.net using vb and am having a problem adding a paramater. With the sqlcommand there is a method called AddWithValue this is not an option for iDB2Command. Without this option I have been unable to figure out how to add a parameter to the sql statement. I k...

ADO Related Categories

• ADO

• ASP.NET AJAX

• DotNet

• DotNet Asp

• DotNet Base Class Library

• DotNet C# (C sharp)

• DotNet Security

• DotNet Visual Basic

• DotNet Visual C

• DotNet Webcontrols

• DotNet Webservices

• NET Architecture & Design

• Web Forms