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.

Return value from OleDbCommand

sqlQuery = "SELECT [ID] from [users] WHERE CallerName=@CallerName"; OleDbConnection conn = new OleDbConnection(connectionString); conn.Open(); cmd = new OleDbCommand(sqlQuery, conn); …

c# sql parameters oledb sqlparameter
Writing to excel using OleDb

I am attempting to export rows of data from sql to excel but my Insert Command seems to fail every …

c# oledb export-to-excel oledbdataadapter
Requested operation requires an OLE DB Session object... - Connecting Excel to SQL server via ADO

I'm attempting to take Excel 2003 and connect it to SQL Server 2000 to run a few dynamicly generated SQL Queries which …

sql-server excel vba oledb ado
the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine while reading a excel file in c#

I am reading an excel file and I want to access its contents. I am using this connection string: connectionString = …

c# excel oledb oledbconnection
c# reading csv file gives not a valid path

I can't seem to read a .csv file using the following connection string: var fileName = string.Format("{0}{1}", AppDomain.CurrentDomain.BaseDirectory, "…

c# csv oledb
Readonly connection string to an access database

I'm trying to connect to an Access database file using a System.Data.OleDb.OleDbConnection. I need to connect in …

ms-access connection-string oledb
The 'Sybase ASE OLE DB Provider' provider is not registered on the local machine

I am getting this error when trying to connect to sybase database using oledb connectivity from visual studio.net 2005 The …

vb.net oledb sap-ase
C# Open DBF file

I'm having a problem opening a DBF file - I need to open it, read everything and process it. I …

c# .net odbc oledb dbf
What are the pros and cons of OleDB versus SQLClient?

Some context: one of the systems I'm working on is a .net 2.0 web application. VB.net for the front end, …

.net sql-server-2005 oledb
SQL Server, "Invalid column name" error when inserting into Excel "linked server"

I have a simple Excel spreadsheet document (running Office 2013) that I'm using as a database using the "Microsoft Office 15.0 Access …

sql-server excel oledb