Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Missing Something Obvious Here!

Thread Tools

Missing Something Obvious Here!

Wayne Wengert
Posts: n/a
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


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") cst
End Sub


Any suggestions on what I did wrong here?
Wayne Wengert Removed)

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Missing something obvious with python-requests Chris Angelico Python 2 01-04-2013 03:24 PM
Re: Missing something obvious with python-requests Ray Cote Python 0 01-04-2013 02:12 AM
Re: Missing something obvious with python-requests Barry Scott Python 0 01-03-2013 10:48 PM
Missing something obvious with python-requests Ray Cote Python 0 01-03-2013 06:53 PM
timeit module: am I missing something obvious? Steven D'Aprano Python 2 02-20-2006 03:23 PM