SQL Server 2005 Enterprise - x64 Edition - CoCreateInstance() failure

SQL Server 2005 Enterprise Edition

Windows Server 2003 Enterprise x64 Edition + SP1

My application does this:

---------------------------------------------------------------------------

CoCreateInstance( CLSID_SQLDMOApplication,
NULL,
CLSCTX_INPROC_SERVER,
IID_ISQLDMOApplication,
( LPVOID * ) & mpDmoApplication );

---------------------------------------------------------------------------

and gets a message box:

---------------------------------------------------------------------------

Runtime Error!

Program: c:\test.exe

R6034

An application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information.

---------------------------------------------------------------------------

RC = 0x8007045a

I saw a previous append about this and the response was:
"There is a known bug in 64-bit SQLDMO that renders it useless. You should use the 32-bit SQLDMO that is installed with every 64-bit SQL Server installation."

.... but it left a few unanswered questions... I have two questions:

1. Is there a hotfix available for this

2. Is there a workaround for this If yes, how do you use it It mentions that "You should use the 32-bit SQLDMO". How is this done

Thanks.

Del



Answer this question

SQL Server 2005 Enterprise - x64 Edition - CoCreateInstance() failure

  • RMarceloJR

    The fix is going to go into the final release of SP1; It is not in the recent SP1 CTP release - we didn't make the deadline. Though, you should seriously consider rewriting your application to use SMO.

    Cheers,
    Dan



  • kittani

    Dan,

    Thank you. We do plan to convert the application from DMO to SMO... but we won't be able to do that on such a short runway as we have here. Thanks for making sure it gets into the final version of SQL Server 2005 SP1.

    Del


  • the.zypher

    There is a known bug with the native 64-bit DMO on x64 platforms. Until this is fixed you will need to use the 32-bit DMO on x64 platforms. You won't be able to write native 64-bit applications that use DMO. The other option is to migrate the application to SMO which works in both the 32-bit and 64-bit spaces on x64.

  • Jkumar

    I have a case opened with Microsoft now. I would like to get a hotfix for this. Can you find out if I am able to get a hotfix I am also working this through the support channels since I would really like to have my application run in natice 64-bit instead of 32-bit.

    Thanks,

    Del


  • SQL Server 2005 Enterprise - x64 Edition - CoCreateInstance() failure