Calling Stored Procedures in ASP.NET works on Win2K, fails on WinXP SP2

[darrendavid]

Hi all-

new poster here!

We've got a VB.NET web app connecting to a SQL Server 2000 backend - everything's working fine except for stored procedures. The app is running fine when hosted on Windows 2000, but the stored procedure calls are failing in a Windows XP SP2 environment ( from VB.NET that is, they run fine when called from Access and/or Query Manager ). We're guessing the key to the problem lies in the 2000 vs XP/SP2 issue, but we're not sure.

Software versions:
Windows XP SP2
SQL Server 2000 SP4
.NET Framework 1.1 SP 1


here are the details for the exception:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'END'.

Source Error:

Line 87: ' dataAdapter.TableMappings.Add("ClassID", "Name")
Line 88: Dim ds as new DataSet()
Line 89: dataAdapter.Fill(ds)
Line 90:
Line 91: Dim i as Integer


Source File: D:\Inetpub\ktsqa\Class.aspx Line: 89

Stack Trace:

[SqlException: Incorrect syntax near the keyword 'END'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.Class_aspx.Page_Load(Object Sender, EventArgs E) in
D:\Inetpub\ktsqa\Class.aspx:89
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

thanks in advance for any and all help!

regards,
darren david