在.NET或MS SQL中模拟MySql OLD_PASSWORD? [英] Simulating MySql OLD_PASSWORD in .NET or MS SQL?

问题描述

我已经在.NET中启动了一个新项目，该项目在MySql中使用了一些旧系统的数据库. mysql中存储的数据会定期传输到我们的系统可以在其上运行的MS Sql. 我需要使用他们的登录名和密码对用户进行身份验证.用户的密码存储为mysql的OLD_PASSWORD函数生成的哈希值. 有没有办法使用Sql或.NET生成此类哈希?

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 ?

推荐答案

我在

这篇关于在.NET或MS SQL中模拟MySql OLD_PASSWORD?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！