1 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: Start-up error in R6.14 after attempting to delete a survey

Hi folks,

have recently upgraded our Recorder6.13 to 6.14, and have had trouble with importing a set of records to a survey.  Having looked at various aspects of the failed import, I decided the best thing was just to delete the survey and start again.  I thought about using the delete survey tool on the drop-down menu, but then decided to try the JNCC delete survey batch update.  All was proceeding in a blank-screen manner, and I then got an application error box -  do you want to restart, carry on or shut down recorder - I think I chose proceed.

However, Recorder promptly closed down, and now, when I try and re-open it, I get the following:
EOle Exception: cannot open database requested in login 'NBNdata'. Login Failed.

Any suggestions of what I should try next?

(I do have a back up database created this morning.......)

Louise Bacon
Cambridgeshire & Peterborough Biological Records Centre

2 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Start-up error in R6.14 after attempting to delete a survey

Hi Louise,

I am not sure which batch update you are referring to - but I can't see a current one that is used for deleting surveys. I would suggest restoring from the backup you created and then if the survey you want to delete is in that version use the delete survey addin only. There was a new version issued recently that deal with surveys within survey tags. If you feel that it is not a data issue you could try switching to the import wizard used in 6.13 (Tools/options).

Best Wishes,
Lynn

3 Reply by Lynn Heeley

  • Lynn Heeley
  • Administrator
  • Offline
  • Registered: 03-07-2008
  • Posts: 345

Re: Start-up error in R6.14 after attempting to delete a survey

Hi Louise,

Can you post the whole of the error message you received please. Do you have access to the SQL Server database using management studio express or enterprise manager?
I understand that there is a JNCC\Delete Records batfch update that can delete surveys but evidently there is nothing in the code that could have caused such a crash or prevent you logging in again. It might also be worth checking the permissions on the nbndata.mdb database in case these have been changed. On what system are you running Recorder (Vista, XP etc)?

Best Wishes,
Lynn

4 Reply by LBacon

  • LBacon
  • Veteran
  • Offline
  • Registered: 12-09-2006
  • Posts: 80

Re: Start-up error in R6.14 after attempting to delete a survey

HI Lynn, I will answer your queries below:

Lynn Heeley wrote:

Hi Louise,

"Can you post the whole of the error message you received please. "

As written in my first message, the error said:
EOle Exception: cannot open database requested in login 'NBNdata'. Login Failed.

"Do you have access to the SQL Server database using management studio express or enterprise manager? "

If I do, I would not know that I do.

"I understand that there is a JNCC\Delete Records batch update that can delete surveys but evidently there is nothing in the code that could have caused such a crash or prevent you logging in again. It might also be worth checking the permissions on the nbndata.mdb database in case these have been changed."

no-one could have changed them as it is a standalone copy on this machine....but wheer would I look for permissions to check.

"On what system are you running Recorder (Vista, XP etc)?"

XP

Best Wishes,
Lynn

5 Reply by Eleanor Knott

  • Eleanor Knott
  • Veteran
  • Offline
  • Registered: 21-01-2009
  • Posts: 93

Re: Start-up error in R6.14 after attempting to delete a survey

Hi Lynn

We frequently get the same message as you - 'An error occurred whilst starting the application.  EOleException: Cannot open the database "NBNData" requested by the login.  The login failed'

We also get - 'An error occurred whilst starting the application.  EOleException: Cannot generate SSPI content'

Usually if we log off and log on again, Recorder will start - though sometimes we have to re-start the computer.  It's a flaming nuisance - I don't think we have had a day since upgrading to Recorder 6 when it has worked properly.

Is there any way we can get rid of these error messages?  What is going wrong - is it Recorder 6 or SQL server?

Ellie

Eleanor Knott
Senior Records Centre Officer
Devon Biodiversity Records Centre
C/o Exeter Central Library
Castle Street
Exeter
EX4 3PQ
Tel. (01392) 274128

Eleanor Knott
Devon Biodiversity Records Centre

6 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Start-up error in R6.14 after attempting to delete a survey

Hi Louise

To restore your backup without being able to access Recorder you can use the command prompt. Here are some instructions for you:
1) Start up the command prompt (hold the Windows key then press R, type cmd then press enter).
2) If you have local machine administrator rights, type the following then press enter. Note if your database is installed on a different instance of MSDE change (local) to the instance name - if you don't know then try this as it will work if you used the default Recorder install options:

osql -S (local) -E -Q "RESTORE DATABASE NBNData FROM NBNData_Backup"

If you are not the administrator of the local machine, try the following:

osql -S (local) -U sa -Q "RESTORE DATABASE NBNData FROM NBNData_Backup"

If it is working the command prompt will probably go blank for a few minutes then report back some messages including "RESTORE DATABASE successfully processed ..." etc.

If you have any problems Louise get directly in touch and I can guide you through it over the phone.

Kind Regards

John van Breda
Biodiverse IT

johnvanbreda's Website