Top "Oledb" questions

OLEDB CASE WHEN in SELECT Query

How can use case when statement with oledb to excel file ? Like select prodid, case prodid when 1 then 'fine' when 2 …

sql oledb ms-jet-ace

"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine"...DNN

I'm trying to get a new DotNetNuke site up and running on our 64-bit server, and I'm encountering the following …

asp.net 64-bit oledb dotnetnuke

ADO with XLSX files in Delphi XE

The issue here is ADO connection with Excel - is this still the standard way to read/write excel files …

excel delphi oledb ado ms-jet-ace

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=...")) { …

oledb dapper

Using Parameters with OleDbDataAdapter in C#

I'm using OleDb to populate a DataTable. I'm trying to use a parameterized query, but it doesn't seem to work …

c# oledb oledbparameter

OLEDB Does not return first row of excel file

I'm using Microsoft.ACE.OLEDB.12.0 to connect to Microsoft excel file and fetch data from it. I write my codes …

c# oledb

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

SSIS Cannot convert between unicode and non unicode...but it's not true, how come?

I have a simple DTSX that takes in some data, and write it to a SQL server DB, on this …

unicode ssis oledb dataflowtask

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

Jet Engine - 255 character truncation

I'm needing to import an Excel spreadsheet into my program and have the following code: string connectionString = String.Format(@"Provider=…

.net excel import oledb jet