Top "Oledbconnection" questions

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

OLEDBConnection.Open() generates 'Unspecified error'

I have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection …

c# debugging connection-string xls oledbconnection
SSIS no column information was returned by the sql command

I ran my Stored Procedure in BI_Test_Server. Then I executed it using exec [dbo].[bi_resource_dimension_sp] 1,1 …

visual-studio-2008 ssis oledbconnection
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=" + …

.net excel oledb oledbconnection
Get column names from excel file of a specific sheet using c# with OleDbConnection

So far I have managed to get the column names of the whole excel file, but what I would like …

c# excel oledb oledbconnection
SSIS Package Not Running as 32bit in SQL Server 2012

I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a …

ssis sql-server-2012 oledbconnection visual-foxpro ssis-2012
Modify existing excel Connection Name in VBA

I need to update the Connection Name of an excel workbook's sql connection. This is my attempt. I have been …

excel vba external oledbconnection
How to create a table before using sqlbulkcopy

I have a DBF file which I am trying to import and then write that to a SQL table. The …

c# sql database oledbconnection
The Microsoft Office Access database engine cannot open or write to the file ''

Data needs to be read into .net gridview from excel worksheet. Here are the aspx and aspx.cs codes. ASPX: &…

c# asp.net excel oledbconnection oledbexception
Reading from Excel: Microsoft.Jet.OLEDB.4.0 error on 64 bit systems

I am reading the contents of an excel sheet in my application using: OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.…

c# .net oledbconnection
Excel reading in ASP.NET : Data not being read if column has different data formats

I have an asp.net C# application where i am reading the contents of a spreadsheet using OLEDBConnection. I am …

c# asp.net excel oledbconnection