Top "Oledb" questions

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing data from a variety of sources in a uniform manner.

How to get list of ONLY excel worksheet names in Excel using OLEDB; filter out non-worksheets that show up in metadata

I have an issue getting worksheet names from an Excel spreadsheet using OLEDB. The problem is that when I use …

c# excel oledb
Get column names from excel file of a specific sheet using c# with OleDbConnection

So far I have managed to get the column names of the whole excel file, but what I would like …

c# excel oledb oledbconnection
Get a list of all Access ACE.OLEDB drivers installed on the system

Using the following code I can enumerate the OLEDB providers registered on my system static void DisplayData() { var reader = OleDbEnumerator.…

c# ms-office oledb
Connect to IBM i server from Sql Server 2008 R2

I have a big deal: I have to connect (I just want to read data, not to write) to my …

sql-server database-connection oledb ibm-midrange linked-server
OleDbCommand parameters order and priority

I have been debugging this query for the last 40 minutes, and the problem apparently is the order of the parameters …

c# ms-access ado.net oledb
Application trust level

How can i change Trust level? I writing c# windows form app with oledb and can't use append query because …

c# winforms permissions oledb trust
Is there a "proper" way to read CSV files

Possible Duplicate: CSV File Imports in .Net In .net, is there a standard library that should be used to read …

c# .net csv oledb
Updating Excel Sheet Using OleDb

I am trying to update a single cell of an Excel sheet. Note, in my example code below I am …

c# excel oledb oledbcommand
Passing Full Result set to Data Flow Task SSIS

The Proc inside Execute Sql Task returns Start and End date, I stored those values as full result set on …

sql ssis oledb execute flow
.Net System.OutOfMemoryException filling a datatable

I need to extract data from a .dbf file and transform it into xml. I wrote a routine that does …

.net vb.net dataset oledb dbf