Top "Oledbconnection" questions

An OleDbConnection object represents a unique connection to a data source.

How to read .xlsx and .xls files using C# and OleDbConnection?

Previously I was using ExcelPackage to read data out of a .xlsx file. That was working fine but then I …

c# excel oledbconnection
"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
How to set database name as a variable in SSIS?

In my current project, the database name keeps changing and I do not want to modify my OLE DB Sources …

variables ssis oledbconnection
Export into excel file without headers c# using Oledb

I'm using OleDB and I want to export my objects into excel table. Each row in the sheet will be …

c# oledb oledbconnection oledbcommand
Dynamic OLEDB Connections in SSIS

I am designing a SSIS package which imports data from one data base to other database. In reality I need …

dynamic ssis oledbconnection
System.Data.OleDb.OleDbConnectionInternal..ctor: Unspecified error

After several hours (~6 hours Win7 64bit, ~24hours WinXP) of running multi-threaded (.NET Framework 3.5 SP1 WinForms) desktop application using .mdb files …

c# .net oledb oledbconnection
Obtaining First Excel Sheet Name With OleDbConnection

I have one problem. I need to get the excel sheet name in a work book, which looks on the …

excel oledbconnection
Can I read Excel files using the OleDbConnection Excel ACE Driver from a non-seekable System.IO.Stream rather than a file?

There's a similar question here In Memory OleDbConnection to Excel File but, this question was answered by avoiding it completely …

c# windows excel stream oledbconnection
"Unspecified error" while opening an ADODB connection

I am facing "Unspecified error" in only one PC of my users. Run-time error '-2147467259 (80004005)': Unspecified error I am …

excel vba ms-access adodb oledbconnection
SSIS Error with OLE DB destination when executing

I'm New to SSIS so have been following some online tutorials. I have come across the following and cannot figure …

sql-server ssis oledbconnection dataflow oledbexception