locked
RMO error with SQL 2008 x32 on Windows 2008 x64 server RRS feed

  • Question

  • HI

    We have an RMO application - it's returning an error of 'could not load file or assembly microsoft.sqlserver.replication.dll' - SQL 2008 is installed (32-bit enterprise edition) on this server, with the replication components.

    The server is a Windows 2008 x64 installation.

    Tried on another server with the same setup.

    I can see the replication.dll assembly on the server.....

    I know the code works fine when installed on a SQL 2008 x64 on a Windows 2008 x64 installation. 

    Any idea of what to look for ?

    Thanks
    Bruce
    Tuesday, September 8, 2009 3:30 AM

Answers

  • I had to rebuild the executable marking it as only x86, instead of 'any platform' to get it to work. Don't know why !

    Bruce
    Monday, September 14, 2009 5:05 AM

All replies

  • Can you physically go to the path on the server and check whether the dll is present ?

    C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies
    Thanks, Leks
    Tuesday, September 8, 2009 3:43 AM
  • Hi Leks

    Thanks for the reply.

    The dll is there.

    I even copied it into the same folder as my executable, to no avail.
    Tuesday, September 8, 2009 5:01 AM
  • You'll need to install it using gacutil.  It has to be in the GAC, having it in the application directory is not enough.

    You might need the 32 bit version.

    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Tuesday, September 8, 2009 11:05 AM
    Answerer
  • I amended the install to ensure replication/sql components are installed into the GAC

    The error I am getting is 'Could not load file or asembly 'Microsoft.sqlserver.replication, version=10.0.0.0, culture=neutral, publicKeyTokey-89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format'.

    This setup worked fine for a 64 SQL install on a Win 2008 64bit installation. Also works fine for a 32 sql on a 32 bit win installation.

    Cheers
    Bruce

    Wednesday, September 9, 2009 5:42 AM
  • I am not too sure what to tell you here Bruce.

    Can you compile the cs file in the C:\Windows\Microsoft.NET\Framework\v3.5 and then the C:\Windows\Microsoft.NET\Framework64\v3.5 and see if either of the compiled versions will work?

    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Wednesday, September 9, 2009 1:16 PM
    Answerer
  • I had to rebuild the executable marking it as only x86, instead of 'any platform' to get it to work. Don't know why !

    Bruce
    Monday, September 14, 2009 5:05 AM