Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
question regarding migrating hashed password to MSSQL via MySQL ODBC version 3.5

question regarding migrating hashed password to MSSQL via MySQL ODBC version 3.5

2006-08-29       - By Theresa Bradham

 Back
***********************
E-mail has been scanned for content & viruses by Somerset Investors Corp.
***********-***********


I hope I will finally find answers here. I have successfully used the
MySQL ODBC driver through DTS to migrate our user db from MySql to Sql
Server 2000. The only problem is that the passwords in the user table,
which are entered as MD5 hashed values are not carrying over. DTS
automatically converts the column to varchar. If I change the type in
the Transformations tab of DTS to varbinary on the MSSQL side I get an
activex error (Error during Transformation 'AxScriptXform' for Row
number 1. Errors encountered so far in this task: 1. ActiveX Scripting
Transform 'AxScriptXform' encountered an invalid data value for
'Password' destination column.)



Has anyone successfully moved hashed passwords to a MSSQL database? Any
suggestions??