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

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: Page Refresh
    ... I think the int only works the first time the page is activated and then as you pointed my nose you need to put the refresh in the Activate. ... I tab back to page 1 and type more info into like fields and then switch to ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Page Refresh
    ... I think the int only works the first time the page is ... I tab back to page 1 and type more info into like fields and then switch ... thisform.refresh it will refresh page 5. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... One of the procedures that works and has 5 parameters after .Refresh ... @LinjeID as int, ... @AntallSkift as int, ... I've tried SQL Server Native and SQL Server using ODBC via ODBC ...
    (microsoft.public.data.ado)
  • Re: Page Refresh
    ... I think the int only works the first time the page is ... I tab back to page 1 and type more info into like fields and then switch ... thisform.refresh it will refresh page 5. ...
    (microsoft.public.fox.programmer.exchange)
Loading