Enterprise Analyzer Clipper Search Fails When Using Regular Expressions
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.
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