news:1154756314.772768.210010@h48g2000cwc.googlegroups.com...
> Good Morning Friends
>
> I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> have got one application developed by some software agency using VB 6.0
>
> and sql server 7.0. Since last 6 years everything worked fine.
> Three days back my SQLserver machine crashed because of hard disk
> failure.
> After much effort of two days I restored all the data from the
> backup. In our Application primarily there are two sections Members and
>
> Agency. Everything is working fine in the Members section i.e browsing,
>
> modification, deletion of records etc. But in the agency section only
> browsing of record is working if I want to Edit the record and then
> press the save button it gives the error message " Cannot Modify
> Record, Please close the screen and reopen. All changes will be lost."
> Actions Taken till now:
> 1. Changed the deafult db to "ABC" for the user "CFC" Logging into the
> SQLserver. This was the arrangement before crashing.
> 2. Granted the server role "db owner", "db creator" to the user "CFC".
> 3. Checked the tables permission of Members section (Where Modify is
> working)  as well as agency section (Where Modify is not working), both
>
> the tables have same kind of permission.
> 4. Tried to get answer on google but of no help.
>
>
> Please help me urgently.
>
>
> Thanks
>
>
> Deepak Sinha
>

> Hi,
>
> Execute the SQL Profiler and understand the stored procedure which does the
> UPDATE/INSERT/DELETE.
> Then execute the procedure with parameters from query analzer and see if you
> gets any error..
>
> I feel that this error may not be related to SQL Server.
>
> Thanks
> Hari
> SQL Server MVP
>
> <dpk.si***@gmail.com> wrote in message
> news:1154756314.772768.210010@h48g2000cwc.googlegroups.com...
> > Good Morning Friends
> >
> > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> > have got one application developed by some software agency using VB 6.0
> >
> > and sql server 7.0. Since last 6 years everything worked fine.
> > Three days back my SQLserver machine crashed because of hard disk
> > failure.
> > After much effort of two days I restored all the data from the
> > backup. In our Application primarily there are two sections Members and
> >
> > Agency. Everything is working fine in the Members section i.e browsing,
> >
> > modification, deletion of records etc. But in the agency section only
> > browsing of record is working if I want to Edit the record and then
> > press the save button it gives the error message " Cannot Modify
> > Record, Please close the screen and reopen. All changes will be lost."
> > Actions Taken till now:
> > 1. Changed the deafult db to "ABC" for the user "CFC" Logging into the
> > SQLserver. This was the arrangement before crashing.
> > 2. Granted the server role "db owner", "db creator" to the user "CFC".
> > 3. Checked the tables permission of Members section (Where Modify is
> > working)  as well as agency section (Where Modify is not working), both
> >
> > the tables have same kind of permission.
> > 4. Tried to get answer on google but of no help.
> >
> >
> > Please help me urgently.
> >
> >
> > Thanks
> >
> >
> > Deepak Sinha
> >

> Dear Sir
> I ran the SQL profiler and I got these error messages
> 1. Error 16821, Severity: 16, state: 1
> 2. Operating system Error 87., The parameter is incorrect
> 3. sp_executesql N'UPDATE "INSDB".."INS_M_agency" SET
> "reg_code"=@P1,"agen_name"=@P2,"agen_place"=@P3,"estb_date"=@P4,'', ''
> go
>
> When I ran the above SQL statement in the Query Analyzer It is giving
> Error message "Server: Msg 170, Level 15, State 1, Line 1"
> " Line 1: Incorrect syntax near 'INSDB'."
>
> 4. UPDATE "INSDB".."INS_M_agency" SET
> "reg_code"=@P1,"agen_name"=@P2,"agen_place"=@P3,"estb_date"=@P4
> g0
>
> When I try to this statement it is giving the same message as above in
> the number 3.
>
> Please guide
>
> Deepak
>
>
> Hari Prasad wrote:
> > Hi,
> >
> > Execute the SQL Profiler and understand the stored procedure which does the
> > UPDATE/INSERT/DELETE.
> > Then execute the procedure with parameters from query analzer and see if you
> > gets any error..
> >
> > I feel that this error may not be related to SQL Server.
> >
> > Thanks
> > Hari
> > SQL Server MVP
> >
> > <dpk.si***@gmail.com> wrote in message
> > news:1154756314.772768.210010@h48g2000cwc.googlegroups.com...
> > > Good Morning Friends
> > >
> > > I am in real soup. I am new to SQL server 7.0 and Visual basic 6.0. I
> > > have got one application developed by some software agency using VB 6.0
> > >
> > > and sql server 7.0. Since last 6 years everything worked fine.
> > > Three days back my SQLserver machine crashed because of hard disk
> > > failure.
> > > After much effort of two days I restored all the data from the
> > > backup. In our Application primarily there are two sections Members and
> > >
> > > Agency. Everything is working fine in the Members section i.e browsing,
> > >
> > > modification, deletion of records etc. But in the agency section only
> > > browsing of record is working if I want to Edit the record and then
> > > press the save button it gives the error message " Cannot Modify
> > > Record, Please close the screen and reopen. All changes will be lost."
> > > Actions Taken till now:
> > > 1. Changed the deafult db to "ABC" for the user "CFC" Logging into the
> > > SQLserver. This was the arrangement before crashing.
> > > 2. Granted the server role "db owner", "db creator" to the user "CFC".
> > > 3. Checked the tables permission of Members section (Where Modify is
> > > working)  as well as agency section (Where Modify is not working), both
> > >
> > > the tables have same kind of permission.
> > > 4. Tried to get answer on google but of no help.
> > >
> > >
> > > Please help me urgently.
> > >
> > >
> > > Thanks
> > >
> > >
> > > Deepak Sinha
> > >