• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

Why am I getting "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

I am using classic ASP to access records on an Oracle database.

The connection string I am using works with other tables on the database with no issues.

If I comment out the RS4 portion of this code the page runs fine and displays the other values...just not the tech values.

The database guy I am working with says he gets records returned while using Microsoft Query. I've even changed the query to a basic form of "select this from that" and still the same error.

When I run this part of the code (attached) I get:

ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/web/report.asp, line 378

with line 378 being:

RS4.OPEN sqlTechQry, oConnMTV, 3,3

I'm not sure if there is an issue with the database connection string or something else. The attached code has the oracle connection string I am using and the code.

Any help would be appreciated. Document1.txt
0
Donnie Walker
Asked:
Donnie Walker
  • 3
  • 2
  • 2
1 Solution
 
ajexpertCommented:
Can you print the query in HTML page before RS4.OPEN

debug.print(sqlTechQry)

RS4.OPEN sqlTechQry, oConnMTV,3,3
0
 
Donnie WalkerAuthor Commented:
I get this error:

Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'debug.print'

But I have printed out the query and confirmed it does work with Microsoft Query.
0
 
ajexpertCommented:
May be you need to debug little more

Here are the steps to debug

http://www.codeproject.com/KB/debug/DebugVBScriptVS2008.aspx

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
i would change your rs4.open statement to:

set RS4 = oConnMTV.Execute( sqlTechQry )

since you're not updating the recordset, it's better (performance-wise) to do it this way.
0
 
Donnie WalkerAuthor Commented:
When I do that I get this error:

Microsoft OLE DB Provider for Oracle (0x80040E0C)
Command text was not set for the command object.
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
this usually indictaes something wrong with the query. can you test out a simple select statement using the syntax I provided, just so we can debug it further?
0
 
Donnie WalkerAuthor Commented:
Thanks! Your suggestion led me to examine my code and I discovered I was calling a function inside a larger function and that was causing the error.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now