I am getting this error in SQL server when i try to enter a row.
213019
Sounds like your table lacks a primary key.\n\nIf it does have a primary key, you should check the lock you are using; you're probably using an optimistic lock on a database that others are updating, while you really need to use a pessimistic lock on the records you want to modify.
165337
Check the syntax of your Update query\n\nIf you are using Transactions\n\nYou may not have committed a transaction.\n\n\nIf u r editing via Enterprise manager , do necessary edits close and open again
23938
Convert the parameters in your "where" clause to the same case, upper or lower.\n\nselect * from tbl \nwhere upper(fielda) = upper(searchparameter)\n\nI've not worked with Access (.mdb) dbs much, but there may also be an Access configuration to disregard Case.  (At least that is an option in MS Sql Server.)
123871
Most commonly this is a Runtime error of sofware written in Norweigen, Danish, German or similar languages... associated with high finance and commodity trading. \n\nIt can also be a SQL Exception; a Syntax Error; a Solaris Search error \n\nIt may not occur again. If it does, the offending software will probably require a reinstall.
336612
Complete your question. What is the error message ?
235570
try this\n\nstart -> run -> cmd (or windowskey+R)\n\nnow type regedit.\n\nTell use the error and we might be able to help.
304246
I think your problem is more basic than this.\n\nYou define a variable named dt and are stuffing a date into it.  This is all well and good.\n\nBut in the next line, you're doing an SQL select.  In this line, dt is the name of a field in table [current$].  The two lines aren't related even though they have the same name.  \n\nIf you want the query to pull back data where the value in field dt is equal to the date 10/5/03, then you have to add a where clause to the SQL query:\n\n"Select dt as CloseDate from [current$] where dt=" & strDate\n\nNot sure which database you are using to select from, so the syntax may be slightly off, but you get the picture.  The thing here is that the SQL query is all text...even the date part.  The only exception to this is if you are running a stored procedure and some of the inputs are declared to be datetime data types.
596503
Dude... whoever said "use the connection wizard" just isn't creative at all...\n---------------------------------------------------------\n\nHere is code that helps you get started:\n\npublic DataTable listExistingForAdmin()\n{\n//a temporary table for storing the data into a dataset\nstring temptable = "yourTableNameHere";\n\n//prepare the SQL statement...\nstring sql = "EXEC df_groups_listExistingForAdmin"; //your SQL code here\n\n//open the connection - use your connection string!!!\nthis.con = new SqlConnection("packet size=4096;user id=dbuser;password=dbuser;data source=YourDbServerName;persist security info=False;initial catalog=yourDbName");\nthis.con.Open();\n\n//instantiate the command\nthis.com = new SqlCommand(sql, this.con);\nthis.com.CommandText = sql;\n\n//instantiate the data adapter\nSqlDataAdapter adapt = new SqlDataAdapter();\nadapt.SelectCommand = this.com;\n\n//instantiate the DataSet\nDataSet ds = new DataSet();\n\n//complete the transaction\nadapt.Fill(ds, temptable);\nDataTable dt = ds.Tables[temptable];\n\n//clean house\nadapt.Dispose();\nthis.com.Dispose();\nthis.con.Close();\n\nreturn dt;\n}//end ()\n\nHope this helps!!
475916
if you know 2003, you should have the answer to this.  You have to post the form back to the same page (add a button with a method like btnSubmit_Click(object sender, EventArgs e).  Once this the page is posted back, you then need to create a database connection.\n\nYour SQL connection string should be saved in your web.config file.\n\nusing System.Data.SqlClient;\n\nSqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);\nSqlCommand cmd = new SqlCommand("INSERT INTO TABLENAME (Column1, Column2, Column3) VALUES (" + "'" + txtColun1 + "'" + "," + "'" + txtColumn2 + "'" + "," + "'" + txtColumn3 + "'" + ")", con);\ntry\n{\n   cmd.ExecuteNonQuery();\n}\ncatch(SqlException e)\n{\n  string error = e.Message.ToString();\n}\nfinally\n{\n  con.close();\n}\n\nThe only change is that VS 2003 use to use:\nSqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["con"]);  This is now obsolete.\n\nSorry, I updated this because yahoo answers cut have my code off.
419873
Are you getting an error? Is the field comp_it or comp_id?\n\nwrite gsSQL to the browser and see if it is generating your select statement correctly. also, why do you have gsSQL = ""?\nRather have it as follows: gsSQL = "Select * FROM complaint WHERE comp_id = " & incmp\n\nunless you have a valid reason?!
266105
If you use INSERT INTO and do not set a value for the description feild the default "NO DESCRIPTION" that you set will appear in the column.\n\nYes, as the first person said, you can't use INSERT INTO and set the value of description to NULL because you have set the column to not allow NULL
584795
Try reinstalling the program. The error seems to be an installation issue. Another possible reason could be that you changed the operating system in the formatting procedure. If that is the case check if the program is even compatible with the current operating system that you are runnning.
520123
Hi, Can u please detail the error message. And how have u defined your connection string and how are u checking it. Did u do it by DSN or System.Data.SqlClient class? Please update me on what are u actually trying and whats the error message. Will try my best to help you out. vijaygoodday@yahoo.com
667255
Here is a nice explanation:\nhttp://support.microsoft.com/?kbid=321686\n\nor something like:\nSELECT *\nINTO theImportTable\nFROM\n     OPENROWSET('MSDASQL',\n        'Driver={Microsoft Text Driver (*.txt; *.csv)};\n          DEFAULTDIR=C:&#92;;Extensions=CSV;',\n        'SELECT * FROM CSVFile.csv')\n\nBut you will need SQL Server Express.
96991
Hi, this error message can be related to a program set to be in start up of your windows. If you  know to which program that message is related, then you can click "RUN" in start menu and type "msconfig" then Enter. Select a tab "Startup", remove the mark from that program and then restart windows. Hope it will solve your problem. IF not sure, which program it's related to, then let me know I will try to further help.\nBest luck
165048
heres some code from a old ASP.NET application I found (the database connection string should be 1 line)\n\nDim Public DBS as String = "PROVIDER=Microsoft.Jet.OLEDB.\n4.0; DATA Source=c:&#92;DataBase.mdb"\n\n\n\nDim myconnection as oleDbConnection = new oleDbconnection(DBS)\nmyConnection.open()\nDim myCommand as oleDbCommand = New OleDbCommand("Select * from Threads", myConnection)\nDim myDataReader as oleDbDataReader = myCommand.ExecuteReader()
13566
What is the error.  Can't answer without more detais.