Simulating MySql OLD_PASSWORD in .NET or MS SQL ?

Question

I have started a new project in .NET which uses some old system's datababase in MySql. The data stored in mysql is periodicaly transfered to MS Sql on which our system works. I need to authenticate users with their login and password. User's passwords are stored as hash generated by OLD_PASSWORD function from mysql. Is there any way to generate such hash using Ms Sql or .NET ?

Answer 1

Here is a Perl module that emulates MySQL's password() function for both 4.0 and prior (which is now OLD_PASSWORD() function) and 4.1 and higher.

While I realize that it's not .NET :-) that's the only piece of code (besides MySQL source)I found when I was looking for this, although I needed Java implementation. It worked for me and helped with migration - perhaps you'll be able to port it to .NET or run it as external process.