How is possible to get rows count of rowset in OLE DB? I have filled RowSet using CCommand and CAccessor and now I dont know how to get rows count. I can go through all rows using MoveNext() but it does not seem efective. Thanks ...
Hi, is it possible to use OLE DB in MFC C++ to execute universal query? I want to create function, one of parameters is sql query and I want to return something like two dimensional array with rows and columns returned by query. The problem is, I don't know the structure of the query (of returned data), so I can't use CAccessor. Thanks...
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.Data.Odbc; namespace Username { public partial class Form2 : Form { public Form2() { InitializeComp...
I'm importing Oracle data into SQL Server. After my OLE DB Source that runs a query to grab the data to process, I'm trying to call a TSQL function on a field value somehow... I have an SSIS data flow where I have a datetime column called DepartureDateGMT, and an integer column called DepartureTimeZoneKey. I have a TSQL Function calle...