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 Prope...

There were announcements back in 2011 about Microsoft SQL Server OLEDB access going retire, now I heard it has been deprecating starting SQL SERVER 2014? However it is not apparent from MSDN pages ...

I am trying to deploy an Analysis Services cube in SQL Server 2012. My user account is REALM\Merin where REALM is the domain and my computer's name is Hercules. I am already in Analysis Service's a...

I am using OLEDB connection to read data from excel files. I am facing issues while using IN operator in the Select query. Below is my query, string EmployeeIds = "'1231','1232','1233'"; SELECT [...

I have already installed IBM DB2 Database Express on Windows 7 Pro. Now, I would like to create my C# code in order to select/insert/update records in DB2 tables. I spend the whole day searching ...

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'...

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 sev...

This question is part in a series of bugs in the Microsoft ODBC driver: ODBC driver fails to raise errors; but instead suppresses them Reading columns out of order returns incorrect result...

I am running following code /*Fetchinch Last CustID from custMaster*/ int ID = 0; try { con.Open(); da = new OleDbDataAdapter("select max(Id) from custMaster",con); DataSet ds = new DataSet(); ...

I'm attempting to read a spreadsheet file called Book1.xls which contains a worksheet called Sheet1 However I'm getting the following error: The Microsoft Jet database engine could not find the...

I'm trying to read Excel spreadsheets with a 64bit Process. Therefore I use the 64 bit Version of Micorosft Access Database Engine 2010. The following code var cs = @"Provider=Microsoft.ACE.OLEDB...

I have an Excel sheet with two column, one is a number , and second column have a picture. i want to read these data from c# with oledb connection, i can read number easily , but pictures is not co...

I'm using the below code to connect to an Access Database using OleDb connection in C# .Net How can I know if the table that I have hard-coded into the program actually exists in the file, so that...

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 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 va...

I have an Oracle 11g XE database that I would like to transfer into SQL Server Express 2005. At first I thought I'd just generate the tables in Oracle as SQL, manipulate the data formats, and run ...

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 d...

Ok so I'm having this: Dim sql As String = "SELECT * FROM Articles" dAdapter = New OleDbDataAdapter(sql, connection) dSet = New DataSet("tempDatatable") With connection .Open() dAdapter.Fill(dS...

I have an SQL Server database, and I need to push data into it through vbscript, as well as pull data into Excel. I have found multiple connection strings, but no repository for the benefits of per...

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.

I have an asp.net mvc app hosted on IIS. I have a form from where users upload excel files containing 50k+ rows. I read the excel file with the following C# code. public DataTable GetExcelDataTab...

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?

I'm needing to import an Excel spreadsheet into my program and have the following code: string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properti...

I have been told that SQL Native Client is supposed to be faster than the OLEDB drivers. So I put together a utility to do a load-test between the two - and am getting mixed results. Sometimes one ...

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...