G
Guest
We are having an intermittent problem using an ExecuteScalar command on a
asp.NET page accessing SQL Server. 2 characters of the sql statement get
intermittently altered. The code looks as follows:
SqlCommand command = new SqlCommand("SELECT fkOWSStatusID FROM
vwUsersCleanups WHERE pkCleanupID = 123", connection);
object nReturn = command.ExecuteScalar();
About 10% of the time, the 'rs' in vwUsersCleanups get altered into
unrecgonizable characters. The other 90% of the time, everything works just
fine. I have put a Trace method just before the ExecuteScalar() to verify
the sql statement is correct. It always looks just fine. However, in SQL
Profiler, in the BatchStarting Event, the Select statement is corrupt. I
have applied the most recent service pack for MDAC 2.7, reinstalled the .NET
Framework (version 1.1), and deleted and recreated the view all to no avail.
This occurs on 2 of our IIS servers. All other IIS servers we try it on
works fine. This seems to eliminate any bad build problems.
asp.NET page accessing SQL Server. 2 characters of the sql statement get
intermittently altered. The code looks as follows:
SqlCommand command = new SqlCommand("SELECT fkOWSStatusID FROM
vwUsersCleanups WHERE pkCleanupID = 123", connection);
object nReturn = command.ExecuteScalar();
About 10% of the time, the 'rs' in vwUsersCleanups get altered into
unrecgonizable characters. The other 90% of the time, everything works just
fine. I have put a Trace method just before the ExecuteScalar() to verify
the sql statement is correct. It always looks just fine. However, in SQL
Profiler, in the BatchStarting Event, the Select statement is corrupt. I
have applied the most recent service pack for MDAC 2.7, reinstalled the .NET
Framework (version 1.1), and deleted and recreated the view all to no avail.
This occurs on 2 of our IIS servers. All other IIS servers we try it on
works fine. This seems to eliminate any bad build problems.