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

Lars-Erik wrote:
Hi!

The code I provided doesn't show, but after the connection, command
type and command text are set I also call
oCmd.Parameters.Refresh

I've done a little testing at the customers server, and it seems that
Refresh fills the parameters for some, but not all of the stored
procedures.

Any way to fix it?



I don't know, and now I'm really glad I never use it.

It might help to show the beginning of the CREATE PROCEDURE script for one
of the procedures for which Refresh does not work. We just need to see the
part where the parameters are declared
create procedure myprocedure (
@parm1 int, ..., @parmN varchar(5)) AS

You're not using any SQL2005-specific datatypes are you? Are you using the
native client provider to connect to SQL 2005?


--
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: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... One of the ones that does not work (0 parameters after .Refresh) looks like ... I've tried SQL Server Native and SQL Server using ODBC via ODBC dsn's, ... I've also tried using a connection string with Provider=SQLOLEDB.1. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: NFS problem with showmount -a
    ... the showmount -a command show all the connection that were already ... and the list takes a long time to refresh. ...
    (comp.unix.admin)
  • RE: Dialin problem
    ... # /etc/ppp/ppp.conf File for dial out modem to ISP and Dial in modem ... # connection to this FBSD system. ... # it's default options profile set to, NO command echo ATE0 and NO ... Edit /etc/ttys to enable a getty on the port where the dialin ...
    (freebsd-questions)
  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: [SLE] Setting up DSL on SUSE 10.1
    ... I won't faint at command line. ... SUSE or Mepis and the non computer oriented PCLinuxOS. ... In some OS's such as MS's the network will be confiured and on. ... on the DSL connection? ...
    (SuSE)
Loading