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.

OleDbParameters and Parameter Names

I have an SQL statement that I'm executing through OleDb, the statement is something like this: INSERT INTO mytable (name, …

c# .net oledb oledbcommand oledbparameter
Is there a way to force Microsoft.Jet.OLEDB to get date Columns in MM/DD/YYYY format from Excel?

I am having a problem with reading DateColumns from an excel sheet. Sometimes people use different date Formats and this …

c# excel date oledb oledbdatareader
Getting "Cannot find installable ISAM" error

I'm facing a problem with my console application. I want to read info from Microsoft Access database and display it …

oledb isam
Delphi with SQL Server: OLEDB vs. Native Client drivers

I have been told that SQL Native Client is supposed to be faster than the OLEDB drivers. So I put …

sql-server delphi oledb ado sqlncli
OleDB INSERT command error

I have a database (i use MS ACCESS) I have this insert code, I can read data but got error …

c# sql winforms ms-access oledb
VB.NET - Visual Foxpro OLE DB Problem with Numeric Decimal Column

In Short: I'm using VB.NET 2008 to connect to a Visual Foxpro 6 Database using the vfpoledb.1 driver. When I attempt …

vb.net oledb foxpro visual-foxpro
OLE DB vs OPEN XML SDK vs Excel.interop

I need to read XLSX files and extract a maximum amount of content from it. Which of the API's should …

c# oledb openxml
pass null parameter to SQL server query

How can I pass a null parameter to a SQL server query. I have a simple table with a nullable …

sql sql-server oledb oledbparameter
"Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine" but I have it installed already

I have the same problem as others but (in this case) I have already installed that component. UPDATE: I have …

asp.net oledb oledbconnection oledbexception
DSN-less ODBC connect string for legacy Sybase Adaptive Server Anywhere

This is a failed response to this article: Sybase, VB and ADO I just did a VB6 project connecting to …

vb6 odbc oledb sybase-asa