?
Solved

Recordset

Posted on 1999-08-24
4
Medium Priority
?
227 Views
Last Modified: 2013-12-25
I created a new project using VI 6.  The created a new database connection, tested the connection everything worked fine.

Then I dropped a recordset DTC on to the page and changed only the SQL statement.  I changed it from pointing to a table to SELECT * FROM customer ORDER BY name (real basic).  Then I clicked view in browser and I get the following error

ADODB.Connection error '800a0bb9'

The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.


I do not know what is causing this error since like I said I haven't changed anything.
0
Comment
Question by:PCav
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
moehler earned 800 total points
ID: 1865176
Change your option settings in the recordset open command to adCmdTest or &H0001.
0
 

Author Comment

by:PCav
ID: 1865177
Where am I changing what
0
 
LVL 2

Expert Comment

by:moehler
ID: 1865178
Sorry about that. Check the code generate in ID. There should be a line like

rs.open sql,DNSName,cursortype,locktype,option

When you changed from a table, the default, to a SQL statement ADO must know about that. That is why to you adCmdText versus adCmdTable.
0
 
LVL 2

Expert Comment

by:moehler
ID: 1865179
Did this resolve your issue?
0

Featured Post

How To Reduce Deployment Times With Pre-Baked AMIs

Even if we can't include all the files in the base image, we can sometimes include some of the larger files that we would otherwise have to download, and we can also sometimes remove the most time-consuming steps. This can help a lot with reducing deployment times.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question