Click here to Skip to main content
16,018,797 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: ErrorProvider: Clear ALL Pin
Anonymous5-Jul-05 11:26
Anonymous5-Jul-05 11:26 
QuestionStringFormat.Format16bppArgb1555 ? Pin
[Marc]5-Jul-05 8:36
[Marc]5-Jul-05 8:36 
AnswerI mean PixelFormat.Format16bppArgb1555 Pin
[Marc]5-Jul-05 16:23
[Marc]5-Jul-05 16:23 
QuestionHow to Share data b/t parent and child form ? Pin
Madni Abbasi5-Jul-05 3:51
Madni Abbasi5-Jul-05 3:51 
AnswerRe: How to Share data b/t parent and child form ? Pin
Dave Kreskowiak5-Jul-05 5:47
mveDave Kreskowiak5-Jul-05 5:47 
GeneralVBscript to output SQL stored procedure results Pin
brokenchode5-Jul-05 3:23
brokenchode5-Jul-05 3:23 
GeneralRe: VBscript to output SQL stored procedure results Pin
Dave Kreskowiak5-Jul-05 5:56
mveDave Kreskowiak5-Jul-05 5:56 
GeneralRe: VBscript to output SQL stored procedure results Pin
brokenchode5-Jul-05 9:09
brokenchode5-Jul-05 9:09 
Made some small changes to the variable names, but tried what was posted in:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdconcommandparams.asp

and here

http://www.microsoft.com/resources/documentation/Windows/2000/server/reskit/en-us/iisbook/c07_returning_values_from_stored_procedures.asp


Now getting error' Item cannot be found in the collection corresponding to the requested name or ordinal.
800A0CC1

This means that the Recordset var isn't getting any data returned to it, but the stored proc when run in query analyzer is returning data?

What do I have blatantly incorrect in the code below?


--

Dim userinformation_connection_jobs
Dim userinformation_command_jobs
Dim userinformation_recordset_jobs

Set userinformation_connection_jobs = CreateObject("ADODB.Connection")
Set userinformation_command_jobs = CreateObject("ADODB.Command")
Set userinformation_recordset_jobs = CreateObject("ADODB.Recordset")

userinformation_connection_jobs.ConnectionString = "Provider='sqloledb';Data Source='" & database_name & "';" & _
"Initial Catalog='master';Integrated Security='SSPI';"
userinformation_connection_jobs.open
userinformation_command_jobs.ActiveConnection = userinformation_connection_jobs
userinformation_command_jobs.CommandTimeout = 15



userinformation_command_jobs.CommandText = "exec sp_help_revlogin"
'userinformation_command_jobs.CommandType = adCmdStoredProc

Set userinformation_recordset_jobs = userinformation_command_jobs.Execute

userinformation_recordset_jobs(0).Direction = adParamReturnValue
'userinformation_command_jobs.Execute
output_file.WriteLine(userinformation_recordset_jobs(0))
QuestionHow to update from vb.net 2005 beta1 to beta2? Pin
rushing4-Jul-05 23:02
rushing4-Jul-05 23:02 
AnswerRe: How to update from vb.net 2005 beta1 to beta2? Pin
Christian Graus5-Jul-05 0:13
protectorChristian Graus5-Jul-05 0:13 
AnswerRe: How to update from vb.net 2005 beta1 to beta2? Pin
Dave Kreskowiak5-Jul-05 1:18
mveDave Kreskowiak5-Jul-05 1:18 
GeneralGetting windows XP login & logout time Pin
Ilangovan4-Jul-05 21:06
Ilangovan4-Jul-05 21:06 
GeneralRe: Getting windows XP login & logout time Pin
Dave Kreskowiak5-Jul-05 1:13
mveDave Kreskowiak5-Jul-05 1:13 
GeneralRe: Getting windows XP login & logout time Pin
Anonymous5-Jul-05 5:46
Anonymous5-Jul-05 5:46 
GeneralRe: Getting windows XP login & logout time Pin
Anonymous5-Jul-05 8:23
Anonymous5-Jul-05 8:23 
GeneralHelp Pin
Nguyen Dinh Quy4-Jul-05 20:42
Nguyen Dinh Quy4-Jul-05 20:42 
GeneralRe: Help Pin
Christian Graus5-Jul-05 0:16
protectorChristian Graus5-Jul-05 0:16 
GeneralMSMQ Pin
nitin_ion4-Jul-05 20:30
nitin_ion4-Jul-05 20:30 
GeneralRe: MSMQ Pin
Dave Kreskowiak5-Jul-05 2:46
mveDave Kreskowiak5-Jul-05 2:46 
GeneralRe: MSMQ Pin
nitin_ion5-Jul-05 17:27
nitin_ion5-Jul-05 17:27 
GeneralRe: MSMQ Pin
Dave Kreskowiak6-Jul-05 1:00
mveDave Kreskowiak6-Jul-05 1:00 
GeneralRe: MSMQ Pin
nitin_ion6-Jul-05 18:27
nitin_ion6-Jul-05 18:27 
GeneralRe: MSMQ Pin
Dave Kreskowiak7-Jul-05 2:20
mveDave Kreskowiak7-Jul-05 2:20 
GeneralRe: MSMQ Pin
nitin_ion7-Jul-05 17:35
nitin_ion7-Jul-05 17:35 
GeneralRe: MSMQ Pin
Dave Kreskowiak8-Jul-05 1:24
mveDave Kreskowiak8-Jul-05 1:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.