W
Wayne Wengert
I am trying to define the active connection for a command in an ASP page but
I keep getting the error:
---------------------------------------------
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/LoginControl.asp, line 19
--------------------------------
Line 19 is the "cmdDC.ActiveConnection = myConn" line. The code is as
follows:
====================================
Dim cmdDC, RecordSet
Dim strUserName, strPassword
strUserName = Request.Form("txtName")
strPassword = Request.Form("txtPassword")
'-- Create command object
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = myConn
====================================
I use an include file at the start of the ASP page to establish my
connection - the included code is::
====================================
Dim cst, myConn
Sub CreateConnection()
cst = "Provider=SQLOLEDB; Data Source = xx.xx.xx.xx; Initial Catalog =
myDB; User ID = myID; Password=myPW"
set myConn = Server.CreateObject("ADODB.Connection")
myConn.open cst
End Sub
====================================
Any suggestions on what I did wrong here?
I keep getting the error:
---------------------------------------------
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/LoginControl.asp, line 19
--------------------------------
Line 19 is the "cmdDC.ActiveConnection = myConn" line. The code is as
follows:
====================================
Dim cmdDC, RecordSet
Dim strUserName, strPassword
strUserName = Request.Form("txtName")
strPassword = Request.Form("txtPassword")
'-- Create command object
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = myConn
====================================
I use an include file at the start of the ASP page to establish my
connection - the included code is::
====================================
Dim cst, myConn
Sub CreateConnection()
cst = "Provider=SQLOLEDB; Data Source = xx.xx.xx.xx; Initial Catalog =
myDB; User ID = myID; Password=myPW"
set myConn = Server.CreateObject("ADODB.Connection")
myConn.open cst
End Sub
====================================
Any suggestions on what I did wrong here?