Link to home
Start Free TrialLog in
Avatar of PCav
PCav

asked on

Recordset

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.
ASKER CERTIFIED SOLUTION
Avatar of moehler
moehler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PCav
PCav

ASKER

Where am I changing what
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.
Did this resolve your issue?