locked
SQL Server 2008 and COM+ connection problem RRS feed

  • Question

  • I have a classic ASP app that uses COM+ for the database calls.  This works when the database is SQL Server 2005.  When I change my ODBC connection to point to a SQL Server 2008 database, I get an invalid procedure call at the point in the COM code where it is logging in.  I broke this down in a simple VB 6 test app and was able to verify that the problem happens when attempting to log in.

    Is there some sort of extra configuration in the database that has to be done when using 2008 and COM+?  Grasping at straws.  Many thanks for any help.

    Tuesday, November 1, 2011 4:37 PM

Answers

  • Hi Mad,

    Please follow: http://msdn.microsoft.com/en-us/library/ms143690(v=sql.90).aspx
    to check if your COM+ is properly configured.
    If it is not helped, could you please post your code?

    Hope this helps.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Iric Wen Wednesday, November 9, 2011 2:23 AM
    • Marked as answer by Stephanie Lv Wednesday, November 9, 2011 9:31 AM
    Thursday, November 3, 2011 6:05 AM