Issues when login password has digits

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Issues when login password has digits

Postby evgkib » Thu Nov 14, 2013 4:11 pm

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.
evgkib
 
Posts: 6
Joined: Tue Sep 10, 2013 7:11 pm
Location: United States

Postby Brian Donahue » Mon Nov 18, 2013 12:41 pm

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_ ... .0.438.zip
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby evgkib » Mon Nov 18, 2013 5:16 pm

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
evgkib
 
Posts: 6
Joined: Tue Sep 10, 2013 7:11 pm
Location: United States

Postby Brian Donahue » Wed Nov 20, 2013 10:49 am

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby evgkib » Thu Nov 21, 2013 6:56 pm

I can't find System.Threading in the SDK installation folder.
evgkib
 
Posts: 6
Joined: Tue Sep 10, 2013 7:11 pm
Location: United States

Postby Brian Donahue » Mon Nov 25, 2013 11:01 am

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby evgkib » Mon Nov 25, 2013 3:26 pm

Yes, please do send it to me. It'd be greatly appreciated. Thanks.
evgkib
 
Posts: 6
Joined: Tue Sep 10, 2013 7:11 pm
Location: United States

Postby robo » Tue Jul 29, 2014 4:29 pm

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?
robo
 
Posts: 1
Joined: Tue Jul 29, 2014 4:14 pm
Location: Raleigh NC


Return to SQL Comparison SDK 10

Who is online

Users browsing this forum: No registered users and 0 guests