Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server

I keep forgetting to mention one thing we saw today. We ran the MDAC version
checker tool, and it reported mismatches for a lot when we compared to
Windows Server 2003 SP2. They certainly run with it according to winver.
I didn't want to force them to re-apply the service pack, although I do
suspect it could have something to do with the problems.

--
Lars-Erik


"Bob Barrows [MVP]" wrote:

Lars-Erik wrote:
The "runCommand" function is always called with an initialized and
open connection.

One of the procedures that works and has 5 parameters after .Refresh
looks like this:
CREATE PROCEDURE [dbo].[UpdateSkiftTid]
@SkiftID Integer,
@LinjeID Integer,
@SkiftStart DateTime,
@SkiftStopp DateTime
AS
...

One of the ones that does not work (0 parameters after .Refresh)
looks like this:
CREATE PROCEDURE [dbo].[UpdateNormverdier]
@LinjeID as int,
@GradID as int,
@AntallSkift as int,
@Stopptid as int,
@AntallProd as int,
@AntallStopp as int
AS
...

None of them has any explicit return value, but as I recall, .Refresh
creates one anyway. (And the 5 returned parameters imply..)

I've tried SQL Server Native and SQL Server using ODBC via ODBC
dsn's, and I've also tried using a connection string with
Provider=SQLOLEDB.1.

Well, I'm stumped. You haven't tried the SQLNaCli provider then?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: WHERE clause applies to right-hand table of LEFT JOIN
    ... it's always best to specify INNER JOIN ... T1_PK int NOT NULL ... CONSTRAINT FK_T2_T1 FOREIGN KEY ... The SQL Server cost-based optimizer is very good at generating efficient ...
    (microsoft.public.sqlserver.server)
  • Re: WHERE clause applies to right-hand table of LEFT JOIN
    ... it's always best to specify INNER JOIN ... T1_PK int NOT NULL ... CONSTRAINT FK_T2_T1 FOREIGN KEY ... The SQL Server cost-based optimizer is very good at generating efficient ...
    (microsoft.public.access.queries)
  • Re: using OpenXML in T-sql?
    ... Columnist, SQL Server Professional ... The author makes a reference to using comma delimited strings and opts for the xml string instead. ... @ID1 INT, @ID2 INT, @ID3 INT, @ID4 INT AS ... ... you're betting you'll never have to specify more values than the number of input parameters you create. ...
    (microsoft.public.sqlserver.programming)
  • Re: 17805 Starting up Java App server, with SQL Server 2000 Backend
    ... network issue although you would expect a network issue to be more random. ... declare @P1 int ... On another machine running SQL Server 2000 Standard on Win2K advanced, ...
    (microsoft.public.sqlserver.clients)
  • Re: Users , Web Application and SQL Server back end - Beginner Questio
    ... Create table Users (userid int not null primary key, ... Create table UserTypes (usertypeid int not null primary key, ... I have developed a java based Web application that is using SQL Server ...
    (microsoft.public.sqlserver.security)