Questions tagged [oledb]
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.
oledb
4,458
questions
235
votes
22
answers
608k
views
Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
I created a windows application developed in .NET 3.5 in a 32 bit Windows 2008 server. When deployed the application in a 64 bit server it shows the error "Microsoft.Jet.OLEDB.4.0' provider is not ...
- 6,241
228
votes
12
answers
489k
views
'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
I get this error when I try to connect to any excel through MSSQL Server Data Import i.e. SSIS package The Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.Data)
It ...
195
votes
11
answers
307k
views
what is the difference between OLE DB and ODBC data sources?
I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources
...You should use the CommandText
property instead of the SQL property,
which now ...
- 21.3k
137
votes
8
answers
384k
views
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server
I have a 64 bit windows 7 and SQLServer 2008 R2 (64 bit)
I follow the instructions that are here to import excel file to sql server but in figure3 section of that post when I try to access excel file ...
- 4,111
110
votes
11
answers
222k
views
Using Excel OleDb to get sheet names IN SHEET ORDER
I'm using OleDb to read from an excel workbook with many sheets.
I need to read the sheet names, but I need them in the order they are defined in the spreadsheet; so If I have a file that looks like ...
- 21.3k
86
votes
8
answers
280k
views
Optimal way to Read an Excel file (.xls/.xlsx)
I know that there are different ways to read an Excel file:
Iterop
Oledb
Open Xml SDK
Compatibility is not a question because the program will be executed in a controlled environment.
My ...
- 4,875
82
votes
2
answers
429k
views
How can I import an Excel file into SQL Server? [closed]
I have data in an Excel file - actually XLSX format since it is now 2020. My requirement is to get this data into SQL Server as follows:
ad hoc, the use case being feeding tables with test data, or ...
- 3,944
68
votes
9
answers
268k
views
Microsoft.ACE.OLEDB.12.0 provider is not registered
I have a Visual Studio 2008 solution with two projects (a Word-Template project and a VB.Net console application for testing). Both projects reference a database project which opens a connection to ...
- 8,290
57
votes
4
answers
106k
views
Quick ways to test OLE DB Connection String
For debugging purpose I'd like to know ways to test OLE DB connection string quickly.
I've found this free software, it works on my machine, tested successfully.
Is there a even quicker way to do so,...
- 10k
55
votes
6
answers
100k
views
OleDB & mixed Excel datatypes : missing data
I have an Excel worksheet I want to read into a datatable - all is well except for one particular column in my Excel sheet. The column, 'ProductID', is a mix of values like ########## and n#########.
...
- 15k
48
votes
2
answers
55k
views
What is difference in adodb and oledb?
What is the difference between adodb and oledb?
What is the relation between these two?
Where does ado.net stands in context of adodb and oledb?
- 40.4k
45
votes
8
answers
60k
views
How to get a list of installed OLE DB providers?
Microsoft Excel allows import of data from "Other Sources". One of the options is to use an OLE DB provider.
How to get a list of available OLE DB providers?
- 21k
41
votes
9
answers
78k
views
Getting the first sheet from an Excel document regardless of sheet name with OleDb
I have users that name their sheets all sorts of crazy things, but I want to be able to get the first sheet of the Excel document regardless of what it is named.
I currently use:
OleDbDataAdapter ...
- 34.5k
36
votes
4
answers
101k
views
What is IMEX within OLEDB connection strings?
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=localhost;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"
What is the purpose of IMEX=2 in the above connection string?
- 3,841
31
votes
3
answers
12k
views
Why doesn't VFP .NET OLEdb provider work in 64 bit Windows?
I wrote a windows service using VB that read some legacy data from Visual Foxpro Databases to be inserted in SQL 2005. The problem is this use to run fine in Windows server 2003 32-Bits, but the ...
Nelson Marmol
28
votes
7
answers
32k
views
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, "Uploads\\countrylist.csv");
string ...
- 11.5k
28
votes
2
answers
108k
views
Reading excel file using OLEDB Data Provider
I am using OLEDB Data Provider to read excel file, but the problem is that in excel sheet some cloumn has an invalid value for example instead of number string is there,
When I read this invalid ...
- 1,291
26
votes
6
answers
92k
views
Does Microsoft OLE DB Provider for SQL Server support TLS 1.2
Our client recently upgraded from TLS 1.0 to TLS 1.2 and after this our software cannot connect with SQL server. It uses OLE DB provider for connecting to SQL server.
Below is the error which is ...
- 948
25
votes
14
answers
131k
views
AcquireConnection method call to the connection manager <Excel Connection Manager> failed with error code 0xC0202009
I have an SSIS package which reads an Excel File (Data Flow Source) and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is ...
- 1,323
24
votes
6
answers
54k
views
Parsing CSV using OleDb using C#
I know this topic is done to death but I am at wits end.
I need to parse a csv. It's a pretty average CSV and the parsing logic has been written using OleDB by another developer who swore that it ...
- 526
24
votes
7
answers
181k
views
How can I export data to an Excel file
I have an Excel file with data in it. I want to write some specific rows of it to another Excel file that I created by code. By the way I have the indexes of these rows in a list. How can i do that?
- 1,379
22
votes
9
answers
141k
views
"Cannot create an instance of OLE DB provider" error as Windows Authentication user
I am trying to run openrowset from MS SQL Server on an Oracle server.
When i execute the following command:
select * from
OPENROWSET('OraOLEDB.Oracle','srv';'user';'pass',
'select * from table')
...
- 4,308
22
votes
11
answers
65k
views
How to resolve "Could not find installable ISAM." error for OLE DB provider "Microsoft.ACE.OLEDB.12.0"
I am trying to import data from Excel 2007 (.xlsx) files into SQL Server 2008 using a T-SQL OpenRowset() command with the "Microsoft.ACE.OLEDB.12.0" OLE DB provider, and I'm getting a persistent "...
- 1,712
21
votes
4
answers
57k
views
Linked SQL Server database giving "inconsistent metadata" error
I am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance of SQL Server running in a different location, and some apps that I am building in ...
- 1,321
21
votes
3
answers
126k
views
Check if ADODB connection is open
I use the following from within some excel procedures to establish a connection to our database.
Private Const strConn As String = _
"PROVIDER=SQLOLEDB.1 ..."
Sub OpenConnection()
Set cn = ...
- 35.2k
21
votes
1
answer
34k
views
OLEDB v/s ODBC [duplicate]
What is the difference between OLEDB and ODBC? When do I use which and how do I know what I am looking at is a OLEDB driver v/s an ODBC driver?
- 2,205
20
votes
1
answer
4k
views
Full-text search using Windows Search Service and SQL Server 2008 R2
Currently I'm trying to query the Windows Search Service from a SQL Server 2008 R2 instance (also tested on SQL Server 2012) . Windows Search is being exposed as an OLE DB datasource, giving me ...
- 329
19
votes
6
answers
30k
views
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, and SQL Server 2005 for the backend. For a variety of reasons that have been lost to time, ...
- 38k
19
votes
6
answers
80k
views
How to check if an OLEDB driver is installed on the system?
How can I make sure that a certain OLEDB driver is installed when I start my application? I use ADO from Delphi and would like to display a descriptive error message if the driver is missing. The ...
18
votes
7
answers
16k
views
Is there a "proper" way to read CSV files [duplicate]
Possible Duplicate:
CSV File Imports in .Net
In .net, is there a standard library that should be used to read in csv files? All the samples on the web roll their own csv reader / parser, or use ...
- 2,454
18
votes
1
answer
39k
views
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 Database Engine OLE DB Provider".
I can connect to this using the ...
- 17k
18
votes
6
answers
115k
views
How to connect to a MS Access file (mdb) using C#?
I'm trying to connect to a mdb file and I understand that I would need Microsoft.OLEDB.JET.4.0 data provider. Unfortunately, I do not have it installed on the (University) machine.
Since, they don't ...
- 7,467
17
votes
3
answers
16k
views
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 after all.
SELECT * FROM tblSomeThing WHERE id = @id AND debut = @dtDebut AND fin = ...
- 4,160
17
votes
1
answer
21k
views
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.GetRootEnumerator();
var list = new List<String&...
- 605
16
votes
6
answers
82k
views
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine (server)
I know that is this question has dozen of answers and posts, but nothing works for me.
I have my MVC 5 application and I deploy it to the IIS 7.5 to my server. Application runs great, everything is ...
- 3,335
16
votes
8
answers
7k
views
Keeping an application database agnostic (ADO.NET vs encapsulating DB logic)
We are making a fairly serious application that needs to remain agnostic to the DB a client wants to use. Initially we plan on supporting MySQL, Oracle & SQL Server. The tables & views are ...
- 1,769
16
votes
9
answers
158k
views
how to resolve DTS_E_OLEDBERROR. in ssis
In an ssis package consists of data flow task,contains
OLEDB source and OLDB Target ..provider is sql native client..This used to run fine ..but now got an error as shown below..
Please tell me how ...
- 3,989
16
votes
2
answers
19k
views
Excel cell-values are truncated by OLEDB-provider
I'm using the OleDbConnection class to retrieve data from an Excel 2000/2003 workbook:
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + ...
- 19.6k
16
votes
6
answers
24k
views
OleDbConnection gets "External component has thrown an exception."
I' m using a Windows Forms application to export data to excel.
Application is built both x64 and x86.
So both version of Microsoft Access Databse Engine must be installed to work the application on ...
- 1,178
15
votes
7
answers
84k
views
VBScript & Access MDB - 800A0E7A - "Provider cannot be found. It may not be properly installed"
I've having a problem with a VBScript connecting to an access MDB Database. My platform is Vista64, but the majority of resources out there are for ASP/IIS7.
Quite simply, I can't get it to connect. ...
- 151
15
votes
4
answers
35k
views
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 string looks like this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Data;Extended ...
- 11.1k
15
votes
7
answers
25k
views
OleDB not supported in 64bit mode?
I've been using Microsoft.Jet.OLEDB.4.0 and Microsoft.ACE.OLEDB.12.0 to read in .csv, .xls, and .xlsx files.
I just found out that neither of these technologies are supported in native 64bit mode!
I ...
- 40.5k
15
votes
5
answers
39k
views
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 and ends with the following error:
Msg 701, Level 17, State 123, ...
14
votes
2
answers
8k
views
Which One is Best OLEDB Or Excel Object Or Database
I need to work with Excel 2007 File for reading the data. for that which one is the best way to do that:
Using OLEDB Provider
Excel Interop Object
Dump the Excel data to Database and Using Procedure
...
- 484
14
votes
4
answers
12k
views
Passing query parameters in Dapper using OleDb
This query produces an error No value given for one or more required parameters:
using (var conn = new OleDbConnection("Provider=..."))
{
conn.Open();
var result = conn.Query(
"select code, ...
- 24.4k
14
votes
5
answers
7k
views
How to check a Cell contains formula or not in Excel through oledb reader or excel library, excel datareader or NPOI etc (Except Interop)?
How to check a Cell contains formula or not in Excel through oledb reader ?
System.Data.OleDb.OleDbConnection conn2 = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data ...
- 553
14
votes
2
answers
2k
views
SQL Agent job failure with SSIS package to Access DB
I have an SSIS package that runs a script task (mostly, and a few other things). The script task connects to an Access database using an OleDB connection. This is the Microsoft Jet 4.0 connection. I ...
- 206k
13
votes
2
answers
21k
views
Trying to insert DateTime.Now into Date/Time field gives "Data type mismatch" error
If I try to write a datetime to a record in an MS-Access database the easy way, like this
cmd.CommandText = "INSERT INTO [table] ([date]) VALUES (?)";
cmd.Parameters.AddWithValue("?", DateTime.Now);
...
- 46.3k
13
votes
4
answers
28k
views
How do I query raw data from a Proficy Historian?
How can I retrieve raw time-series data from a Proficy Historian/iHistorian?
Ideally, I would ask for data for a particular tag between two dates.
- 108k
13
votes
3
answers
3k
views
SEHException on OleDb connection open
I'm developing a small application that will simplify logging, it does so by adding some inputs to an MS Access database through OleDB.
let private conn = new OleDbConnection(connectionString)
let ...
- 2,115