vbscript, ADODB command object

ADODB command object

Author	Message
Adrien Bar #1 / 4	ADODB command object I can't seem to set a command object variable in VBScript. The followinf code works in Visual Basic but not in script. Set cmd = AODObj.CreateObject("ADODB.Command") How do I do this in script.
Mon, 02 Jun 2003 04:04:13 GMT

Michael Harri #2 / 4	ADODB command object What's AODObj supposed to be ??? Depending on the host for the script (the 1st works anywhere): Set cmd = CreateObject("ADODB.Command") Set cmd = Server.CreateObject("ADODB.Command") Set cmd = WScript.CreateObject("ADODB.Command") -- Michael Harris Microsoft.MVP.Scripting -- Please do not email questions - post them to the newsgroup instead. -- Quote: > I can't seem to set a command object variable in VBScript. The followinf > code works in Visual Basic but not in script. > Set cmd = AODObj.CreateObject("ADODB.Command") > How do I do this in script.
Mon, 02 Jun 2003 09:47:17 GMT

Adrien Bar #3 / 4	ADODB command object ADOObj is the connection object variable. Thanks Quote: > What's AODObj supposed to be ??? > Depending on the host for the script (the 1st works anywhere): > Set cmd = CreateObject("ADODB.Command") > Set cmd = Server.CreateObject("ADODB.Command") > Set cmd = WScript.CreateObject("ADODB.Command") > -- > Michael Harris > Microsoft.MVP.Scripting > -- > Please do not email questions - post them to the newsgroup instead. > -- > > I can't seem to set a command object variable in VBScript. The followinf > > code works in Visual Basic but not in script. > > Set cmd = AODObj.CreateObject("ADODB.Command") > > How do I do this in script.
Mon, 02 Jun 2003 11:06:03 GMT

Michael Harri #4 / 4	ADODB command object Well it certainly doesn't have a CreateObject method ;-)... -- Michael Harris Microsoft.MVP.Scripting -- Please do not email questions - post them to the newsgroup instead. -- Quote: > ADOObj is the connection object variable. > Thanks > > What's AODObj supposed to be ??? > > Depending on the host for the script (the 1st works anywhere): > > Set cmd = CreateObject("ADODB.Command") > > Set cmd = Server.CreateObject("ADODB.Command") > > Set cmd = WScript.CreateObject("ADODB.Command") > > -- > > Michael Harris > > Microsoft.MVP.Scripting > > -- > > Please do not email questions - post them to the newsgroup instead. > > -- > > > I can't seem to set a command object variable in VBScript. The followinf > > > code works in Visual Basic but not in script. > > > Set cmd = AODObj.CreateObject("ADODB.Command") > > > How do I do this in script.
Mon, 02 Jun 2003 13:25:53 GMT

Page 1 of 1

[ 4 post ]