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

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 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 (AT) gmail (DOT) com> wrote

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...." ! 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:

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 (AT) gmail (DOT) com> 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:

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,"e stb_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,"e stb_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 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 (AT) gmail (DOT) com> 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:

Do you get any messages when you access the database?

--
Hope this helps.

Dan Guzman
SQL Server MVP

"microsoft . public . sqlserver" <dpk.sinha (AT) gmail (DOT) com> wrote