Red Gate forums :: View topic - Could not load file or assembly RedGate.SQLCompare.ASTParser
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

Could not load file or assembly RedGate.SQLCompare.ASTParser

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jw970170



Joined: 01 Nov 2007
Posts: 12

PostPosted: Thu Nov 01, 2007 6:05 pm    Post subject: Could not load file or assembly RedGate.SQLCompare.ASTParser Reply with quote

Hi,

I get this error when I try to RegisterForDataCompare

"Could not load file or assembly 'RedGate.SQLCompare.ASTParser, Version=6.2.0.45, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified."
Here is my code

dbLocal = new Database();
dbLocal.RegisterForDataCompare(new ConnectionProperties(server, database, username, password));

I even put the file RedGate.SQLCompare.ASTParser.dll in the same directory as the exe but it didn't help with anything.

Any ideas?
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Thu Nov 01, 2007 6:39 pm    Post subject: Reply with quote

This will happen if you use the SQLCompare dlls from the SQL Compare directory and the SQL Data Compare dlls from the SQL Data Compare directory.

Don't mix and match the dlls and it should work ok. i.e. use *only* files from the SQL Compare directory *OR* the SQL Data Compare Directory in a single project.

Yes it's a bit of a faff at the moment and we're looking into ways to improve it.

Smile

HTH
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
jw970170



Joined: 01 Nov 2007
Posts: 12

PostPosted: Thu Nov 01, 2007 7:10 pm    Post subject: Reply with quote

I've re-copied the required dlls from SQL Data Compare directory. They are all from the same directory. I still get the error.

It says the system could not find the file specified....but I'm not supposed to reference the ASTParser.dll. I think I tried with the file referenced as well but it didn't make a difference.
Back to top
View user's profile Send private message
jw970170



Joined: 01 Nov 2007
Posts: 12

PostPosted: Thu Nov 01, 2007 8:49 pm    Post subject: Reply with quote

ok, I didn't realize how many red gate dlls i needed to do the data compare. I hav corrected the issue. I just needed to copy some other dlls to the exe directory

RedGate.SQLCompare.Rewriter.dll
RedGate.SQLCompare.BackupReader.dll
RedGate.BackupReader.dll
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 383
Location: Red Gate Software Ltd

PostPosted: Fri Nov 02, 2007 11:49 am    Post subject: Reply with quote

This is the full list of Red Gate Dlls you need....

* RedGate.BackupReader.CryptoHelper.dll
* RedGate.BackupReader.dll
* RedGate.BackupReader.SqbReader.dll
* RedGate.Shared.Utils.dll
* RedGate.SQL.Shared.dll
* RedGate.SQLCompare.ASTParser.dll
* RedGate.SQLCompare.BackupReader.dll
* RedGate.SQLCompare.Engine.dll
* RedGate.SQLCompare.Rewriter.dll
* RedGate.SQLDataCompare.Engine.dll
* rglz.dll
* System.Data.SQLite.dll
* zlib1.dll

I know it's a lot!
_________________
Richard Mitchell
Project Manager
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
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