1 (edited by Alan Hale 05-01-2011 16:19:23)

Re: R6.15 won't install

Hi

I'm having to re-install Recorder having been issued with a new laptop running Win XP SP3 (in my job at Countryside Council for Wales). I've successfully installed SQL Server Express 2008 R2 but when I come to install R6.15 (provide to me internally as an ISO file which I've burned to DVD), when I've entered a valid site ID and  the corresponding verification key it throws up the generic and unhelpful error "invalid class string". Any suggestions as to why, or what steps to take next to track down the problem?

Thanks

Alan

Alan Hale
Aberystwyth

2

Re: R6.15 won't install

Sorry, I should have said that it accepts the site ID and key but fails at the point of selecting an existing instance of SQL Server.

Alan Hale
Aberystwyth

3

Re: R6.15 won't install

But if I let the install add it's own SQL Server instance, that works OK.

Alan Hale
Aberystwyth

4

Re: R6.15 won't install

Hi Alan
Are you on 64 bit Windows? If so, then I know there are problems because Recorder cannot see a 64 bit instance of SQL Server.

John van Breda
Biodiverse IT

5

Re: R6.15 won't install

Hi John - no, 32 bit.  I'm about to try an install on another machine (Win 7). I'l report back.
Alan

Alan Hale
Aberystwyth

6

Re: R6.15 won't install

You have probably done this already, but make sure that the first time you run Recorder you right click on the icon and run as Adminstrator. Also that  with a Windows 7 install you change the default folder to a folder which does not require Admin Permission to write to (ie specify a new folder say ProgramData so as not to use the default Program Files folder). 

Mike

Mike Weideli

7

Re: R6.15 won't install

Thanks Mike, I was already aware of these issues - but I might not have been!

I will summarise what I have done today:

1) Wondering whether the problem might lie with SQL Server Express 2008 R2, I tried installing R6.15 onto SQL Server Express 2008 "R1".  I tried this on both my XP and Win 7 machines, but with the same "Invalid class string" error.

2) I then decided to try an earlier version of R6 - the only disc I have is 6.10.4 so I tried that (on XP and on SQL Server Express 2008 R2). It's installed without problem.

So the problem seems to be with my 6.15 install disc.

I guess since I want to be done with this I'm going to download all the updates and run them over the 6.10.4 install.

Alan Hale
Aberystwyth

8

Re: R6.15 won't install

Uh-oh - spoke too soon. I should have said "seems to be installing without problem". It was going well but now seems to be stuck on copying "uninstall.exe".

Alan Hale
Aberystwyth

9 (edited by MikeWeideli 06-01-2011 10:12:00)

Re: R6.15 won't install

Alan

What would be interesting to know is if, once you have Recorder running under in SQl Server 2005, if you move the database (by detaching and attaching it to your 2008 instance) then change the registry to point  Recorder to the  SQL Server 2008 instance will Recorder continue to work.



Mike

Mike Weideli

10

Re: R6.15 won't install

Mike

That is an interesting suggestion - I'll give it a go.

Alan

Alan Hale
Aberystwyth

11 (edited by Alan Hale 11-01-2011 08:53:50)

Re: R6.15 won't install

Whew, I'm up and running again, but it was a close call (see below). What I did was:

1) install Recorder (onto XP) opting to install the default SQL Server 2005 database.
2) separately install SQL Server 2008 R2 on the same machine;
3) (in SQL Server Managment Studio) restored my NBNData backup to the 2008 R2 instance;
4) detached the new (empty) NBNData data files from the 2005 instance;
5) in the Registry, pointed Recorder to the 2008 R2 instance.

This worked and so far everything seems to be OK.  The "close call" arose because my misunderstanding of how the SQL Server backups work. I'd opted to backup to two locations, assuming this gave me two identical backup files, either of which could be restored from. In fact, two files are produced which are complementary, and both are required for a database restore. Now, one of the files was on my old laptop, which I'd had to return (a risky strategy in any case you might observe, having only one backup and having deleted the main database, and the backup,  from the old laptop).

I was unable to restore from the single file on my local external hard drive, at which point I started to get seriously worried. Luckily our IT support was able to recover the deleted back up file on the old laptop, and copy it to me. A lesson learned - the hard way.

None of this of course helps to explain the original problem of the "invalid class string" error when trying to install Recorder directly onto the 2008 R2 instance.

Cheers

Alan

Alan Hale
Aberystwyth

12 (edited by MikeWeideli 11-01-2011 10:08:56)

Re: R6.15 won't install

Thanks Alan for the update. I have installed SQl Server 2008 R2 on a Windows 7 machine  and have managed to duplicate the problem. By using the Configurtion tools to turn on TCPIP and Named Pipes I have beeb able to get a standalone copy of Recorder to install. At this stage it looks OK, I haven't done any comprehensive checks, but the basic functionality works, including rucksack and recording cards and import and export.

Suprisingly, backup and restore also work which they do not do on my other Windows 7/Sql Server 2008 installation.

The Network version failed to install when trying to attach the database.


Mike

Mike Weideli

13

Re: R6.15 won't install

Thanks Mike, interesting. I suppose the question arises - are there any significant advantages in using SQL Server 2008 R2 over 2005, or over 2008 "R1". Has anyone looked into this?

Alan Hale
Aberystwyth

14

Re: R6.15 won't install

On standalone systems I can't see any advantages in running SQL Server 2008 as far as Recorder is concerned. I have machines running Recorder under SQL Server 2000, 2005 and 2008 and wouldn't say that  I can detect any difference in performance. There do seem to be less issues with SQL Server 2005 installations.

SQL Server Management tools 2008  have some nice features which help with writing queries (eg for use in XML reports), but the2008  tools work with all versions. The main thing about SQL  Server  2008  is that it has spatial data types. While Recorder isn't making use of these they could be utilised in various  ways outside Recorder for use with GIS  systems etc.

The situation might be different on network installations
.

Mike Weideli

15

Re: R6.15 won't install

Thanks Mike. Yes, I have found the enhanced Management tools useful, and spatial data types are a feature we might well make use of in the future.

There is an article here: http://www.databasejournal.com/features/mssql/article.php/3792476/Performance-Testing--SQL-Server-2008-versus-SQL-Server-2005.htm  describing tests which showed no significant performance differences.

Alan

Alan Hale
Aberystwyth