Red Gate forums :: View topic - Issues when login password has digits
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK 10
SQL Comparison SDK 10 forum

Issues when login password has digits

Search in SQL Comparison SDK 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
evgkib



Joined: 10 Sep 2013
Posts: 6
Location: United States

PostPosted: Thu Nov 14, 2013 4:11 pm    Post subject: Issues when login password has digits Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Mon Nov 18, 2013 12:41 pm    Post subject: Reply with quote

Sorry to say I don't see how the password comes into it. I can decode the stack trace here at red Gate and the step at which it fails is "populate constraints". So it is logging in - after that point the password should not be relevant as it only uses one login and then it maintains the connection for the whole session.

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_Comparison_SDK/SQL_Comparison_SDK_10.0.0.438.zip
Back to top
View user's profile Send private message
evgkib



Joined: 10 Sep 2013
Posts: 6
Location: United States

PostPosted: Mon Nov 18, 2013 5:16 pm    Post subject: Reply with quote

After installing the update I'm getting this now:
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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Wed Nov 20, 2013 10:49 am    Post subject: Reply with quote

Sorry about that. You can get the System.Threading DLL from an installed Red Gate product's program folder, c:\program files (x86)\red gate\sql compare 10 for instance, and copy this into your app's bin folder. That should fix it.
Back to top
View user's profile Send private message
evgkib



Joined: 10 Sep 2013
Posts: 6
Location: United States

PostPosted: Thu Nov 21, 2013 6:56 pm    Post subject: Reply with quote

I can't find System.Threading in the SDK installation folder.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Mon Nov 25, 2013 11:01 am    Post subject: Reply with quote

Please allow me to clarify again - the file is *not* in the SDK installer. You have to grab it from some other Red Gate program folder. I can send the file to you if you don't have any Red Gate releases (like SQl Compare) installed anywhere.
Back to top
View user's profile Send private message
evgkib



Joined: 10 Sep 2013
Posts: 6
Location: United States

PostPosted: Mon Nov 25, 2013 3:26 pm    Post subject: Reply with quote

Yes, please do send it to me. It'd be greatly appreciated. Thanks.
Back to top
View user's profile Send private message
robo



Joined: 29 Jul 2014
Posts: 1
Location: Raleigh NC

PostPosted: Tue Jul 29, 2014 4:29 pm    Post subject: Reply with quote

I'm confused. Why is the latest version of SQL Compare referencing a version of a deprecated .Net assembly? Microsoft ended support for .Net 1.0 years ago. I'm not comfortable installing this assembly on a Windows 2008 system, as this version of .Net is not even supported there:

http://msdn.microsoft.com/en-us/library/cc531167.aspx

Is there a technical reason SQL Compare is referencing this version of .Net?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group