?
Solved

Recordset

Posted on 1999-08-24
4
Medium Priority
?
229 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
  • 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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

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

How do you create a user-centered user experience on your website? And what are some things you should consider in the process?
Magento is the best technology for eCommerce start-ups as it offers the technical expertise and visual appeal to create a store that pulls sales and earns high ROI (Return on investment).
The viewer will learn how to count occurrences of each item in an array.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses
Course of the Month3 days, 9 hours left to enroll

599 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