July 19th, 2000, 11:15 AM
BBDB is a System DSN.
One of the tables is Shippers whose fields are
shipperID - Integer, Primary Key
CompanyName - Text(50)
The query qryGetShipper on table Shippers is
select Shippers.* from Shippers
where Shippers.ShipperID = [paramShipperID]
The query "qryGetShipper" is stored in the database.
The code in the asp file is as follows :
dim dcnDB
dim cmdQuery
dim rsQuery
dim parID
Set dcnDB = Server.CreateObject("ADODB.Connection")
dcnDB.open "BBDB"
Set cmdQuery = Server.CreateObject("ADODB.Command")
cmdQuery.CommandText = "qryGetShipper"
Set cmdQuery.ActiveConnection = dcnDB
Set parID = cmdQuery.CreateParameter("ParamShipperID",adInteger, _
adParamInput, , 1)
cmdQuery.Parameters.Append parID
set rsQuery = cmdQuery.Execute
Do while Not rsQuery.EOF
Response.Write rsQuery("CompanyName") & "
"
rsQuery.MoveNext
Loop
rsQuery.Close
dcnDB.close
After running the asp file the error received is
ADODB.Command error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
How can i fix the error?
One of the tables is Shippers whose fields are
shipperID - Integer, Primary Key
CompanyName - Text(50)
The query qryGetShipper on table Shippers is
select Shippers.* from Shippers
where Shippers.ShipperID = [paramShipperID]
The query "qryGetShipper" is stored in the database.
The code in the asp file is as follows :
dim dcnDB
dim cmdQuery
dim rsQuery
dim parID
Set dcnDB = Server.CreateObject("ADODB.Connection")
dcnDB.open "BBDB"
Set cmdQuery = Server.CreateObject("ADODB.Command")
cmdQuery.CommandText = "qryGetShipper"
Set cmdQuery.ActiveConnection = dcnDB
Set parID = cmdQuery.CreateParameter("ParamShipperID",adInteger, _
adParamInput, , 1)
cmdQuery.Parameters.Append parID
set rsQuery = cmdQuery.Execute
Do while Not rsQuery.EOF
Response.Write rsQuery("CompanyName") & "
"
rsQuery.MoveNext
Loop
rsQuery.Close
dcnDB.close
After running the asp file the error received is
ADODB.Command error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
How can i fix the error?