Data type problem, something to do with datatypeEnum??

[Lukelrc]

Hi all.

I'm having trouble connecting to my sql server database correctly
beacause of value type problems, specifically the date fields. When i
try and run the page i get the follwoing error:

'Application uses a value of the wrong type for the current
operation.'

I beleive the problem is releated to DatatypeEnum values. At the
moment i have the date fields set to 135, but whatever i try i cant
seem to it to work.

I would be very greatful if someone could spot where i'm going wrong.

Datatbase connection:
set CmdAddPr = Server.CreateOb ject("ADODB.Com mand")
CmdAddPr.Active Connection = MM_Intranet_STR ING
CmdAddPr.Comman dText = "dbo.AddPressRe lease"
CmdAddPr.Comman dType = 4
CmdAddPr.Comman dTimeout = 0
CmdAddPr.Prepar ed = true
CmdAddPr.Parame ters.Append CmdAddPr.Create Parameter("@RET URN_VALUE",
3, 4)
CmdAddPr.Parame ters.Append
CmdAddPr.Create Parameter("@pre ssreleasedescri ption", 200,
1,250,CmdAddPr_ _pressreleasede scription)

CmdAddPr.Parame ters.Append
CmdAddPr.Create Parameter("@pre ssreleasedate", 135,
1,20,CmdAddPr__ pressreleasedat e)

CmdAddPr.Parame ters.Append CmdAddPr.Create Parameter("@use rname", 200,
1,50,CmdAddPr__ username)

CmdAddPr.Parame ters.Append CmdAddPr.Create Parameter("@las tupdated",
135, 1,20,CmdAddPr__ lastupdated)

CmdAddPr.Parame ters.Append CmdAddPr.Create Parameter("@fil esize", 131,
1,20,CmdAddPr__ filesize)

CmdAddPr.Parame ters.Append CmdAddPr.Create Parameter("@pub lish", 128,
1,20,CmdAddPr__ publish)
CmdAddPr.Execut e()

.....My stored procudure:

CREATE Procedure dbo.AddPressRel ease

@pressreleasede scription varchar(250),
@pressreleaseda te datetime,
@username varchar(50),
@lastupdated datetime,
@filesize numeric,
@publish bit
As
Declare @pressreleaseid int

Select @pressreleaseid = nextpressreleas eid from nextids

Insert into PressReleases(p ressreleaseID,p ressreleasedesc ription,pressre leasedate,usern ame,lastupdated ,filesize,publi sh)
Values (@pressreleasei d,@pressrelease description,@pr essreleasedate, @username,@last updated,@filesi ze,@publish)

Update nextids set nextpressreleas eid = nextpressreleas eid + 1

return @pressreleaseid
GO

.....and my sql server table:

Data type Length
PressReleaseID int 4
PressReleaseDat e datetime 8
Publish bit 1
Username varchar 50
Filesize varchar 50
LastUpdated datetime 8
PressReleaseDes cription varchar 255

Thanks in advance,

Luke

[Bob Barrows [MVP]]

Lukelrc wrote:

Hi all.

I'm having trouble connecting to my sql server database correctly No, you're not. Your connection is happening correctly. Your problem is in
executing your procedure.
beacause of value type problems, specifically the date fields. When i
try and run the page i get the follwoing error:

'Application uses a value of the wrong type for the current
operation.'

I beleive the problem is releated to DatatypeEnum values. At the
moment i have the date fields set to 135, but whatever i try i cant
seem to it to work.

Parameters with the numeric datatype need to have their NumericScale and
Precision properties set.

Coding the Parameters collection can be tricky, and many free code
generators have been developed, including one that i wrote. It is available
here:
http://www.thrasherwebdesign.com/ind...asp&c=&a=clear

In order to use the code created by this generator, you will need to define
the ADO constant enumerations in your web page. One way to do that is to
#include the adovbs.inc file. A better way is shown here:
http://www.aspfaq.com/show.asp?id=2112

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"