Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Thu, 15 May 2008 07:01:08 -0400
Lars-Erik wrote:
As a sidenote.. .Refresh does really not seem to be necessary. I've
ran the code without it on my client computer running Vista, and as
long as the command is given type 4, an open connection (or a string,
which is bad practice :P ), and a command name, the roundtrip is made
as soon as you try to access the parameters.
Not in my testing. Of course, I don't have a Vista machine to test it on,
but I'm not really sure why that would make a difference.
--
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"
.
- Follow-Ups:
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Bob Barrows [MVP]
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Lars-Erik
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- References:
- Non initialized Cmd Parameter Collection via ASP vs SQL Server 200
- From: Lars-Erik
- RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server 200
- From: Steven Cheng [MSFT]
- RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Lars-Erik
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Bob Barrows [MVP]
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Lars-Erik
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Bob Barrows [MVP]
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Lars-Erik
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Bob Barrows [MVP]
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Lars-Erik
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Steven Cheng [MSFT]
- Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- From: Lars-Erik
- Non initialized Cmd Parameter Collection via ASP vs SQL Server 200
- Prev by Date: Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- Next by Date: Error message when opening a recordset with a strem containing xml
- Previous by thread: Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- Next by thread: Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server
- Index(es):