oledb Questions
1
I am using Connection Pooling to connect with SQL Server 2008.
With JNDI Name using XA connection to get access across DB server. Now my all query execute properly except query which use OPENROWSE...
Germinal asked 20/6, 2011 at 6:12
4
Solved
"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?
Puckery asked 11/4, 2012 at 8:6
2
Solved
I have a Foxpro .DBF file. I am using OLEDB driver to read the .DBF file. I can query the DBF and utilize its .CDX index file(cause it is automatically opened). My problem is that I want to query i...
Benzine asked 16/11, 2015 at 23:17
1
Solved
i am try to search for a specific value in a database by entering text into a textbox and then using SQL to query the database and then display results in the datagridview.
here is the code:
Pri...
Pubescent asked 13/11, 2015 at 20:30
2
Solved
I am reading an excel file and I want to access its contents.
I am using this connection string:
connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}; Extended...
Antistrophe asked 28/10, 2015 at 7:10
4
I have an issue getting worksheet names from an Excel spreadsheet using OLEDB. The problem is that when I use GetOleDbSchemaTable, the resulting DataTable has more than just the actual worksheet na...
1
I found the Excel 2007 Binary format (with extension .xlsb) perfectly
suitable for my needs, since it's fast to load and very compact. I deliver a
bunch of reports in Excel that carry a lot of da...
Ezzell asked 23/12, 2008 at 17:27
6
Solved
7
Solved
I am starting off with a SQLServer database. So it would seem that I should use System.Data.SqlClient namespace. But, there is a chance that we might shut down our SqlServer database and go to MySq...
1
I am writing a C# library to read in Excel files (both xls and xlsx) and I'm coming across an issue.
Exactly the same as what was expressed in this question, if my Excel file has a column that has...
Joyless asked 28/7, 2015 at 15:37
4
Solved
I would like to get the sheet name of the uploaded excel file using C# code. The file may be in .xls or .xlsx format. The Code I have used is as follows:
protected void btnGenerateCSV_Click(object...
Izanami asked 28/6, 2013 at 6:46
1
Pretty straight-forward import using SqlBulkCopy:
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=...
Guarded asked 1/2, 2013 at 0:6
5
Solved
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; Da...
4
Solved
I'm importing data from a CSV that contains approx 350 columns. This CSV import is fixed and I have absolutely no control over it.
If I attempt to open the CSV in Excel 2003, it only partially loa...
1
Solved
Microsoft.ACE.OLEDB.12.0 driver is not working on my PC, I am trying to fix it.
Error on connection opening is: "Provider cannot be found. It may not be properly installed."
Here is what i got now...
Prostyle asked 5/6, 2015 at 9:24
3
I'm using Microsoft Access file as database. I have no problem with SELECT and INSERT queries but when I try to UPDATE, record in database does not change.
Below is the code I use to run update. ...
Theobald asked 4/6, 2015 at 15:56
6
Solved
I have an x64 application which uses Microsoft.ACE.OLEDB.12.0 provider to read an MS Access Database on Windows 7 (x64) and it works fine (Office 2010 installed).
The same application running unde...
Focus asked 28/1, 2013 at 12:58
0
I am trying to run the classic asp application which uses RDS (Remote data service) on Windows Server 2008
<object id="RDS_ACCOUNTS" CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
height...
Microelectronics asked 1/4, 2015 at 10:4
3
Solved
I need to work in .net 2.0. So I can't use OpenXML.
This is my source code and I have already Installed AccessDatabaseEngine.exe.
But still getting the exception:
"Could not find installable ...
Saran asked 23/10, 2010 at 19:34
2
Does anyone know of any way to connect to an OLEDB data source directly in R?
I've tried google, CRAN and rseek with no luck whatsoever.
2
Solved
I make a program that saves and update a data from the database, I can save and read data, I can also update but the problem is, I can't select the "ID" as the index, here is my sample code using "...
4
Solved
I have a CSV Reading code for ASP.NET application I maintain. This ASP.NET website is running fine from 3 yrs now, and CSV reading code that use Ole.JetDB.4.0 is doing its work fine, except that on...
2
Solved
string strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filename + ";Extended Properties=\"Excel 12.0 Xml;HDR=Yes;IMEX=1\";";
I search on google, and got no results. I think the defau...
Prieto asked 5/7, 2012 at 9:32
2
Solved
I can use GetSchemaTable and GetXMLSchema to get information about field types, sizes etc. from a Foxpro DBF opened with VFPOLEDB but can not get any information pertaining to what indexes are in t...
Balduin asked 29/1, 2015 at 19:23
4
Solved
I am using VFPOLEDB driver to read DBF files and I keep getting this error and I am not sure why and how to fix the problem:
The provider could not determine the Decimal value. For example, the ...
© 2022 - 2024 — McMap. All rights reserved.