I am in the middle of building a replacement to our production database box. I've followed the steps below:
Install Win 2003 Std (Non-R2)
Install SQL 2000
Install xp_regex package and check DLL location/permissions
Configure client software.
I managed to access the software/database with no problems whatsoever.
I then continued to upgrade to SQL Server 2005 Standard, and after some re-configuing work I was able to connect to the client software. Now, whenever I try to save certain information (Job Record) I get the following error:
"Could not save the information
Details: Could not load the DLL C:\program Files\Microsoft SQL Server\MSSQL\Binn\xp_regex
.dll, or one of the DLLs it references. Reason: 1114(error not found)."
This error has only appeared since installed SQL 2005, so I assume there is a compatibility issue between xp_regex and SQL 2005. xp_regex needs to be running for the client software to work properly.
I've been referred to http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q322884
previously and all attempts to clear the error have failed.
I need to get the database running on SQL 2005 (as 2000 is soon to become unsupported) and all that's stopping me is this one error and it's beginning to drive me mad.
Please could someone have a look at it, and offer advice as I'm running out of things to try in order to resolve the error.
Thanks in advance!