troubleshooting Question

SafeArrayGetUBound is returning zero in the lpUbound property ???

Avatar of sqlconsumer
sqlconsumerFlag for United States of America asked on
3 Comments1 Solution1156 ViewsLast Modified:

I'm using ADO to extract data from SQL server. I have an object that runs a stored procedure and returns a recordset successfully.

I'm using GetRows() to populate my SAFEARRAY. I then try to find the Ubound Property using SafeArrayGetUBound and I always retrun zero???

I've not had much experience with SAFEARRAY's does anyone know what I'm doing wrong?

bool SQLStoredProc::GetRows()
	if (m_RSPtr == NULL)
		return false;
	try {
		m_vArrRows = m_RSPtr->GetRows(ADODB::adGetRowsRest);
        HRESULT hr = SafeArrayGetUBound(m_vArrRows.parray, 1,&m_lUbound);
	catch (_com_error e)
		ATLTRACE(_T("Exception thrown: %s\n"), (LPCTSTR)e.Description());
		return false;
    return true;

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros