I have now made more attempts to transfer data from Recorder 2002 to Recorder 6 with a SQL Server 2005 Express installation of Recorder 6. Start – All Programs – Microsoft SQL Server 2005 – Configuration Tools – SQL Server Surface Area Configuration – select Surface Area Configuration for Features revealed that Ad Hoc Remote Queries and xp_cmdshell were both enabled and checking my notes confirmed that I had installed SQL Server 2005 Express Edition SP2 on my laptop but the transfer failed with the message “ODBC--connection to ‘SQL ServerSALLY-44306DEEB\RECORDER6’ failed”.
On my laptop I have MSDE on the D: drive and SQL Server 2005 Express Edition SP2 on the C: but when I checked SQL Server Service Manager I discovered that it was the MSDE instance that was running so I swapped over to running the SQL Server Express instance. Another attempt at transferring data failed with the same ODBC message as above.
I then checked the registry and found that trusted security was set to 0 so I made the following changes:
HKEY_LOCAL_MACHINE\SOFTWARE\Dorset Software\Recorder 6 Server: set Trusted Security to 1
HKEY_LOCAL_MACHINE\SOFTWARE\Dorset Software\Recorder 6: set Trusted Security to 1
Another attempt at transferring data failed with the same ODBC message as above.
I then enabled CLR Integration (Common language runtime) and OLE Automation in Surface Area Configuration for Features. Another attempt at transferring data failed with the same ODBC message as above. In each of the attempts so far the transfer ran for about 10 minutes before producing the message but no data was transferred.
I then selected D:\Recorder 2002 – right clicked and selected Sharing and Security – ticked Share this folder on the network and Allow network users to change my files (under Network sharing and security). This time the transfer failed with the same ODBC message as above but this time it ran for about an hour before producing the message and on checking the statistics on the Welcome screen and the number of rows in 18 tables in Recorder 6, the data appears to have transferred with the exception of the items in UpgradeErrors.mdb. Also, the items in this file were the same as for a transfer done on the same data with a SQL Server 2000 installation of Recorder 6. In this case the transfer concluded satisfactorily with a “Data Migration Complete” window – there was no ODBC connection failure message.
Can anyone shed any light on this message and its implications? SALLY-44306DEEB\RECORDER6 is the name of the instance on my desktop whereas the instance names on my laptop are SONYVGN-S5XP\RECORDER (MSDE) and SONYVGN-S5XP\SQLEXPRESS, yet all these tests have been done on my laptop, many miles from my desktop. I also got this message on another transfer I did soon after the v6.10.4 installation CDs came out but in this case the instance name was not one that had been on any of my computers.
Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687