How do I make xp_pcre work on a 64 bit system?
We have been using xp_pcre for regular expressions in sql server for years:
xp_pcre - Regular expressions in T-SQL
I just upgraded to a new Vista 64 bit development machine and installed xp pcre. Unfortunately, when I try to use sprocs, I get the following error: Unable to load DLL xp_pcre.dll or one of the DLLs it references. Cause: 193 (% 1 is not a valid Win32 application.).
Has anyone managed to install xp_pcre on a 64-bit Vista machine? Any advice? Thanks in advance, Shane
source to share
Since this is a compiled DLL, you will probably have to recompile it to get a 64-bit DLL that can run on your 64-bit machine. Since nothing on this page has been updated since 2005, it is unlikely that a 64-bit version is already available. However, since the source code is included, you can, if you have VS for C ++, with a 64-bit compiler, compile it yourself and try to get it to work that way.
source to share