Red Gate forums :: View topic - 64bit Restrictions
Return to www.red-gate.com RSS Feed Available

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

64bit Restrictions

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
TomAnderson



Joined: 15 Nov 2006
Posts: 8

PostPosted: Sun Jan 18, 2009 12:49 am    Post subject: 64bit Restrictions Reply with quote

It has been a while since we have updated our SQL Compare version, and before upgrading I would like to find out if the 64 bit restrictions have been removed, or if we still need to compile our applications in 32 bit only.

Thanks in advance.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Mon Jan 19, 2009 11:30 am    Post subject: Reply with quote

Hi Tom,

The assemblies in the version 7.1 SDK and up compile for "any CPU", so the SDk will run as 64-bit native on a 64-bit system. There are some dlls that are confined to 32-bit, I believe the backup reader is for technical reasons, so if you don't reference that dll you can compile the SDK application as "Any CPU" as well.

You can use microsoft's corflags utility to check the 32-bit flag on the Red Gate dlls to make absolutely sure that the dll you want to reference is 64-bit compatible.
Back to top
View user's profile Send private message
TomAnderson



Joined: 15 Nov 2006
Posts: 8

PostPosted: Thu Jan 22, 2009 4:14 am    Post subject: Reply with quote

Thank you, it works great now. We can finally remove our x86 restrictions Smile
Back to top
View user's profile Send private message
FredMorin



Joined: 26 Nov 2008
Posts: 7

PostPosted: Wed Jan 28, 2009 10:02 pm    Post subject: BackupReader Reply with quote

Regarding the BackUpReader.

I use it in an application and it turns out some clients use Vista 64.

Sure enough, it doesnt work.

What it the solution ?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Thu Jan 29, 2009 10:23 am    Post subject: Reply with quote

The backup reader dll is still 32-bit. Everything else is "any CPU". Sorry for the confusion.
Back to top
View user's profile Send private message
FredMorin



Joined: 26 Nov 2008
Posts: 7

PostPosted: Thu Jan 29, 2009 12:59 pm    Post subject: Reply with quote

Sorry if I sound confused, but is there anyway to make the 32bit DLL which is reference in my .NET application to work in Vista 64.

I was never told by the client he needed support for vista 64 and now he realizes that we need it.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Thu Jan 29, 2009 3:19 pm    Post subject: Reply with quote

When you build your application, compile it as 32-bit. This will also run on 64-bit systems because these editions of Windows have a 32-bit emulation which will run the program (WOW).

In Visual Studio, the project properties panel contains this setting. For a C# project, it's the "Platform target" dropdown. Changing this to "x86" will set the flag in the assembly output that will cause the application to load the 32-bit .NET Runtime. This should solve your problem across the board.
Back to top
View user's profile Send private message
ilya



Joined: 30 Jul 2008
Posts: 13

PostPosted: Wed Dec 22, 2010 11:17 am    Post subject: Reply with quote

Hi Brian, we have the same problem with BackupReader.
We wrapp the data compare functionality we need in a dll, which will be used our asp.net application.
The dll using SDK is compiled for x86, with recommended options for the pree and post-build events (http://www.red-gate.com/supportcenter/Content?c=knowledgebase\all_SQL_products\KB200806000268.htm&p=SQL%20Comparison%20SDK).
With the SQL Toolkit 6.0 we had no problems with backup reader dll and the above scenario.
Now with Comparison SDK 8.1 we have an exception "Cannot load Backup Reader dll!" on the code line:
IList<IBackupSet> backupSets = backupDB.GetBackupSets(files, passwords);
It doesn't help also to compile our asp.net application for x86.

Have you any ideas, how to get off of the exception?

Thanx
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