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

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/microsoft.public.scripting.vbscript/msg/61fedf4e1efd63a6

 

[rocketboy2000]

http://groups.google.com/group/microsoft.public.scripting.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:

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.

 

[Bob Barrows [MVP]]

http://groups.google.com/group/microsoft.public.scripting.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.

 

[Dave Anderson]

".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/ClassicASP_sp_code_generator.zip

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

 

[Bob Barrows [MVP]]

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