Topic: Transfer of Recorder 6 to a new Server
We have transferred Recorder 6 to a new Server. However, I have lost the ability to make changes via Access. How do I fix ?(Error message is: ODBC -connection to 'SQL Server... failed'.)
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → Transfer of Recorder 6 to a new Server
We have transferred Recorder 6 to a new Server. However, I have lost the ability to make changes via Access. How do I fix ?(Error message is: ODBC -connection to 'SQL Server... failed'.)
There is a batch file together with some instructions at http://jncc.defra.gov.uk/page-5005
If this fails then the link can be set up manually.
Cheers, we will progress. Are there any other files that I may have lost a link to/with after the transfer that now need to be 'manually' reassigned?
My colleague downloaded the tool and ran it. It appears that this tool is designed for a standalone installation. When he gave it the parameters for our system it failed to find the sql database and the error log said this.
Exception occurred in application Recorder Database Migration at 06/07/2017 10:00:10.
Version : 6.13.3.179
Exception path:
EOleSysError : Invalid class string
Operating System : Windows XP 6.02.9200
Physical Memory available : 2,097,151 KB
DLLs loaded:
advapi32.dll (10.0.15063.0)
comctl32.dll (6.10.15063.0)
comdlg32.dll (10.0.15063.0)
gdi32.dll (10.0.15063.0)
kernel32.dll (10.0.15063.0)
mpr.dll (10.0.15063.0)
ole32.dll (10.0.15063.0)
oleaut32.dll (10.0.15063.0)
user32.dll (10.0.15063.0)
version.dll (10.0.15063.0)
All thoughts welcomed.
Was wondering if anyone had the opportunity to consider why the fix that was typically applicable did not work? Is there something about the set-up that we use that now needs to be factored. All help appreciated.
It easiest way around this is to set up a manual link. The link R6 creates is nothing more than an ODBC link to SQL Server which only takes a few minutes to create manually . How this is done will vary a bit with operating system, but basically set up an OSBC link to the SQL instance using control panel - you will be able to test this during set up. Then in MS Access link the tables using the ODBC link.
Cheers. I will ask ICT to progress.
Forum → How Do I... & Other Questions → Transfer of Recorder 6 to a new Server
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.