Creating parameters in vbscript

[llaurit]

I am trying to create a parameter for a SQL field in Visual InterDev.

Set tmpParam = addrequest.CreateParameter ("@uid", adInteger, adParamOutput, 16, uid)

I keep getting the error: ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another

Is my syntax wrong??

Thanks for any help

Lynn

 

[culshaja]

I have two questions:

Firstly, have you included adovbs.inc?

Secondly, is the underlying datatype an integer or are you using a uniqueidentifier (GUID)?

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[llaurit]

I did try including the adovbs.inc file and I am still getting an error. The underlying data type in SQL is "numeric." Thanks for the reply!

Lynn

 

[culshaja]

What RDBMS are you talking to?

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[llaurit]

I am using SQL Server 7.0 to store my data and using Visual InterDev as the user interface on the Internet. Is this what you were asking about??

Lynn

 

[culshaja]

If you are using SQL Server 7 then the data type should be one of the following:

smallint
integer
uniqueidentifier
single
double

and I can't remember if there is a long integer. I think the problem may be is that if you have got an integer you can't have a 16 digit integer! I'll check and get back to you later what the max number of digitds an integer can have is.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305