Re: Problems with Recorder 6 Import
This is just for information, in case anyone else has a similar problem - it has now been solved.
Since installing Recorder 6 using SQL Server 5 Express on a network, I have been unable to import data getting the error message:
Exception path:
EOleException : ODBC--insert on a linked table 'SQLSERVER_SURVEY_EVENT' failed
EDBMergerError : Error occurred transferring records for SQLSERVER_SURVEY_EVENT into the main database
After long discussions with Sally Rankin we decided it had to be a SQL Server permissions problem, but finding the incorrect permission was more difficult - NBNUser was identical to that on Sally's machine.
I eventually found that it was my computer log-on user, which although I'd set it up at top level, able to create databases, it had little or no permissions in Recorder - this didn't seem to bother Recorder under normal useage, but it fell over if I tried to import or to add plug-ins.
Giving my log-on the same permissions within NBNData as NBNUser appears to have solved the problem!
Craig
Staffordshire Ecological Record