Issues when login password has digits
evgkib
Posts: 8
I'm having issues when registering a database and the login password has digits.
Unhandled Exception: System.InvalidCastException: Unable to cast object of type
'System.DBNull' to type 'System.String'.
at #8rg.#Ssg.#2lh()
at #8rg.#Ssg.#wlh()
at RedGate.SQLCompare.Engine.Database.RegisterForDataCompare(ConnectionProper
ties connectionProperties, Options options)
at SQLDataCompareCodeSnippets.SyncData.RunExample(String db, String[] tables)
in c:\temp\RedGateDataSync\SyncData.cs:line 59
at SQLDataCompareCodeSnippets.Program.Main(String[] args) in c:\temp\RedGateD
ataSync\Program.cs:line 105
It doesn't happen when the password is characters only.
Unhandled Exception: System.InvalidCastException: Unable to cast object of type
'System.DBNull' to type 'System.String'.
at #8rg.#Ssg.#2lh()
at #8rg.#Ssg.#wlh()
at RedGate.SQLCompare.Engine.Database.RegisterForDataCompare(ConnectionProper
ties connectionProperties, Options options)
at SQLDataCompareCodeSnippets.SyncData.RunExample(String db, String[] tables)
in c:\temp\RedGateDataSync\SyncData.cs:line 59
at SQLDataCompareCodeSnippets.Program.Main(String[] args) in c:\temp\RedGateD
ataSync\Program.cs:line 105
It doesn't happen when the password is characters only.
Comments
If you are on version 10 you can try newer versions of the DLLs - here is a private patch you can try:
ftp://support.red-gate.com/patches/SQL_ ... .0.438.zip
Unhandled Exception: System.IO.FileLoadException: Could not load file or assembl
y 'System.Threading, Version=1.0.2856.102, Culture=neutral, PublicKeyToken=31bf3
856ad364e35' or one of its dependencies. The located assembly's manifest definit
ion does not match the assembly reference. (Exception from HRESULT: 0x80131040)
at #8rg.#Ssg.#Llh(DBPopulationOptions #WXrc, Boolean #YXrc)
at #8rg.#Ssg.#wlh()
at RedGate.SQLCompare.Engine.Database.RegisterForDataCompare(ConnectionProper
ties connectionProperties, Options options)
at SQLDataCompareCodeSnippets.SyncData.RunExample(String db, String[] tables)
in c:\temp\RedGateDataSync\SyncData.cs:line 46
at SQLDataCompareCodeSnippets.Program.Main(String[] args) in c:\temp\RedGateD
ataSync\Program.cs:line 106
http://msdn.microsoft.com/en-us/library/cc531167.aspx
Is there a technical reason SQL Compare is referencing this version of .Net?