simple adodb calling stored procedures code please?

[rocketboy2000]

could anyone provide me with some simple example code of asp classic
calling adodb? specifically, i'd like the code to:
- call a couple of stored procedures that have optional parameters
- share a connection over the two calls

any assistance greatly appreciated and thanks in advance.

[Bob Barrows [MVP]]

ro***********@shaw.ca wrote:

could anyone provide me with some simple example code of asp classic
calling adodb? specifically, i'd like the code to:
- call a couple of stored procedures that have optional parameters
- share a connection over the two calls

any assistance greatly appreciated and thanks in advance.

http://groups.google.com/group/micro...fedf4e1efd63a6
--
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"

[rocketboy2000]

On 28 May, 19:08, "Bob Barrows [MVP]" <[e-mail]>
wrote:

[e-mail] wrote:

could anyone provide me with some simple example code of asp classic
calling adodb? specifically, i'd like the code to:
- call a couple of stored procedures that have optional parameters
- share a connection over the two calls

any assistance greatly appreciated and thanks in advance.

http://groups.google.com/group/micro...ng.vbscript/ms...
--
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"

thanks bob,

your code provides an error... for me at least.

in ie7, SpConnectInfo.htm gives:
Line: 19
Char: 1
Error: Object required: 'parent.document.all.tags(...).item(...)'
Code: 0

any ideas?

[Evertjan.]

wrote on 29 mei 2008 in microsoft.public.inetserver.asp.general:

On 28 May, 19:08, "Bob Barrows [MVP]" <[e-mail]>
wrote:

>[e-mail] wrote:

could anyone provide me with some simple example code of asp classic
calling adodb? specifically, i'd like the code to:
- call a couple of stored procedures that have optional parameters
- share a connection over the two calls

any assistance greatly appreciated and thanks in advance.

http://groups.google.com/group/micro...ng.vbscript/ms...

thanks bob,

your code provides an error... for me at least.

in ie7, SpConnectInfo.htm gives:
Line: 19
Char: 1
Error: Object required: 'parent.document.all.tags(...).item(...)'
Code: 0

parent? Do you use an html frame?

If so, better use:

parent.document.getElementByTagName('...')

Anyway, that is a clientside error,
nothing to do with ASP or adodb on the server.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Bob Barrows [MVP]]

ro***********@shaw.ca wrote:

On 28 May, 19:08, "Bob Barrows [MVP]" <[e-mail]>
wrote:

>[e-mail] wrote:

>>could anyone provide me with some simple example code of asp classic
calling adodb? specifically, i'd like the code to:
- call a couple of stored procedures that have optional parameters
- share a connection over the two calls

>>any assistance greatly appreciated and thanks in advance.

http://groups.google.com/group/micro...ng.vbscript/ms...

>
thanks bob,

your code provides an error... for me at least.

in ie7, SpConnectInfo.htm gives:
Line: 19
Char: 1
Error: Object required: 'parent.document.all.tags(...).item(...)'
Code: 0

".htm"? "parent.document"?
This is an asp group. I can guarantee you that since my code was
intended to be used in server-side code in a .asp page, none of the code
I provided contained a reference to client-side objects like "parent"
and "document". Why do you think it's my code that is causing the error?
:-)

You are attempting to directly connect to a database in client-side
code? I'm sure there may be some security settings that may be
preventing this. Even moreso, I know there are many reasons for you not
to be attempting to do this.

Anyways, without seeing the code you are using, it is impossible for
anyone to troubleshoot your problem, which may have nothing at all to do
with the whatever method you chose to execute the stored procedure. Then
again, it might. Impossible to say.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Dave Anderson]

Bob Barrows [MVP] wrote:

>in ie7, SpConnectInfo.htm gives:
Line: 19
Char: 1
Error: Object required: 'parent.document.all.tags(...).item(...)'
Code: 0

".htm"? "parent.document"?
This is an asp group. I can guarantee you that since my code was
intended to be used in server-side code in a .asp page, none of the
code I provided contained a reference to client-side objects like
"parent" and "document". Why do you think it's my code that is
causing the error? :-)

Maybe because the URL has your name in it, Bob:
http://common.mvps.org/barrowsb/Clas..._generator.zip

Your "canned response" post has a link to this file, which contains
SpConnectInfo.htm, the offending file.


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

[Bob Barrows [MVP]]

Dave Anderson wrote:

Bob Barrows [MVP] wrote:

>>in ie7, SpConnectInfo.htm gives:
Line: 19
Char: 1
Error: Object required: 'parent.document.all.tags(...).item(...)'
Code: 0

".htm"? "parent.document"?
This is an asp group. I can guarantee you that since my code was
intended to be used in server-side code in a .asp page, none of the
code I provided contained a reference to client-side objects like
"parent" and "document". Why do you think it's my code that is
causing the error? :-)

Maybe because the URL has your name in it, Bob:
http://common.mvps.org/barrowsb/Clas..._generator.zip

Your "canned response" post has a link to this file, which contains
SpConnectInfo.htm, the offending file.

Oh! It never occurred to me that he was talking about that ... How did
you make the leap?

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Barrows [MVP]]

ro***********@shaw.ca wrote:

On 28 May, 19:08, "Bob Barrows [MVP]" <[e-mail]>
wrote:

>[e-mail] wrote:

>>could anyone provide me with some simple example code of asp classic
calling adodb? specifically, i'd like the code to:
- call a couple of stored procedures that have optional parameters
- share a connection over the two calls

>>any assistance greatly appreciated and thanks in advance.

http://groups.google.com/group/micro...ng.vbscript/ms...

>--
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"

thanks bob,

your code provides an error... for me at least.

in ie7, SpConnectInfo.htm gives:
Line: 19
Char: 1
Error: Object required: 'parent.document.all.tags(...).item(...)'
Code: 0

any ideas?

OK, it now appears that you are attempting to use the command object
code generator. Did you read what was in the readme.txt file? Here:
Unzip the 3 asp files into a website folder.
Call the spParamFrame.asp page to load the app. Enter the information
and click the button to generate the code.
You have the code so you can modify it if you want things like trusted
connection, different variable names, etc.

The page to be loading in the browser is spParamFrame.asp
SpConnectInfo.htm is not intended to be run on its own

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Dave Anderson]

Bob Barrows [MVP] wrote:

>Your "canned response" post has a link to this file, which contains
SpConnectInfo.htm, the offending file.

Oh! It never occurred to me that he was talking about that ... How
did you make the leap?

I bothered to follow your link to see if your canned response was as
thorough as I hoped it would be.


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.