Hi!
Are you sure recordset object was disconnected before this assignment (in other words, it contained no connection)? Are you sure that connection object is correct? (When working under MTS and connection is not established in the Init event of the object, SetComplete or SetAbort call will free that connection).
>Hi, Everybody!
>
>I'm experimenting a new trouble with Doug's sample of N-Tier published on CoDe Magazine.
>
>If I instantiate my business class as a VFP class, my RecordSet (filled by a GetCustomerByID method), is writeable... but, if I instatiate it as a COM object, in the following excerpt of code (of dataclass::GetRecordSet method)
>
>toRS.ActiveConnection = .oConnection
>
>I got the following error:
>
>OLE IDispatch exception code 0 from ADODB.Recordset: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another...
>
>
>any help?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.