Someone Else Editing Record ? Only Me On The Server ?

Jul 20, 2005

I have some software (written in Delphi 5) which has been working for
several months without a problem.

I have been given a copy of the database on our development server
(SQL 7) and have pointed the software to this. So, nothing has changed
with the software. In theory the servers should be the same.

However, if I try to make a small change to any record (as I would on
the 'live' system), I get an error stating that another user is
editing the record. Now, I'm the only person with access to this
server. So am I stopping myself I wonder ?

If I create an ODBC connection to the database through Access 2000, I
get the same error. I feel I can reasonably assume that the software
is not at fault.

I'm sure it's something SQL based, whether it's an error or
configuration difference, but I'm stuck.

I've checked who is locking/blocking, and yes it will show me as
having the record open, but this is me attempting to edit the record
so I would expect this.

I can edit the table directly in SQL, but it takes 30 seconds or more,
freezes EM and then allows the change. Table info below :

if exists (select * from sysobjects where id =
object_id(N'[dbo].[PostReceived]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[PostReceived]
GO

CREATE TABLE [dbo].[PostReceived] (
[PostID] [int] IDENTITY (1, 1) NOT NULL ,
[Type] [varchar] (100) NULL ,
[ClientsName] [varchar] (100) NULL ,
[DateReceived] [datetime] NULL ,
[EnteredBy] [varchar] (100) NULL ,
[AssignedTo] [varchar] (100) NULL ,
[DateAssignedTo] [datetime] NULL ,
[Adviser] [varchar] (100) NULL ,
[TargetDate] [datetime] NULL ,
[CompletionDate] [datetime] NULL ,
[Completed] [bit] NULL ,
[KeyAccount] [varchar] (100) NULL ,
[Notes] [text] NULL ,
[Specific1] [varchar] (20) NULL ,
[Specific2] [varchar] (20) NULL ,
[Specific3] [varchar] (20) NULL ,
[Specific4] [varchar] (20) NULL ,
[Specific5] [varchar] (20) NULL ,
[ToDelete] [bit] NULL ,
[EnterUser] [varchar] (20) NULL ,
[Returned] [bit] NULL ,
[ReturnDate] [datetime] NULL ,
[ReturnReason] [varchar] (87) NULL ,
[PrintAdviser] [bit] NULL ,
[EmailAdviser] [bit] NULL ,
[EmailSM] [bit] NULL ,
[EmailRegionManager] [bit] NULL ,
[ReturnText] [varchar] (150) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

(Yes I know about using Identity in the key, but it's on my list to
change before anyone says anything).

View 5 Replies


ADVERTISEMENT

Problems In Editing A Record... Why? Help Pls....

Feb 4, 2007

can someone help me why it produces an error....
error is: ERROR 22001 Microsoft ODBC SQL Server Driver SQL Server STRING or data of BINARY was cut short. ERROR 01000 Microsoft ODBC SQL Server Driver SQL Server statement was ended.
This is my code here for editing a  record....
 
Protected Sub Button_save2_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button_save2.Click        '|||||   Create string connection         Dim StrConn As String = "Dsn=MS_PKG01;UID=emiline;APP=Microsoft® Visual Studio® 2005;WSID=MSHNP200603;DATABASE=MS_PKG01;Trusted_Connection=Yes"        '|||||   Create connection object        Dim MyConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(StrConn)
        '|||||   Open connection        MyConn.Open()
        '|||| Create odbcCommand object        Dim Update_record As New Odbc.OdbcCommand("UPDATE TM0001 SET TM0001.syain_name = ?, TM0001.syain_pass = ?, TM0001.office_id = ?, TM0001.birth_date = ?, TM0001.empl_date = ?, TM0001.user_iden = ? ", MyConn)
        Dim hireYear As String        Dim hireMonth As String        Dim hireDay As String        Dim date_hire As String
        hireYear = DropDownList_hire_yr.Text        hireMonth = DropDownList_hire_mo.Text        hireDay = DropDownList_hire_day.Text
        date_hire = hireYear + "/" + hireMonth + "/" + hireDay
        '|||| Add command parameters        Update_record.Parameters.Add("@P1", OdbcType.Char, 8).Value = TextBox_id.Text        Update_record.Parameters.Add("@P2", OdbcType.Char, 20).Value = TextBox_name.Text        Update_record.Parameters.Add("@P3", OdbcType.Char, 20).Value = TextBox_pswd.Text        Update_record.Parameters.Add("@P3", OdbcType.Char, 40).Value = DropDownList_office.SelectedValue        Update_record.Parameters.Add("@P3", OdbcType.Char, 2).Value = date_hire        Update_record.Parameters.Add("@P3", OdbcType.Char, 10).Value = TextBox_bday.Text        Update_record.Parameters.Add("@P3", OdbcType.Char, 1).Value = DropDownList_iden.SelectedValue
        '|||| Execute command        Update_record.ExecuteNonQuery()
        '|||| Close connection        MyConn.Close()    End SubEnd Class

View 3 Replies View Related

Editing A Sql Record That Contains NULL Values

Mar 25, 2008

Seems that when i use the edit functionality of the formview, and there are NULLs in the record, that my sql update statement (default from the FormView wizard) doesnt work (nothing updates). However, if i populate all fields, everything works fine. I have modified the FormView edit template to add my own textboxes and dropdowns to simplify the user record editing. 
Because it works when all fields are populated with non-NULL values, Seems my Bind's are all correct.
            ---Jim 

View 10 Replies View Related

How Can I Reserve A Record To Prevent Anyone Else From Editing For X Minutes?

Nov 30, 2006

Hey All,I think this is something like locking, but not quite. I need to select a record in a database and display the information to the end user. The end user has a few minutes to review it before giving the ok at which point I will update the record.However, while the user is reviewing the record, i dont want anyone else to be able to grab that record. I also want to make sure that if the user doesnt submit the page, that the record will be freed up and not indefinitely marked as taken.What would be the best way to do this?  This is with .net 2.0 and sql2000

View 2 Replies View Related

This Record Has Been Changed By Another User Since You Started Editing It....

Jul 9, 2002

I am getting the following error while trying to update a SQL Server 7.0 table thru' MS Access('97 version). It was working fine until now. This problem started happening after re-linking the table to MS Access as new columns have been added on the SQL Server table. We tried re-starting the MS Access,re-linking the table again,giving all the permissions to the user on the table etc. Also, no other user is accessing the table at the same time..Any help?

Error message in MS Access:

This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.

thanks,
Mike.

View 1 Replies View Related

Editing A SQL Server Table Via MS Access

May 3, 2000

Hello!

We have a SQL Server table that needs to be maintained by the actuarial department. Therefore, I was going to have them make changes to the table using something easy like Microsoft Access 2000. When I go into Access and create an ODBC link to the table, I cannot change the data. (i.e. The insert new record feature is greyed out.) I CAN change the data via Enterprise Manager, so I don't think it is SQL Server security. Any other ideas?

Thanks,
Sharon

View 1 Replies View Related

Reading And Editing Sql Server 6.5 Table Contents

Aug 17, 2000

What is the best way to read and edit data in the tables of a sql server 6.5 database?

Thanks

Gunnar
gunnardl@yahoo.com

View 1 Replies View Related

Sql Server 2005 Questions Regarding Editing Views

Jun 21, 2006

Previously in Sql Server 2000, we would be in enterprise manager, you'ddouble click on a view, and a nice little dialog box opened with the t-sqlstatetments, there was also a check sql syntax and apply and cancel buttons.Not exactly query anaylizer, just a quick lightweight dialog box. Is thisfeature still around? Seems like I have to go into the query anaylizer likemode to edit a view now. I am a total newbie to version 2005. Are there anyoptions I can set to make it behave the old way? All feedback isappreciated.TIA,~CK

View 2 Replies View Related

SQL Server 2012 :: Editing Report Server Facets?

Jun 11, 2014

I am trying to edit the 3 facets found under Report Server while logged onto the server as an administrator. This is one of 3 (supposedly) identical Report Servers (Windows Server 2012 Standard - Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) ) and the only one experiencing an issue. The images below show what happens when I try to change the facets to TRUE and their original values. Incidentally, when first hitting the facets, they are not set to true even though the config file has all 3 values set to true.

[URL]

View 0 Replies View Related

How To Restrict Editing Of SQL Server 2005 Data Via ODBC Link?

Apr 25, 2007

I have a sql server 2005 database with Delphi 2006 in the front end and for querrying and reporting we use MS Access 2003 by connecting to this database via ODBC connection. I recently found out that the SQL Server 2005 data connected thus can be edited (updated) from MS Access. I do not want end users to modify/update the SQL Server 2005 data from MS Access while I also want them to have the ability to insert/update/delete rights using the appropriate application interface. For now, I am handling this by creating a user id that is not permitted to update, insert and delete and using the same account in the ODBC. Is there a way in SQL Server 2005 you can control insert/update/delete rights for all users that will be applicable only in the ODBC mode?



Any help will be greatly appreciated.



thulo

View 3 Replies View Related

SQL 2012 :: Error Executing Packages In SSIS Project On Server After Editing On Client

Sep 24, 2014

I am building a bunch of packages on our new server and all was going well until I edited the project using the client tools on my PC. I now receive the below error if I try to execute any of the packages on the server (all is still fine on the client). I have scoured the net but I don't seem to be able to come up with a solution. I have tried altering the folder & object permissions for my login (that created the project on the server and edited using the client) but I still get the error.

ERROR:

TITLE: Microsoft Visual Studio
------------------------------
Failed to start project
------------------------------

ADDITIONAL INFORMATION:

Exception deserializing the package "Access to the path 'G:VisualStudioTestTestbinDevelopmentTest.ispac' is denied.". (Microsoft.DataTransformationServices.VsIntegration)

------------------------------
Access to the path 'G:VisualStudioTestTestbinDevelopmentTest.ispac' is denied. (mscorlib)
------------------------------
BUTTONS:

OK
------------------------------

View 4 Replies View Related

Add Date To Record In SQL Server Each Time Record Is Added

Mar 1, 2006

Hi
 
Can anyone advise me as to how I can add the date and time to 2 columns in the sql server database for each record that is added. I'd prefer not to use the webform. Can sql server add the date automatically to the row?
thanks

View 6 Replies View Related

DTS Editing

Feb 2, 2001

If I have a *.dts file, and want to change the originating server database from SERVERA DB_A to SERVERB DB_B, is there an easy method to do this, besides editing the file in the GUI form?

View 1 Replies View Related

Help Editing MSQ 4.0.27 To 4.1.2

Jun 16, 2007

I need help transferring a SQL database. I currently have my website database on a SQL 4.0.27 (vdeck) and want to transfer it to a new server (VPS) which has SQL 4.1.2

I have imported the database to my desktop computer. It will not let me import to the new server. I have to edit/reconfigurate.

Any suggestions, comments, advice, help would be greatly appreciated.

Ed

ed.sistrunk@sistrunk.net

View 4 Replies View Related

SQL Database Editing

Nov 4, 2003

Can I edit database (Tables, SPs, Views,...) with ADO.NET?

View 3 Replies View Related

Editing Database

Feb 16, 2005

hey guys,
is it possible to add or edit columns once there is data in the tables??
not the data in the columns but the columns themselves..
for example lets say i have a table with 4 columns and for some reason or
another, i want to add a 5th or 6th column after data has already been entered,
like a few months down the line..

View 2 Replies View Related

Editing SQL Jobs

Mar 9, 2005

I have scheduled a T-SQL job that runs every morning using Enterprise Manager. Now I want to change the SELECT and UPDATE statements that this job runs, but I can't find anywhere to edit a job that has already been scheduled. Any help would be appreciated.

Thanks

View 1 Replies View Related

Timestamp Editing

May 6, 2008

I keep getting "cannot update a timestamp column"!! How can I change the timestamp to all zeros? or can I not do that?

JOhn

View 4 Replies View Related

Editing In The GridView

Nov 16, 2007

Hi

I want to Enable Editing in the GridView
but there is a problem

the GridView take its data from 2 tables and I do this by the
build query

so I can't choose the " advance " button and check for enable update and delete statements

and when I try to build the update query in the update tap
I don't know what to write in the "new value" column

so how can enable editing in the GridView that take from
2 tables???????

please help me
and thanks

View 3 Replies View Related

Getting, Editing And Updating Data

Feb 20, 2004

Hi,

I want to get (SELECT??) data from a db (SQL), edit the data (+1) and then update (UPDATE??) the table with the edited value. How do I get the value from the db and then edit it and then update the field in the db?? Does someone has an example so I get on the way??

Thanks,

Roel

View 9 Replies View Related

Editing Table Design

Aug 15, 2005

Is there anyway possible to edit table design with data already entered in the table.If not, is there anyway I can cut and paste the info back in. Ive tried importing to access and then back to SQL, however, when i tried to view my table design in ASP.NET webmatrix, it gave me an error.

View 1 Replies View Related

Stored Procedure Editing With EM

Jun 12, 2000

View 3 Replies View Related

Editing Maintenance Plan

Mar 18, 2002

I've just created a new maintenance plan (sql2k sp2) and attempted to re-enter it to make a change. right click - choose properities (or double click)...I see the dialog box 'flash' very briefly but it's not making itself available for editing.

I've deleted and recreated the plan ... same result.

I _should be able to edit it, shouldn't I?

thankx
--steve...

View 1 Replies View Related

Editing SA Permissions MS SQL 2005

Jul 7, 2006

Hi guys

Am i able to deny the SA account access to a specific database?

thanks in advance for your help.

TheGing

View 4 Replies View Related

DTS Package Hangs While Editing

Jan 14, 2008

I have a SQL 2000 SP4 server running on Windows 2003 SP2. About 6 months ago I started experiencing problems editing existing DTS packages. At that time it was just 1 package. (I tested that I could edit all others but this one package the first time I experienced the problem.)

But now it seems like anytime we experience import problems, I cannot edit the package so that I can verify that the import file is good. (So far the initial problem is always with the import file and once we figure out what that is and resolve it the package runs ok again.)

The problem is I'm planning on migrating to SQL 2005 and since I can't import DTS packages, I'm going to have to rewrite them as Integration Service Projects. If I can't edit the workflow tasks in DTS, it will be time consuming figuring out what the actual import file is. Also, most of these imports are coming from our AS400 which we are phasing out so I have to rewrite these to work with the new ERP package we are going to as we bring on each division.

I have not installed any post SQL 2000 SP4 hotfixes. So if anyone is aware of a hotfix that resolves this issue, please let me know.

View 14 Replies View Related

Editing/deleting Problem.

Apr 8, 2004

Hi to all,

We have an application that used Ms-Access for its backend.
We wanted to move up to MSDE so I wrote a conversion utility that creates the SQL database, copies all the data from the Access database, creates all the indexes and relationships.

Now, the application used a lot of sql statements which would have to be rewritten for SQL Server so we decided to create a ms-access database with linked tables to the SQL server (ODBC). Don't tell me not to do that because I have no control over it :).

The weird thing happening now is that:
All the records that were moved from access are fine.
New records can be added fine.
However, when trying to edit/delete the new records, I get an error saying that:
Write Conflict.
I can't change the record because it has been changed by another user since I started editing it.

Any ideas?

Thanks

View 2 Replies View Related

What Editing Tool To Use For SQl On SQL 2000?

Apr 28, 2006

I've recently been upgraded to Office 2003 and primaraly use Access to edit SQL stored procedures on a SQL 2000 box.

It seems though from first glance, things have gotten worse since Access 2000.

No more colour coding for example and it also opens some in a view type mode.

Any recomendations on what I can use that would allow me to edit the SQL while updating it on the server and pull down data if needed?

Someone recommened Visual Studio but I'm unsure of which version to use.

View 6 Replies View Related

Editing Data Using Views

Feb 29, 2008

Please direct me towards good documentation about updating, inserting and deleting data using views involving multiple tables.

Thanks

View 2 Replies View Related

SP Problem With Editing Records

Jul 20, 2005

I have an SP which I use to insert into a table data from another. Forexample...INSERT INTO myWorkTable(Field1, Field2)SELECTmyField1, myField2FROMmyNewTableIt's a pretty straight forward sp. Now, the data that gets insertedseems to have remained in a state that stops me updating it later. TheSP is called by one app which is then closed and not used again untilthe following month. The sp shouldn't be used by anything else.I have another application which goes to the table (in my examplemyWorkTable) and is supposed to open and edit specific records whichit does correctly navigate to (a few days after the sp). It fails andI get an error message stating that the record is being edited byanother user. This record should not be opened by any other process.If I export the data and re-import it into the table, it worksperfectly fine.The code used to edit the table is fine and has worked for a couple ofyears and I'm happy with it. The only change I have made is to use anSP to import the data instead of an old method using Access 2000. Thefunctionality is the same, even though the connection is different.The Delphi app uses BDE.Inserting directly through SQL works as I would have expected and Ican edit the record as I need.I'm guessing that Delphi (which I use for the app) is somehow notfreeing up the data locked by the SP when it finished calling the SP,even when it is closed. However, it seems a little bizarre as I wouldexpect it to free up the data affected by the SP once it has finished(maybe this is the wrong assumption).So, my question is, can an SP lock records in this way ? If so,how/why and can I stop this once finished, or is there a way ofchecking / resetting records which were locked up and should no longerbe this way. I can't see anything obvious which shows the records arelocked, but am willing to delve further.ThanksRyan

View 2 Replies View Related

Editing ModelGenerationRules.smgl

Jan 10, 2007

Hi, I need to modify the ModelGenerationRules.smgl file to increase the mandatory filter setting of 5000 records. This is much too small for our database. I know where the file is but I need to know how to make the change. Does anyone know how to change this?

Thanks

BB

View 1 Replies View Related

Editing Stored Procedures...

Mar 29, 2006

I'm not a "real" programmer. Excuse my ignorance.

I need to edit a stored procedure. I simply want to change the text that it displays. I do not intend to change its function.

I am using SQL Express and SQL Server Management Studio Express. I can select Modify for my stored procedure, but when I save it, it saves it as an SQL file to my hard disk. How do I affect the edits to the actual stored procedure?

View 1 Replies View Related

Editing .dtsconfig Files

Oct 17, 2007



Apologies if this has been posted before and feel free to point me to an existing thread if it has.

I currently have a dev, stage and live environment for a package

i have created a load.dtsconfig file that contains various bits such as connection strings, email to, from, etc which i created via the package configurations in the dev package. I then made a few changes via XML Notepad

I went to use the same config file on stage and decided to add a further property. I selected package configurations on stage and selected edit it the package configurations box, added the property and clicked finish. However it reset all the existing properties to the values that exist in the actual package so all the changes i made via XML notepad were overwritten.

Is there anyway you can get the Package configurations editor to retain the values from the .dtsconfig file rather than reading in the values from the package???

cheers


Scott

View 4 Replies View Related

Help With Problem From Editing RsWebApplicationConfig

Feb 6, 2007

Our report server was being accessed by machine name, not alias, so I had an alias set up.

I was working to get the subscription emails to use the new alias, instead of machine name. I think I should have edited the rsreportserver.config file, but first I edited the rsWebApplication.config file, and added an URL into <ReportServerURL> tag.

At that point clicking on New Subscriptions stopped working - now I always get an Error page with this message "Object reference not set to an instance of an object". That's only for new subscriptions, not new Data driven subscriptions.

In the error logs, I got this message:

w3wp!library!c!2/5/2007-18:46:46:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. ---> System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.
at Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
--- End of inner exception stack trace ---
w3wp!configmanager!c!2/5/2007-18:46:46:: Error occured with a config file change. New config file will not be used. Error: The report server has encountered a configuration error. See the report server log files for more information.


Now, no matter what I do to correct the rsWebApplication.config file, it doesn't seem to fix the problem (ie, I continue to get the above error, when trying to add a new subscription.)

What do I do to fix this?

Thanks in advance for any help!

Kristi

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved