Enterprise Analyzer Clipper Search Fails When Using Regular Expressions

Problem:

When client performs Clipper search using regular expressions, client receives following error

Run-time error '-2147219503 (800407d1)':

Cannot find either column '"dbo" or the user-defined function or aggregrate "dbo.RegexMatch", or the name is ambiguous

The attempted query contains a regular expression in the search string.

Resolution:

Regular expressions are treated differently on SQL Server than they are for Oracle.  This issue is only expected to occur on SQL Server workspaces.

For MS SQL Server, client will need to install a special external package, which can be obtained from Supportline.  This will need to be done on the SQL Server.

In addition, there are significant differences in regular expression syntax between Oracle and MS SQL implementations.

Below are links to the online documentation for each DB.

Oracle - http://docs.oracle.com/cd/B12037_01/server.101/b10759/ap_posix001.htm#i690533 and http://docs.oracle.com/cd/B12037_01/server.101/b10759/ap_posix002.htm#g692318

MSSQL - http://msdn.microsoft.com/en-us/library/az24scfc.aspx