After restoring the Database getting this message "Cannot Modify record"

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
Three days 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 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. Change 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 SinhaSo the application is not reporting the actual SQL Server error message?
Without that information, you are shooting in the dark. I suggest you run a
SQL Profiler trace and also include Errors/Exceptions. This will hopefully
help identify the cause of the error.
You mention that you restored from backup. Was this a SQL Server backup?
Did you reinstall SQL Server?
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154755197.215422.79810@.75g2000cwc.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
> Three days 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 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. Change 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
>|||Thanks for ur reply Guzman.
1. Yes It was a SQL server backup
2. I did not reinstall SQL server .
I will run a SQL profiler trace and get back.
Thanks again.
Deepak
Dan Guzman wrote:[vbcol=seagreen]
> So the application is not reporting the actual SQL Server error message?
> Without that information, you are shooting in the dark. I suggest you run
a
> SQL Profiler trace and also include Errors/Exceptions. This will hopefull
y
> help identify the cause of the error.
> You mention that you restored from backup. Was this a SQL Server backup?
> Did you reinstall SQL Server?
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154755197.215422.79810@.75g2000cwc.googlegroups.com...|||How do I run SQL profiler with Errors/Exceptions included? By "Errors"
do you mean those Errors which I am getting in the application i.e
"Cannot Modify..." ! If yes How do I include this message in the
profiler, becse I do not see there any option for inclusion of my error
message. Please guide.
Deepak
microsoft . public . sqlserver wrote:[vbcol=seagreen]
> Thanks for ur reply Guzman.
> 1. Yes It was a SQL server backup
> 2. I did not reinstall SQL server .
> I will run a SQL profiler trace and get back.
> Thanks again.
> Deepak
> Dan Guzman wrote:|||> How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> do you mean those Errors which I am getting in the application i.e
> "Cannot Modify..." !
The 'Cannot Modify' message is not a SQL Server error message; it is a
generic message generated by the VB6 application, probably in response to a
SQL Server error. Hopefully, the trace will allow you to identify the
actual SQL Server error so that you can take corrective action.
I don't have SQL 7 Profiler available but I believe the steps are similar to
SQL 2000 Profiler. There should be an Errors and Warnings event class.
Include all those events.
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...
> How do I run SQL profiler with Errors/Exceptions included? By "Errors"
> do you mean those Errors which I am getting in the application i.e
> "Cannot Modify..." ! If yes How do I include this message in the
> profiler, becse I do not see there any option for inclusion of my error
> message. Please guide.
> Deepak
> microsoft . public . sqlserver wrote:
>|||Sir,
On running SQL profiler with Error/Exceptions included It is showing
"Error: 16821, Severity: 16, State: 1" it is also giving another error
message
"Operating system Error 87., The Parameter is incorrect"
All these error messages in front of the database ID master while my
application is running on the database "ABC"
When I
Dan Guzman wrote:[vbcol=seagreen]
> The 'Cannot Modify' message is not a SQL Server error message; it is a
> generic message generated by the VB6 application, probably in response to
a
> SQL Server error. Hopefully, the trace will allow you to identify the
> actual SQL Server error so that you can take corrective action.
> I don't have SQL 7 Profiler available but I believe the steps are similar
to
> SQL 2000 Profiler. There should be an Errors and Warnings event class.
> Include all those events.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154777520.843807.294740@.i3g2000cwc.googlegroups.com...|||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
5. After the hard disk crash at the time of restoration I got this
Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
sysadmin, or a member of dbcreator" to get rid of this problem I
downloaded SQL server Service pack 2 from microsoft site and installed
it. After the restoration every other part of the application working
except this. I doubt is it because of the service pack 2 ? Can I
upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
Please guide
Thanks
Deepak Sinha
microsoft . public . sqlserver wrote:[vbcol=seagreen]
> Sir,
> On running SQL profiler with Error/Exceptions included It is showing
> "Error: 16821, Severity: 16, State: 1" it is also giving another error
> message
> "Operating system Error 87., The Parameter is incorrect"
> All these error messages in front of the database ID master while my
> application is running on the database "ABC"
> When I
> Dan Guzman wrote:|||> except this. I doubt is it because of the service pack 2 ? Can I
> upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
I suggest you install SP4 since that's the final service pack for SQL 7.
Otherwise, you should run the same service pack as the original system.
That may be the underlying cause of these errors.
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...
> 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
> 5. After the hard disk crash at the time of restoration I got this
> Error message "[SQL-DMO] You must be logged in as 'sa' or a member of
> sysadmin, or a member of dbcreator" to get rid of this problem I
> downloaded SQL server Service pack 2 from microsoft site and installed
> it. After the restoration every other part of the application working
> except this. I doubt is it because of the service pack 2 ? Can I
> upgrade it to service pack 3 or 4 or I can uninstall service pack 2.
> Please guide
> Thanks
> Deepak Sinha
> microsoft . public . sqlserver wrote:
>|||I downloaded and installed the service pack 3 now my Enterprise Manager
is not starting after giving the previous user name(tre) and
password(****). It is saying "Connection failed check SQL server
registration properties" When I edit the reg. properties by giving
previous user-id and pwd it is saying "cannot open default database
'<ID>' . using master database instead". I tried changing default
database at the command prompt
C:\mssql7\binn>isql -E -d
1>use master
2>go
1>sp_defaultdb tre, insdb
2>go
Default database changed
1>exit
When I go back to Enterprise Manager it is still same. I am in a real
mess.
Pl. Guide.
Deepka
Dan Guzman wrote:[vbcol=seagreen]
> I suggest you install SP4 since that's the final service pack for SQL 7.
> Otherwise, you should run the same service pack as the original system.
> That may be the underlying cause of these errors.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
> news:1154857843.655253.136200@.m73g2000cwd.googlegroups.com...|||Do you get any messages when you access the database?

>isql -E -d
>USE insdb
>GO
>exit
Hope this helps.
Dan Guzman
SQL Server MVP
"microsoft . public . sqlserver" <dpk.sinha@.gmail.com> wrote in message
news:1154869759.625272.196410@.m73g2000cwd.googlegroups.com...
>I downloaded and installed the service pack 3 now my Enterprise Manager
> is not starting after giving the previous user name(tre) and
> password(****). It is saying "Connection failed check SQL server
> registration properties" When I edit the reg. properties by giving
> previous user-id and pwd it is saying "cannot open default database
> '<ID>' . using master database instead". I tried changing default
> database at the command prompt
> C:\mssql7\binn>isql -E -d
> 1>use master
> 2>go
> 1>sp_defaultdb tre, insdb
> 2>go
> Default database changed
> 1>exit
> When I go back to Enterprise Manager it is still same. I am in a real
> mess.
> Pl. Guide.
> Deepka
> Dan Guzman wrote:
>