1 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Moving R6 to new computer

Hi

I am wanting to move R6 from an old XP computer to a new Win7 64-bit one. To help, I have loaded Virtual PC and XP Compatibility Mode and have managed to load R6 to the version I have on the old computer (v6.14.4.212) and Dictionary J. I looked on the Recorder part of the NBN website but was not able to track down any advice on moving from one computer to another.

However, the disk that I have to hand is called one site number (for which I have the verification key) and the version on the old computer is an older site number (for which I now cannot find the verification key).

I had hoped to be able to copy the main database files from one computer to the other and then open up with the data, observers, locations, etc all in place. How foolish I am, to think such a thing. I copied the database and ldb files to the MSSQL\Data folder and the Access datafiles to the R6|Database folder.

When I tried to start to start R6 I get the message:

An error occurred whilst starting the application.
EOLeException: Cannot open database requested in login 'NBNDaqta'. Login fails.


I'm not sure how to proceed. There are several possibilities:

- As the new location is different from that in the old computer, the new instance of R6 will never open a database set up by another.

- Even if I tried to use the Backup facility on the old, I cannot open the new to try to 'restore' the database.

It seems that my only option is to uninstall R6 and start again, but without the original verification code, I am not sure what to do.

Can anyone suggest a way forward such that I may successfully move from one computer to another?

I seem to be worse than snookered at the moment. Is there a way out?

Thanks, Ian

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Moving R6 to new computer

Firstly it doesn't matter which site id you installed the new copy of Recorder under as the site id  is in the database, so once the original database is connected this will be put right.

This transfer should be easy enough to do, but it will be much easier with SQL Server Management Tools installed.

Can you let me know if you have installed these to save me having to explain what to do.

I assume you loaded SQL server from the Cd. can you confrm this please.

If your installation is much the same we might be able to get away with using MsAccess to complete the transfer.

Mike Weideli

MikeWeideli's Website

3 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Moving R6 to new computer

Hi Mike

Good to hear from you. I don't seem to have SQL server management tools loaded (it is a stand alone desktop) and I am not sure where I would get these tools.

Looking on the CD I have (dated April 2006) I see there is folder called MSDE then a subfolder called MSM that has a file called TOOLS.MSM. Is that what I should be looking for? There seems to be nothing called SQL Server Management Tools in the CD.

I look forward to hearing from you.

Thanks, Ian

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Moving R6 to new computer

Ian

If you can phone me on 01635 820904  (evening will be fine) I will try and help you sort this.

Mike

Mike Weideli

MikeWeideli's Website

5 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Moving R6 to new computer

Hi Mike

Very many thanks for getting this sorted. The disk arrived this am and installed easily. Should I now upgrade to the latest version and latest dictionary or should I leave this for another day?

Again, I am very grateful for your help. The version you sent v6.15.4b is working in Win 7 64-bit so I am delighted about that.

All the best, Ian:)

6 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Moving R6 to new computer

Hi

The installation I did with Mike's disk seemed to go well but I found that it didn't work when I tried to edit some data. A phone conversation with Mike sorted out that issue. When installing R6 under Win7 64-bit, the 'Application Files' must be saved in a folder that is NOT under Program files. Once this change was made, I was able to edit data. I thank Mike for his patience in helping me to get this sorted.

However, Mike thought there might be an issue with creating backups and unfortunately, he was correct. I wanted to select a backup folder but was unable to do so and the report, below, is the error report. I don't understand any of it. To be able to use R6 fully, I need to be able to choose where to put my backup file and then for the create backup to work. I don't know about the latter as I have not got there yet. Can anyone see what needs doing to allow me to choose a backup location?

Thanks in anticipation, Ian

date/time         : 2011-07-26, 18:35:37, 547ms
computer name     : IANDESKTOP-PC
user name         : Ian Desktop
operating system  : Windows NT New Service Pack 1 build 7601
system language   : English
system up time    : 44 minutes 23 seconds
program up time   : 24 seconds
processors        : 4x Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz
physical memory   : 0/0 MB (free/total)
free disk space   : (C:) 1741.02 GB
display mode      : 1920x1080, 32 bit
process id        : $15c8
allocated memory  : 48.93 MB
command line      : RecorderApp.exe /1245938
executable        : RecorderApp.exe
exec. date/time   : 2010-07-22 16:40
version           : 6.15.4.238
madExcept version : 2.7h
exception class   : EAccessViolation
exception message : Access violation at address 0058C110 in module 'RecorderApp.exe'. Read of address 00000020.

main thread ($1084):
0058c110 RecorderApp.exe Treecoll       761  +1 TTreeCollection.GetCount
005a3609 RecorderApp.exe RapTree       6049  +2 TFlyNode.getFirstChild
0099625c RecorderApp.exe ServerFolders  211 +21 TdlgServerFolders.SetPath
009ed25e RecorderApp.exe Maintbar      1555 +28 TfrmMain.mnuToolsChangeBackupLocationClick
004c3276 RecorderApp.exe Menus                  TMenuItem.Click
004c4513 RecorderApp.exe Menus                  TMenu.DispatchCommand
004c52ca RecorderApp.exe Menus                  TPopupList.WndProc
004cf94c RecorderApp.exe Controls               TWinControl.MainWndProc
004c5219 RecorderApp.exe Menus                  TPopupList.MainWndProc
00453460 RecorderApp.exe Classes                StdWndProc
75337bc5 user32.dll                             DispatchMessageA
004bc12b RecorderApp.exe Forms                  TApplication.ProcessMessage
004bc162 RecorderApp.exe Forms                  TApplication.HandleMessage
004bc392 RecorderApp.exe Forms                  TApplication.Run
00a33a20 RecorderApp.exe RecorderApp    375 +83 initialization
767c3398 kernel32.dll                           BaseThreadInitThunk

thread $15a0:
77bf014d ntdll.dll                 
76d50bd7 KERNELBASE.dll            WaitForMultipleObjectsEx
767c1a27 kernel32.dll              WaitForMultipleObjectsEx
75340864 user32.dll                MsgWaitForMultipleObjectsEx
75340b64 user32.dll                MsgWaitForMultipleObjects
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
767c3398 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($1084) at:
6feb78a9 gdiplus.dll               

thread $40c:
77bf014d ntdll.dll     
767c3398 kernel32.dll  BaseThreadInitThunk

thread $b44:
77bf1f36 ntdll.dll     
767c3398 kernel32.dll  BaseThreadInitThunk

thread $7e4:
77bf1f36 ntdll.dll     
767c3398 kernel32.dll  BaseThreadInitThunk

thread $eec:
77befd81 ntdll.dll                 
76d531b5 KERNELBASE.dll            SleepEx
76d53a86 KERNELBASE.dll            Sleep
0042aba7 RecorderApp.exe madExcept ThreadExceptFrame
767c3398 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($1084) at:
76e3da8e ole32.dll                 

thread $b74:
77bef8c1 ntdll.dll       
76d50a8b KERNELBASE.dll  WaitForSingleObjectEx
767c118f kernel32.dll    WaitForSingleObjectEx
767c1143 kernel32.dll    WaitForSingleObject
767c3398 kernel32.dll    BaseThreadInitThunk

modules:
001c0000 MS5User.Dll          5.0.0.4            C:\Recorder6
00400000 RecorderApp.exe      6.15.4.238         C:\Recorder6
00d60000 C4DLL.DLL            1.0.0.1            C:\Recorder6
00f60000 ms5cnv.dll           5.0.0.10           C:\Recorder6
04990000 GoToGridControl.ocx  2.0.0.16           C:\Recorder6\Addins
04c40000 ShowUnchecked.ocx    6.0.0.13           C:\Recorder6\Addins
04f00000 GoToKey.ocx          6.0.1.10           C:\Recorder6\Addins
06d50000 StdValLib.dll        6.14.3.208         C:\Recorder6\Addins
10000000 MS5.Dll              5.0.0.12           C:\Recorder6
5b1f0000 msadce.dll           6.1.7601.17514     C:\Program Files (x86)\Common Files\System\msadc
5b280000 sqloledb.dll         6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
5b370000 comsvcs.dll          2001.12.8530.16385 C:\Windows\system32
5f3c0000 oledb32.dll          6.1.7601.17514     C:\Program Files (x86)\Common Files\System\Ole DB
64a40000 SXS.DLL              6.1.7601.17514     C:\Windows\system32
69b10000 msxml4.dll           4.20.9876.0        c:\Windows\SysWOW64
6a130000 msadcer.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\msadc
6a140000 DBNETLIB.DLL         6.1.7600.16385     C:\Windows\system32
6a1f0000 MSDATL3.dll          6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
6a210000 ATL.DLL              3.5.2284.0         C:\Windows\system32
6a230000 msado15.dll          6.1.7601.17514     C:\Program Files (x86)\Common Files\System\ado
6a330000 HHCtrl.ocx           6.1.7600.16385     C:\Windows\system32
6b010000 SHFolder.dll         6.1.7600.16385     C:\Windows\system32
6b900000 odbcint.dll          6.1.7600.16385     C:\Windows\system32
6bb60000 odbc32.dll           6.1.7601.17514     C:\Windows\system32
6e040000 comctl32.dll         5.82.7601.17514    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7601.17514_none_ec83dffa859149af
6fce0000 mpr.dll              6.1.7600.16385     C:\Windows\system32
6fe70000 gdiplus.dll          6.1.7601.17514     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7601.17514_none_72d18a4386696c80
700a0000 OLEDB32R.DLL         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
70230000 uxtheme.dll          6.1.7600.16385     C:\Windows\system32
70310000 dwmapi.dll           6.1.7600.16385     C:\Windows\system32
70360000 MSDART.DLL           6.1.7600.16385     C:\Windows\system32
70400000 bcryptprimitives.dll 6.1.7600.16385     C:\Windows\SysWOW64
709a0000 SQLOLEDB.RLL         6.1.7600.16385     C:\Program Files (x86)\Common Files\System\Ole DB
70c90000 bcrypt.dll           6.1.7600.16385     C:\Windows\system32
70cb0000 ncrypt.dll           6.1.7600.16385     C:\Windows\system32
70d90000 ntdsapi.dll          6.1.7600.16385     C:\Windows\system32
712c0000 security.dll         6.1.7600.16385     C:\Windows\system32
712d0000 schannel.dll         6.1.7601.17514     C:\Windows\SysWOW64
713a0000 cryptdll.dll         6.1.7600.16385     C:\Windows\system32
713c0000 msv1_0.DLL           6.1.7601.17514     C:\Windows\SysWOW64
71410000 credssp.dll          6.1.7601.17514     C:\Windows\system32
717d0000 Comctl32.dll         6.10.7601.17514    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.17514_none_41e6975e2bd6f2b2
71c70000 rsaenh.dll           6.1.7600.16385     C:\Windows\system32
71cb0000 CRYPTSP.dll          6.1.7600.16385     C:\Windows\system32
72280000 RpcRtRemote.dll      6.1.7601.17514     C:\Windows\system32
724b0000 SECUR32.DLL          6.1.7601.17514     C:\Windows\system32
72860000 wkscli.dll           6.1.7601.17514     C:\Windows\system32
72870000 srvcli.dll           6.1.7601.17514     C:\Windows\system32
72890000 netutils.dll         6.1.7601.17514     C:\Windows\system32
728a0000 NETAPI32.dll         6.1.7601.17514     C:\Windows\system32
73900000 version.dll          6.1.7600.16385     C:\Windows\system32
739e0000 profapi.dll          6.1.7600.16385     C:\Windows\system32
73a20000 wsock32.dll          6.1.7600.16385     C:\Windows\system32
75030000 winmm.dll            6.1.7601.17514     C:\Windows\system32
750f0000 winspool.drv         6.1.7601.17514     C:\Windows\system32
75210000 olepro32.dll         6.1.7601.17514     C:\Windows\system32
75240000 DBnmpNTw.dll         6.1.7600.16385     C:\Windows\system32
752b0000 CRYPTBASE.dll        6.1.7600.16385     C:\Windows\syswow64
752c0000 SspiCli.dll          6.1.7601.17514     C:\Windows\syswow64
75320000 user32.dll           6.1.7601.17514     C:\Windows\syswow64
75420000 RPCRT4.dll           6.1.7601.17514     C:\Windows\syswow64
75510000 msvcrt.dll           7.0.7600.16385     C:\Windows\syswow64
75700000 shell32.dll          6.1.7601.17514     C:\Windows\syswow64
764f0000 IMM32.DLL            6.1.7601.17514     C:\Windows\system32
765e0000 oleaut32.dll         6.1.7601.17567     C:\Windows\syswow64
76670000 GDI32.dll            6.1.7601.17514     C:\Windows\syswow64
76700000 LPK.dll              6.1.7600.16385     C:\Windows\syswow64
76710000 ADVAPI32.dll         6.1.7601.17514     C:\Windows\syswow64
767b0000 kernel32.dll         6.1.7601.17617     C:\Windows\syswow64
768c0000 SHLWAPI.dll          6.1.7601.17514     C:\Windows\syswow64
76920000 MSCTF.dll            6.1.7600.16385     C:\Windows\syswow64
76a00000 sechost.dll          6.1.7600.16385     C:\Windows\SysWOW64
76a20000 USP10.dll            1.626.7601.17561   C:\Windows\syswow64
76b50000 CRYPT32.dll          6.1.7601.17514     C:\Windows\syswow64
76c70000 NSI.dll              6.1.7600.16385     C:\Windows\syswow64
76cd0000 WS2_32.dll           6.1.7601.17514     C:\Windows\syswow64
76d40000 KERNELBASE.dll       6.1.7601.17625     C:\Windows\syswow64
76d90000 comdlg32.dll         6.1.7601.17514     C:\Windows\syswow64
76e10000 ole32.dll            6.1.7601.17514     C:\Windows\syswow64
77130000 MSASN1.dll           6.1.7601.17514     C:\Windows\syswow64
77280000 CLBCatQ.DLL          2001.12.8530.16385 C:\Windows\syswow64
77bd0000 ntdll.dll            6.1.7601.17514     C:\Windows\SysWOW64

7 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Moving R6 to new computer

I have posted a message on the subject of backups in Windows 7 installations at http://forums.nbn.org.uk/viewtopic.php?pid=9381#p9381 . Please let us know if that doesn’t resolve your problems.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

8 Reply by Ian M Spence

  • Ian M Spence
  • Veteran
  • Offline
  • From: North east Wales
  • Registered: 30-06-2006
  • Posts: 193

Re: Moving R6 to new computer

Hi Sally

Many thanks for your post and help on the phone. To get the backup to work I downloaded and installed the file SQLServer2005_SSMSEE_x64.msi.

From Start, Program Files I ran it as Administrator and followed Sally's instructions. When I eventually ran R6 to choose the Backup location I wasn't able to see the folder I wanted, so on Sally's advice I just did the backup and it worked! In order to see the backup file in Windows Explorer I had a permissions message, clicked Continue and was able see the file and then create a zipped version of it.

So, again, I thank both Mike and Sally for their help with this most complicated database!

With best wishes, Ian