Post reply

Differences between MSDE and SQL 2000

  • July 13, 2006 at 6:25 am

    #173165

    Is their a fundemental difference between MSDE and SQL 2000?  The reason I ask is that I am developing a Crystal Reports App in VS2005 (VB),  I was originally working on an XP machine with MSDE and stored procedures where it worked fine.

    I have transferred the development to a Win2003 machine with SQL2000 and (and the original database) am now getting the following error;

     Failed to open a rowset. Description: 'Get_Calls_By_MLO_Date' expects parameter '@DT1' which was not supplied.

    Here is the SP.

    CREATE PROCEDURE Get_Calls_By_MLO_By_Date

     @DT1 datetime,

     @DT2 datetime

    AS

    SELECT MLO, CallNo, DT, Type FROM Actions

    WHERE dt >= @DT1 AND dt <= @dt2 AND ActionID=1 ORDER BY MLO, DT

    GO

    If I transfer everything back to the XP machine it works fine.

    Any ideas?

    Thanks

    Terry.

  • July 13, 2006 at 9:37 am

    #649009

    Terry,

    looking at the code of the procedure there's nothing wrong. It should execute on both environments as long as you execute it in the correct way

    Exec Get_Calls_By_MLO_By_Date @DT1= '20060712', @dt2 = '20060715'

    From the error I assume that you tried to execute the procedure and the message say's that parameter @DT1 was not supplied.

    Maybe one of the databases is case sensitive and you supplied @dt1 instead of @DT1.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • July 13, 2006 at 9:55 am

    #649021

    Hi Markus,

    Thanks for your help.  The field type in the database is datetime and the values are of the order "19/11/05 01:13:47 PM"

    The procedure is called from within the Crystal Report object and the @DT1 parameter being passed into the report object is of the order 7/13/2006 23:59:59 PM - the month and day is swapped.  However, the MSDE instance seems to work ok with it like this.

    The database file is exactly the same, I just moved it from the MSDE instance to the SQL one.

    Showing my ignorance here, how do I check if the SQL instance is case sensitive? 

    Thanks

    Terry.

  • July 15, 2006 at 4:00 am

    #649399

    Thanks for the help.  The problem turned out to be a crystal reports one and is detailed here

    http://support.businessobjects.com/library/kbase/articles/c2017367.asp

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply