Question about Computers & Internet

1 Answer

Record insertion filure in database

While entering the data i am getting the problem

Posted by on

  • Anthony Perez
    Anthony Perez May 11, 2010

    What software are you using. SQL?



1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert who has written 7 tips or uploaded 3 video tips

  • Master
  • 829 Answers

First check the data against the database field definitions to make sure you are not violating the database schema.

Second, find a Database Management Systems expert that is in charge of your database (if one exists) and ask them.

Third, try finding the error in the database manual.

Fourth, go to the web site for the company that produces the database and use their search engine to locate the error.

One of these should work.

Posted on Dec 17, 2008


1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

4 Answers

I have a database in mdb format that will not open. When I try to open the file I get an error: The Microsoft Access database engine stopped the process because you and another user are attempting to...

You can use Recovery Toolbox for Access developed for recovering data from corrupted Microsoft Access databases. The MS Access recovery tool is capable of repairing MDB and ACCDB database files.

For more:

Dec 01, 2015 | Microsoft Office Professional 2007 Full...

4 Answers

Damaged mdb 2010 file gives strange error message

First one apply short guide, second make use of MDB Open File Tool
· Launch the Microsoft Access application, but do not try to open the corrupted MDB file.· Go to "Tools" in the top menu bar, expand the "Database Utilities" submenu and select the "Compact and Repair Database" option if you are using Access 2002 or 2003. If you are using Access 2007 or 2010, you can find the "Compact and Repair Database" option by clicking the Microsoft Office button and going to the "Manage" menu.· Highlight the MDB file that you want to restore and click the "Compact" button.· Enter a name for a new database file, which will contain the restored data from the damaged MDB file.· Navigate to the location on your hard drive where you want to save the restored version of the file.· Click the "Save" button. Access will now compact and repair the MDB file and save a restored version in the location you selected.

Jun 23, 2015 | Microsoft Access Computers & Internet

2 Answers

Printing syntax

'declare the variables
Dim Connection
Dim ConnString
Dim Recordset

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _

'declare the SQL statement that will query the database

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
End If

'close the connection and recordset objects to free up resources
Set Recordset=nothing
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

Database talks to code but code won't talk to database

Make sure you are connecting to the database,then just before you call your sql to insert use an echo statement to display the sql and check it for syntax:-
$sql = 'insert into table1 values('.$no.','.$no.',"block","'.$value3.'", "'.$value4.'")';
echo "SQL ==>" STARTOFSQL<br>".$sql." ENDOFSQL<br>";

Jan 18, 2009 | The PHP Group PHP

1 Answer


Excel is a spreadsheet - it is less structured than a database and all of the data appears on one (or more) pages along with many calculations and summaries of data.
A database is structured so that all the information is kept in the same format for each member record of the database - Databases are better at processing larger volumes of information.
Some tasks can be performed equally well in either spreadsheet or database -
Often data is stored in a database but analysis is done in the spreadsheet.

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

Sansa e200 shows refresh database fail

try putting it in MSC mode and formating it and then putting back on MTP mode. Hope that works

Aug 24, 2008 | SanDisk Sansa e250 MP3 Player

1 Answer

Data storage form

If you give me a bit more detail about what you're trying to do, I would be happy to help.

I think you are interested in building a form that will add records to a database. Am I correct?

Tell me the language you are using, and the type of db. I know you are interested in SQL, but perhaps you are using Access.

If I guessed you are trying to create a web form that adds records to a database would I be correct?

The more detail you can offer, the more I can be of help.

Best Regards,

airoff (Alan)

Jul 17, 2008 | Microsoft Windows Server Standard 2003 for...

1 Answer

MS Access and application

You probably need to be inserting the value of a text object (ie, a String) , not the object itself. In VB.NET, a String object is an actual, not unlike a Java String object. In "classic" VB, a String object isn't really handled by the interpreter as an object in the C# / Java sense, so it can be referred to directly without resolving the value via a method call. So attempting to insert an object reference into a database field from C# code will probably not work unless the database knows to call toSting() on the object, which I am 99.99999% sure it cannot (depends on the database-- in this case Access, and more particularly, what version you are using, and if there is any .NET framework interoperability).

Calling myString.toString() though returns a String object in C#, so using that is likely not going to work. What you may need to do is return a character array using the 'chars' and 'length' properties of the C# String object.

Finally, after all this, your problem could be a lot simpler: the value(s) you are trying to insert may not be right for the field-- check the length of the values being inserted, etc. Use .trim() to eliminate leading and trailing whitespace, for example. If you post your INSERT statement and an example of the data you are using, I may be able to tell you more. Also, you are in ASP.NET and data transfer from web containers to Access databases is notoriously bedeviled work.

Mar 07, 2008 | Computers & Internet

1 Answer

Table not gettin updated

Generally database updates either require a commit to have the database perform the appropriate checking and actually flag the rows as part of the database. That Commit can occur in two ways -- some databases can be setup with an auto commit or auto rollback when the database is disconnected. The first means the programmer needs to do nothing. The second means if the programmer does not commit the updates are backed out of the database. To commit is generally considered bad because if there are any data errors partial transactions and logically inconsistent contents can exist in a database. For example entering an order for merchandise requires a single header row to identify the customer and multiple items rows to indicate what was ordered. If the third item record added to an order had an error and the application did not rollback and the database auto committed and incomplete order with only two items would be saved in the database. Traditionally databases with an automatic action at shutdown are set to rollback to assure such partial information is not saved. Even with auto rollback good programs detect errors and rollback themselves and allow users to continue.

The net result of the above is the probability that if the inserts actually occurred as you believe the there was a missing commit to confirm their addition to the database. and an automated rollback kept them from being completely added to the database. Another alternative is that the insert was not error checked in the program code and it failed meaning despite the program counter claiming rows were inserted in fact they were not.

Dec 07, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

118 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides