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 find which OLE provider is available for SQL Server?

I try to access an Excel file in SSMS. After searching the internet, I could not get it working. Here …

sql sql-server-2008 tsql oledb linked-server
System.Data.OleDb.OleDbException: Could not find installable ISAM

I have scoured the net, and found many people asking this, yet none have fixed my answer. I have a …

asp.net oledb
OLE DB provider not been registered error even though it is registered

I have a 32 bit Windows 7 machine. I am trying to access an excel sheet by creating linked server in SQL …

sql-server oledb
Is it possible to change default OLEDB connection timeout value? Run-time error (80040e31)

I have one legacy app (VB) and I have an issue with the timeout error while connecting to SQL Server (…

sql-server vba oledb connection-timeout
There is insufficient system memory in resource pool 'internal'

SQL Server 2008 Linked Server and ad-hoc INSERTs cause a rapid memory leak which eventually causes the server to become non-responsive …

sql-server-2008 memory-leaks oledb linked-server
How to check if a client has SQLNCLI10 provider installed when browsing?

I have a c# website that allows a client to connect directly to a remote SQL Server database from their …

asp.net sql-server sql-server-2008 oledb sqlncli
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?

In my C# application I am using the Microsoft Jet OLEDB data provider to read a CSV file. The connection …

c# .net csv oledb
Read password protected excel file using OLEDB in C#

In my c# application I am using OLEDB connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.xls;Extended …

c# excel oledb
Reading Comma Delimited Text File to C# DataTable, columns get truncated to 255 characters

We are importing from CSV to SQL. To do so, we are reading the CSV file and writing to a …

c# .net csv oledb jet
OLEDB v/s ODBC

What is the difference between OLEDB and ODBC? When do I use which and how do I know what I …

odbc oledb driver