NOTICE: Our Community is moving. Get more information. Updated information on a New Login Process
When client performs Clipper search using regular expressions, client receives following errorRun-time error '-2147219503 (800407d1)':Cannot find either column '"dbo" or the user-defined function or aggregrate "dbo.RegexMatch", or the name is ambiguousThe 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#g692318MSSQL - http://msdn.microsoft.com/en-us/library/az24scfc.aspx