1 Reply by charliebarnes (edited by charliebarnes 10-08-2011 09:45:26)

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Matching boundaries to locations

When trying to match imported map boundaries to locations using "automatic matching" and it not finding any matches I get the following error:

date/time         : 2011-08-10, 10:41:16, 3ms
computer name     : LBP2
user name         : charliebarnes
operating system  : Windows 7 build 7600
system language   : English
system up time    : 1 hour 28 minutes 
program up time   : 37 minutes 8 seconds 
processors        : 2x Intel(R) Core(TM)2 Duo CPU     E7500  @ 2.93GHz
physical memory   : 1535/3037 MB (free/total)
free disk space   : (C:) 164.75 GB
display mode      : 1280x1024, 32 bit
process id        : $13fc
allocated memory  : 50.90 MB
executable        : RecorderApp.exe
exec. date/time   : 2011-01-18 14:50
version           : 6.16.2.241
madExcept version : 2.7k
exception class   : EJNCCDatabaseError
exception message : Unable to perform the manual match..

main thread ($166c):
005c514c RecorderApp.exe DatabaseAccessADO     918 +26 TdmDatabase.ExecuteSQL
009d5675 RecorderApp.exe BoundaryLocationMatch 657 +40 TdlgBoundaryLocationMatch.eMatchValueFindData
00654f4d RecorderApp.exe AddinLinkedControls   195  +3 TAddinLinkedEdit.EditKeyPressed
004b879f RecorderApp.exe Controls                      TWinControl.KeyPress
004b87ee RecorderApp.exe Controls                      TWinControl.DoKeyPress
004b8816 RecorderApp.exe Controls                      TWinControl.WMChar
004b422c RecorderApp.exe Controls                      TControl.WndProc
004b728b RecorderApp.exe Controls                      TWinControl.WndProc
004b6f08 RecorderApp.exe Controls                      TWinControl.MainWndProc
004529d0 RecorderApp.exe Classes                       StdWndProc
761f3573 user32.dll                                    DispatchMessageA
004d527b RecorderApp.exe Forms                         TApplication.ProcessMessage
004d52b2 RecorderApp.exe Forms                         TApplication.HandleMessage
004d54e2 RecorderApp.exe Forms                         TApplication.Run
00a32904 RecorderApp.exe RecorderApp           422 +83 initialization
75941112 kernel32.dll                                  BaseThreadInitThunk

thread $1088:
77316344 ntdll.dll                 KiFastSystemCallRet
77315caa ntdll.dll                 NtWaitForMultipleObjects
754c68c6 KERNELBASE.dll            WaitForMultipleObjectsEx
7593f0c5 kernel32.dll              WaitForMultipleObjectsEx
761f90b8 user32.dll                MsgWaitForMultipleObjectsEx
761f59f9 user32.dll                MsgWaitForMultipleObjects
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
75941112 kernel32.dll              BaseThreadInitThunk
>> created by main thread ($166c) at:
73e678b3 gdiplus.dll               

thread $1504:
77316344 ntdll.dll     KiFastSystemCallRet
77315caa ntdll.dll     NtWaitForMultipleObjects
75941112 kernel32.dll  BaseThreadInitThunk

thread $f44:
77316344 ntdll.dll     KiFastSystemCallRet
77315caa ntdll.dll     NtWaitForMultipleObjects
75941112 kernel32.dll  BaseThreadInitThunk

thread $1738:
77316344 ntdll.dll       KiFastSystemCallRet
77315cca ntdll.dll       NtWaitForSingleObject
754c1796 KERNELBASE.dll  WaitForSingleObjectEx
7593ef9e kernel32.dll    WaitForSingleObjectEx
7593ef4d kernel32.dll    WaitForSingleObject
75941112 kernel32.dll    BaseThreadInitThunk

thread $15d8:
77316344 ntdll.dll                 KiFastSystemCallRet
77314a7a ntdll.dll                 NtDelayExecution
754c1870 KERNELBASE.dll            SleepEx
754c1813 KERNELBASE.dll            Sleep
0042b939 RecorderApp.exe madExcept CallThreadProc
0042b97b RecorderApp.exe madExcept ThreadExceptFrame
75941112 kernel32.dll              BaseThreadInitThunk
>> created by thread $bd8 at:
75cc64f2 ole32.dll                 

thread $6fc:
77316344 ntdll.dll     KiFastSystemCallRet
77315cda ntdll.dll     NtWaitForWorkViaWorkerFactory
75941112 kernel32.dll  BaseThreadInitThunk

modules:
00160000 MS5User.Dll            5.0.0.4            C:\Program Files\Recorder 6 Server
00300000 C4DLL.DLL              1.0.0.1            C:\Program Files\Recorder 6 Server
003b0000 ms5cnv.dll             5.0.0.10           C:\Program Files\Recorder 6 Server
00400000 RecorderApp.exe        6.16.2.241         C:\Program Files\Recorder 6 Server
01d30000 SysHook.dll            1.0.3005.0         C:\Program Files\Acer\Acer PowerSaver
05ad0000 GoToKey.ocx            6.0.1.10           C:\PROGRA~1\RECORD~1\Addins
05cf0000 SHOWUN~1.OCX           6.0.0.13           C:\PROGRA~1\RECORD~1\Addins
05f00000 SURVEY~1.OCX           6.0.0.25           C:\PROGRA~1\RECORD~1\Addins
06320000 GROOVEEX.DLL           14.0.4761.1000     C:\PROGRA~1\MICROS~2\Office14
06fb0000 office.odf             14.0.5138.5000     C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\Cultures
10000000 MS5.Dll                5.0.0.12           C:\Program Files\Recorder 6 Server
5dd10000 olepro32.dll           6.1.7600.16385     C:\Windows\system32
60f80000 SnacNp.dll             11.0.6100.442      C:\Program Files\Symantec\Symantec Endpoint Protection
616d0000 ieframe.DLL            8.0.7600.16800     C:\Windows\system32
639c0000 StructuredQuery.dll    7.0.7600.16587     C:\Windows\System32
63a20000 comsvcs.dll            2001.12.8530.16385 C:\Windows\system32
63b60000 OLEDB32R.DLL           6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
63b80000 oledb32.dll            6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
63c60000 ieproxy.dll            8.0.7600.16800     C:\Program Files\Internet Explorer
63d70000 SearchFolder.dll       6.1.7600.16385     C:\Windows\system32
687d0000 RICHED20.dll           5.31.23.1229       C:\Windows\system32
68a10000 msado15.dll            6.1.7600.16688     C:\Program Files\Common Files\System\ado
68e90000 tiptsf.dll             6.1.7600.16385     C:\Program Files\Common Files\microsoft shared\ink
68f90000 GrooveIntlResource.dll 14.0.4761.1000     C:\PROGRA~1\MICROS~2\Office14\1033
69b10000 msxml4.dll             4.20.9876.0        C:\Windows\system32
6a2a0000 SHDOCVW.dll            6.1.7600.16385     C:\Windows\system32
6a2d0000 ntshrui.dll            6.1.7600.16385     C:\Windows\system32
6a340000 RICHED32.DLL           6.1.7600.16385     C:\Windows\system32
6a350000 LINKINFO.dll           6.1.7600.16385     C:\Windows\system32
6a360000 actxprxy.dll           6.1.7600.16385     C:\Windows\system32
6a440000 CSCDLL.dll             6.1.7600.16385     C:\Windows\System32
6a450000 cscui.dll              6.1.7600.16385     C:\Windows\System32
6a780000 ATL90.DLL              9.0.30729.6161     C:\Windows\WinSxS\x86_microsoft.vc90.atl_1fc8b3b9a1e18e3b_9.0.30729.6161_none_51cd0a7abbe4e19b
6a7b0000 EhStorShell.dll        6.1.7600.16385     C:\Windows\system32
6a860000 davclnt.dll            6.1.7600.16385     C:\Windows\System32
6a880000 ntlanman.dll           6.1.7600.16385     C:\Windows\System32
6ae50000 MSDART.DLL             6.1.7600.16385     C:\Windows\system32
6c700000 DAVHLPR.dll            6.1.7600.16385     C:\Windows\System32
6c9c0000 drprov.dll             6.1.7600.16385     C:\Windows\System32
6d390000 cscapi.dll             6.1.7600.16385     C:\Windows\system32
6d420000 msadce.dll             6.1.7600.16385     C:\Program Files\Common Files\System\msadc
6d4d0000 thumbcache.dll         6.1.7600.16385     C:\Windows\system32
6e070000 security.dll           6.1.7600.16385     C:\Windows\system32
6eae0000 MSVCP90.dll            9.0.30729.6161     C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57
6ecf0000 SHFolder.dll           6.1.7600.16385     C:\Windows\system32
6ee60000 mpr.dll                6.1.7600.16385     C:\Windows\system32
6ee90000 winspool.drv           6.1.7600.16385     C:\Windows\system32
6ff70000 MSVCR90.dll            9.0.30729.6161     C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57
71dc0000 ntdsapi.dll            6.1.7600.16385     C:\Windows\system32
71ed0000 comctl32.dll           5.82.7600.16661    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.7600.16661_none_ebfb56996c72aefc
72420000 rasadhlp.dll           6.1.7600.16385     C:\Windows\system32
72a90000 fwpuclnt.dll           6.1.7600.16385     C:\Windows\System32
72ea0000 OLEACC.dll             7.0.0.0            C:\Windows\system32
72ee0000 WINNSI.DLL             6.1.7600.16385     C:\Windows\system32
72ef0000 IPHLPAPI.DLL           6.1.7600.16385     C:\Windows\system32
73130000 sqloledb.dll           6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
73250000 HHCtrl.ocx             6.1.7600.16385     C:\Windows\system32
73430000 cscobj.dll             6.1.7600.16385     C:\Windows\System32
73460000 DBNETLIB.DLL           6.1.7600.16385     C:\Windows\system32
73490000 NetworkExplorer.dll    6.1.7600.16385     C:\Windows\system32
73640000 odbc32.dll             6.1.7600.16688     C:\Windows\system32
736f0000 msadcer.dll            6.1.7600.16385     C:\Program Files\Common Files\System\msadc
73740000 odbcint.dll            6.1.7600.16385     C:\Windows\system32
73790000 SQLOLEDB.RLL           6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
737a0000 MSDATL3.dll            6.1.7600.16385     C:\Program Files\Common Files\System\Ole DB
737d0000 WindowsCodecs.dll      6.1.7600.16385     C:\Windows\system32
73a80000 slc.dll                6.1.7600.16385     C:\Windows\system32
73b50000 dwmapi.dll             6.1.7600.16385     C:\Windows\system32
73bb0000 winmm.dll              6.1.7600.16385     C:\Windows\system32
73e20000 gdiplus.dll            6.1.7600.16385     C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7600.16385_none_72fc7cbf861225ca
73fb0000 uxtheme.dll            6.1.7600.16385     C:\Windows\system32
74030000 Comctl32.dll           6.10.7600.16661    C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16661_none_420fe3fa2b8113bd
74300000 netbios.dll            6.1.7600.16385     C:\Windows\system32
74310000 propsys.dll            7.0.7600.16385     C:\Windows\system32
74850000 wshtcpip.dll           6.1.7600.16385     C:\Windows\System32
748d0000 ntmarta.dll            6.1.7600.16385     C:\Windows\system32
74900000 version.dll            6.1.7600.16385     C:\Windows\system32
74a30000 credssp.dll            6.1.7600.16385     C:\Windows\system32
74a60000 bcryptprimitives.dll   6.1.7600.16385     C:\Windows\system32
74aa0000 ATL.DLL                3.5.2284.0         C:\Windows\system32
74b40000 wkscli.dll             6.1.7600.16385     C:\Windows\system32
74b50000 netutils.dll           6.1.7600.16385     C:\Windows\system32
74b60000 NETAPI32.dll           6.1.7600.16385     C:\Windows\system32
74b80000 wsock32.dll            6.1.7600.16385     C:\Windows\system32
74c20000 USERENV.dll            6.1.7600.16385     C:\Windows\System32
74c40000 rsaenh.dll             6.1.7600.16385     C:\Windows\system32
74cb0000 schannel.DLL           6.1.7600.16661     C:\Windows\system32
74d20000 DNSAPI.dll             6.1.7600.16772     C:\Windows\system32
74e00000 msv1_0.DLL             6.1.7600.16420     C:\Windows\system32
74e50000 wship6.dll             6.1.7600.16385     C:\Windows\System32
74e60000 mswsock.dll            6.1.7600.16385     C:\Windows\system32
74ea0000 CRYPTSP.dll            6.1.7600.16385     C:\Windows\system32
74fb0000 bcrypt.dll             6.1.7600.16385     C:\Windows\system32
74fd0000 ncrypt.dll             6.1.7600.16385     C:\Windows\system32
75010000 srvcli.dll             6.1.7600.16385     C:\Windows\system32
750b0000 cryptdll.dll           6.1.7600.16385     C:\Windows\system32
751b0000 WINSTA.dll             6.1.7600.16385     C:\Windows\System32
75300000 SECUR32.DLL            6.1.7600.16385     C:\Windows\system32
75320000 SSPICLI.DLL            6.1.7600.16385     C:\Windows\system32
75350000 apphelp.dll            6.1.7600.16481     C:\Windows\system32
753a0000 CRYPTBASE.dll          6.1.7600.16385     C:\Windows\system32
753b0000 SXS.DLL                6.1.7600.16385     C:\Windows\system32
75410000 RpcRtRemote.dll        6.1.7600.16385     C:\Windows\system32
75420000 profapi.dll            6.1.7600.16385     C:\Windows\system32
754c0000 KERNELBASE.dll         6.1.7600.16823     C:\Windows\system32
75510000 DEVOBJ.dll             6.1.7600.16385     C:\Windows\system32
75530000 CFGMGR32.dll           6.1.7600.16385     C:\Windows\system32
75560000 CRYPT32.dll            6.1.7600.16385     C:\Windows\system32
75710000 WS2_32.dll             6.1.7600.16385     C:\Windows\system32
75750000 SETUPAPI.dll           6.1.7600.16385     C:\Windows\system32
758f0000 kernel32.dll           6.1.7600.16816     C:\Windows\system32
759d0000 MSCTF.dll              6.1.7600.16385     C:\Windows\system32
75ad0000 WLDAP32.dll            6.1.7600.16385     C:\Windows\system32
75b20000 msvcrt.dll             7.0.7600.16385     C:\Windows\system32
75bd0000 USP10.dll              1.626.7600.16385   C:\Windows\system32
75c70000 IMM32.DLL              6.1.7600.16385     C:\Windows\system32
75c90000 ole32.dll              6.1.7600.16624     C:\Windows\system32
75ef0000 CLBCatQ.DLL            2001.12.8530.16385 C:\Windows\system32
75fe0000 iertutil.dll           8.0.7600.16800     C:\Windows\system32
761e0000 user32.dll             6.1.7600.16385     C:\Windows\system32
762b0000 GDI32.dll              6.1.7600.16385     C:\Windows\system32
76300000 SHLWAPI.dll            6.1.7600.16385     C:\Windows\system32
76360000 RPCRT4.dll             6.1.7600.16385     C:\Windows\system32
76410000 shell32.dll            6.1.7600.16644     C:\Windows\system32
771a0000 advapi32.dll           6.1.7600.16385     C:\Windows\system32
77240000 oleaut32.dll           6.1.7600.16722     C:\Windows\system32
772d0000 ntdll.dll              6.1.7600.16695     C:\Windows\SYSTEM32
77410000 MSASN1.dll             6.1.7600.16415     C:\Windows\system32
77420000 sechost.dll            6.1.7600.16385     C:\Windows\SYSTEM32
77450000 NSI.dll                6.1.7600.16385     C:\Windows\system32
77460000 LPK.dll                6.1.7600.16385     C:\Windows\system32
77470000 PSAPI.DLL              6.1.7600.16385     C:\Windows\system32
77480000 comdlg32.dll           6.1.7600.16385     C:\Windows\system32

Exception Stack

----------------
EOleException : Incorrect syntax near 's'

Presumably because it's not escaping the ' in the site name,

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

2 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: Matching boundaries to locations

Yes, sound's like a problem I had before. No matching for any site that had an apostrophe. No apparent way round, but managed to manually match those that failed.

Gordon Barker
Biological Survey Data Manager
National Trust