Unspecified error when obtaining an ADO recordset from a C# progra

[Chris]

Hi,
I'm using an ADO DB connection in a C# program to retrieve records from
either an MS Access or MS SQL Server 2000 data source. The queries work fine
when tried out in the query analyzers for both data sources but fails within
the program at the point of performing the query:

rsOpen(sQuery.ToString(), m_Conn, ADODB.CursorTypeEnum.adOpenDynamic,
ADODB.LockTypeEnum.adLockOptimistic, (int)ADODB.CommandTypeEnum.adCmdText);

A COMException is being raised, which outputs an 'Unspecified error' and
returns HResult = -2147467259 and _COMPlusExceptionCode = -532459699. Can you
give me more insight to this problem pls?

Thanks and Regards,
Chris