What error is this?? 1

smash81 · Jun 13, 2001

Hello,
I am trying to make a small application.I have the main screen on which a form is displayed with a
drop down box and a radio button.
Once the user select the number from the drop down and clicks the radio button and submit, the following
script is to be executed.
Now this refers to an access query where i am to pass two parameters.However when i execute the script
with the following code:

<html>
<head>
<title> Auction Details</title>
</head>

<body>
<%

dim conn,rs,comm
set comm=server.createobject("adodb.command&quot

set conn=server.createobject("adodb.connection&quot

set rs=server.createobject("adodb.recordset&quot

conn.open "DSN=mydbase"

comm.activeconnection=conn
comm.commandtext="details"
comm.commandtype=2

comm.Parameters.Append comm.createparameter ("abc",adInteger,adparameterinput)

comm.parameters.append comm.createparameter("xyz",advarchar,adparameterinput)
comm.parameters(0).value=request.querystring("number&quot

comm.parameters(1).value=request.querystring("radio&quot

set rs=comm.execute

(PS this is just part of the script and i strongly feel that the error is coming from here.)

When i execute the script i get the following error:

ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/man/list.asp, line 26

Please help me resolve this problem
The datatypes in the database are
integer and text

Geee · Jun 13, 2001

I have a feeling this is because the two variables you are trying to place into the array are of different data types. The number is obviously an integer, whereas the radio button returns a boolean. The problem is that an array can only hold 1 data type.

Hope this helps...

Gee -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

smash81 · Jun 13, 2001

Thank you but i also tried to use the refresh method.And this also does not work.
is there anything else that i can try?

Geee · Jun 13, 2001

My apologise I misread your code. Im afraid I don't know anything about using this method to execute access queries.

Sorry!

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

dianal · Jun 13, 2001

Hello,
As far as I understood you have MS Access Database with DSN "mybase" and parametrized query named details. And you are trying to pass parameters to that query.
If you were using MS SQL server I would say that it is stored procedure with parameters and you mistyped the commandtype. I checked with MSDN and it is the same with MS Access queries.
You have used
comm.commandtype=2 ( or =adCmdTable) which means that you are using a table name whose columns are all returned by an internally generated SQL query.
So you need
comm.commandtype=4 (or =adCmdStoredProc) which means you are using a stored procedure name (or query in Access terms).

Then I again checked your code and got the same error!
Tried to replace
comm.Parameters.Append comm.createparameter("abc",adInteger,adparameterinput)

with

comm.Parameters.Append comm.createparameter("abc",3,1)

and everything was OK. You could also use these integers.

Or as I think you forgot to include adobvs.inc where all constants have their corresponding integers.
Use somewhere between the <head> </head>

And copy to your project folder file adovbs.inc.
You can find it somewhere on your disk (it is shipped with MS Interdev) or you can download from MS site recent version.

Hope this helps.
D.

smash81 · Jun 13, 2001

I really appreciate this it seems to be working to a certain extent.Please tell me how you get these numbers e.g the ("",3,1) which section of MSDN do you get them from?
And you guessed right.The database is access and the details is a query.

dianal · Jun 13, 2001

Hello, smash81,
From main page of MSDN - library or direct to

http://msdn.microsoft.com/library/default.asp

You have to follow the hierarchy of links to Platform SDK Documentation, Data Services, Microsoft Data Access Components (MDAC) SDK, Microsoft ActiveX Data Objects (ADO), ADO Programmer's Reference, ADO API Reference,
ADO Objects, Command Object, Command Object Properties, Methods, and Events
From there to the CreateParameters, DataTypeEnum, etc.
I'm including a direct link to Command object, but I think it is better to browse ADO API Reference, or ADO Programmer's Guide.

http://msdn.microsoft.com/library/default.asp?ShowPane=false&URL=/library/psdk/dasdk/mdao9mn8.htm

I would recommend reading an article about adovbs.inc

http://www.asp101.com/articles/john/adovbs/default.asp

Success with your task.
D.

smash81 · Jun 13, 2001

Thank you so much.
I had tried usinga file called msado15.dll.Will this work? i had read about it in a book.
One more thing, to avoid all these problems, i tried using the comm.parameters.refresh method and i got the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e51'

Provider cannot derive parameter information and SetParameterInfo has not been called

Now what is this???? Please help again

dianal · Jun 14, 2001

Hello, smash81,
I think that msado15.dll will work in VB project, not in ASP.
For the Refresh method I found following explanation:
"Typical uses of the Parameters.Refresh method of the Active Data Objects (AD0) command object to determine parameter information for the query. However, the Microsoft OLE DB Provider for Access does not return the parameters collection back to ADO; hence ADO returns the error."
And it seems that is behaviour by design.

So you have to give to your command paramaters with appropriate type.
Hope this helps.
D.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

What error is this?? 1

smash81

Programmer

Geee

Programmer

smash81

Programmer

Geee

Programmer

dianal

Instructor

smash81

Programmer

dianal

Instructor

smash81

Programmer

dianal

Instructor

Similar threads

Part and Inventory Search

Sponsor