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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry about that. Check the code generate in ID. There should be a line like
rs.open sql,DNSName,cursortype,loc ktype,opti on
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.
rs.open sql,DNSName,cursortype,loc
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?
ASKER