oledb Questions
2
Solved
So, I have the same symptoms as described in C#/ASP.NET Oledb - MS Excel read "Unspecified error", but my my answer did not seem to fix it. Even always closing the OleDBConnection and dis...
Menorah asked 30/5, 2011 at 9:50
4
Solved
I have two SQL queries:
A.
SELECT (upper(rtrim(ltrim(lastname))) + upper(rtrim(ltrim(firstname))) +
upper(rtrim(ltrim(middlename))) + rtrim(ltrim(v)) ) AS userCompareStr
FROM atable ;
and
B...
Marymarya asked 1/7, 2011 at 18:46
3
Solved
I have used as a base for what I want to do this site:
http://www.codeproject.com/script/Articles/ViewDownloads.aspx?aid=8500
So basically, I want to use OleDb in my C# Windows form application to...
1
I have installed the 'Microsoft Access Database Engine 2010 Redistributable' as described in the blog entry
http://danielcai.blogspot.com/2011/02/solution-run-jet-database-engine-on-64.html
and ...
Few asked 8/6, 2011 at 20:0
2
Solved
I'm using the ACE OLEDB driver to read from an Excel 2007 spreadsheet, and I'm finding that any '.' character in column names get converted to a '#' character. For example, if I have the following ...
2
Solved
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=" + filename + ";" +
"Extended...
Assuan asked 22/5, 2009 at 15:35
2
Solved
I'm working with a CSV that contains characters like:
” and •
I am reading the CSV via OleDb and the provider is Microsoft.Jet.OLEDB.4.0. when the data is loaded into the OleDbCommand, the chara...
1
Solved
I have an Excel 2007 workbook that contains tables of data that I'm importing into DataTable objects using ADO.NET.
Through some experimentation, I've managed to find two different ways to indicat...
Ruination asked 21/4, 2011 at 1:7
7
We have a C#/ASP.NET (2.0) application running on IIS 6 on Windows Server 2003 Enterprise Edition. This application reads Excel files using OleDb, but there are instances when we get an "Unspecifie...
3
Solved
I'm trying to get a new DotNetNuke site up and running on our 64-bit server, and I'm encountering the following error message:
"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the loca...
Poker asked 29/7, 2009 at 17:45
2
Solved
I use OleDB to read an Excel file. One of the columns has a "Common" format and contains both strings with letters and values consisting of numbers only. String values are retrieved without problem...
1
Solved
I am evaluating different methods for inserting large amount of data in SQL server. I've found SqlBulkCopy class from Ado.Net and IRowsetFastLoad interface from OLEDB. As far as I know, IRowsetFast...
Airspeed asked 19/11, 2010 at 23:44
2
Solved
Question:
I am working with existing commercial MS Visual Foxpro application, and need to extract data from the database directly using a c# application. Unfortunately, not all of the tables are s...
2
Solved
I need to work with Excel 2007 File for reading the data. for that which one is the best way to do that:
Using OLEDB Provider
Excel Interop Object
Dump the Excel data to Database and Using Proced...
Bromberg asked 31/8, 2010 at 10:48
2
Does it make a difference whether I use SQLCommand/SQLConnection instead of OleDbCommand/OleDbConnection. Do I get any advantages out of that, from a API comfortability, feature, performance or sec...
Bove asked 16/2, 2010 at 14:37
2
Solved
I am having a problem with reading DateColumns from an excel sheet.
Sometimes people use different date Formats and this brings a problem. Let's say when I expect 07/26/2010 from an Excel column I...
Thisbee asked 20/8, 2010 at 15:9
3
Solved
1
I need to check in my program if the VFPOLEDB provider is installed/registered? I want to show a message and tell the user to download and install the provider. How do I check it in C#?
8
We are making a fairly serious application that needs to remain agnostic to the DB a client wants to use. Initially we plan on supporting MySQL, Oracle & SQL Server. The tables & views are ...
2
Solved
I'm using ICommandText::GetCommandText method.
According to the MSDN documentation (http://msdn.microsoft.com/en-us/library/ms709825(v=VS.85).aspx) I need to use IMalloc::Free to release the memory...
2
Solved
I'm using the OleDB DataReader to get data from my excel files (but this problem occurs in DataTable.Fill as well). The thing is that I have a column that should return strings. All's fine and work...
8
Solved
I'm writing to Excel file using OLEDB (C#).
What I need is just RAW data format.
I've noticed all cells (headers and values) are prefixed by apostrophe (')
Is it a way to avoid adding them in all...
Libbey asked 16/4, 2009 at 11:0
1
Short question:
I am finding I need to use MARS over ODBC but not over ADO/OLEDB, is that correct?
Longer explanation:
I just discovered my ODBC code (using "Driver={SQL Native Client}", MFC CDat...
Arronarrondissement asked 18/2, 2010 at 9:51
7
Solved
1
Solved
I have created a table on an Oracle 10g database with this structure :
create table myTable
(
id number(32,0) primary key,
myData clob
)
I can insert rows in the table without any problem, but w...
© 2022 - 2024 — McMap. All rights reserved.