Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another ERROR

Reply
Thread Tools

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

 
 
SyrUser03
Guest
Posts: n/a
 
      03-11-2005
I am getting this error and I can't seem to figure it out.

<%

Set cdoConfig = CreateObject("CDO.Configuration")

With cdoConfig.Fields
.Item(cdoSendUsingMethod) = cdoSendUsingPort ***** ERRORS ON
THIS LINE *****
.Item(cdoSMTPServer) = "CT00EXCIM01"
.Update
End With

dim conn, RS, strSQL, mycount

SCRIPT_NAME = Request.ServerVariables("SCRIPT_NAME")
Ticket = Request.QueryString("tn")

Function sIn(s)
sIn = "'" & Replace(s, "'", "''") & "'"
End Function

Set Conn = Server.CreateObject("ADODB.Connection")
DSNtest="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
Server.MapPath("/database/sa inventory.mdb")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.Open DSNtest

conn.execute ("SELECT * FROM Problems LEFT JOIN Resolutions ON
Problems.TicketNumber = Resolutions.TicketNumber WHERE Problems.TicketNumber
= " & Ticket & " ORDER BY Resolutions.ActDate DESC;")



 
Reply With Quote
 
 
 
 
Steven Burn
Guest
Posts: n/a
 
      03-11-2005
It's cdoSendUsing not cdoSendUsingMethod

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"SyrUser03" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I am getting this error and I can't seem to figure it out.
>
> <%
>
> Set cdoConfig = CreateObject("CDO.Configuration")
>
> With cdoConfig.Fields
> .Item(cdoSendUsingMethod) = cdoSendUsingPort ***** ERRORS ON
> THIS LINE *****
> .Item(cdoSMTPServer) = "CT00EXCIM01"
> .Update
> End With
>
> dim conn, RS, strSQL, mycount
>
> SCRIPT_NAME = Request.ServerVariables("SCRIPT_NAME")
> Ticket = Request.QueryString("tn")
>
> Function sIn(s)
> sIn = "'" & Replace(s, "'", "''") & "'"
> End Function
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> DSNtest="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
> Server.MapPath("/database/sa inventory.mdb")
> Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
> Conn.Open DSNtest
>
> conn.execute ("SELECT * FROM Problems LEFT JOIN Resolutions ON
> Problems.TicketNumber = Resolutions.TicketNumber WHERE Problems.TicketNumber
> = " & Ticket & " ORDER BY Resolutions.ActDate DESC;")
>
>
>


 
Reply With Quote
 
 
 
 
Dthmtgod
Guest
Posts: n/a
 
      03-11-2005
cdoSendUsingMethod works on all my other websites. I think I was missing
the METADATA file

<!--
METADATA
TYPE="typelib"
UUID="CD000000-8B95-11D1-82DB-00C04FB1625D"
NAME="CDO for Windows 2000 Library"
-->

I added this code to my page and it moved on a little farther. Thanks for
your help.



"Steven Burn" <(E-Mail Removed)> wrote in message
news:er8Wl$(E-Mail Removed)...
It's cdoSendUsing not cdoSendUsingMethod

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"SyrUser03" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am getting this error and I can't seem to figure it out.
>
> <%
>
> Set cdoConfig = CreateObject("CDO.Configuration")
>
> With cdoConfig.Fields
> .Item(cdoSendUsingMethod) = cdoSendUsingPort ***** ERRORS ON
> THIS LINE *****
> .Item(cdoSMTPServer) = "CT00EXCIM01"
> .Update
> End With
>
> dim conn, RS, strSQL, mycount
>
> SCRIPT_NAME = Request.ServerVariables("SCRIPT_NAME")
> Ticket = Request.QueryString("tn")
>
> Function sIn(s)
> sIn = "'" & Replace(s, "'", "''") & "'"
> End Function
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> DSNtest="Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
> Server.MapPath("/database/sa inventory.mdb")
> Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
> Conn.Open DSNtest
>
> conn.execute ("SELECT * FROM Problems LEFT JOIN Resolutions ON
> Problems.TicketNumber = Resolutions.TicketNumber WHERE

Problems.TicketNumber
> = " & Ticket & " ORDER BY Resolutions.ActDate DESC;")
>
>
>



 
Reply With Quote
 
 
 
Reply

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
css conflict (or html conflict) charles cashion HTML 2 02-18-2009 09:41 PM
It's strange that the address of array elements are not acceptable template-arguments!! Wayne Shu C++ 8 01-29-2007 08:28 PM
DataAdd Error: Arguments are wrong type or are out of acceptable r Jack ASP General 1 12-14-2004 11:55 PM
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another Tim Gaunt ASP General 7 12-18-2003 11:59 PM
"Arguments are of the wrong type, out of acceptable range" error J. Muenchbourg ASP General 1 07-25-2003 02:34 PM



Advertisments