oledb Questions
3
Solved
Building on this question: how to run query on dataset?
I'm trying to query a datatable from my dataset where the text contains a string, similar to the String.Contains method or the sql LIKE oper...
1
Using the following code I can enumerate the OLEDB providers registered on my system
static void DisplayData() {
var reader = OleDbEnumerator.GetRootEnumerator();
var list = new List<String&...
7
Solved
I want to retrieve the resulting value of a select statement into a string variable like this:
OleDbCommand cmd1 = new OleDbCommand();
cmd1.Connection = GetConnection();
cmd1.CommandText = "SE...
1
Solved
Fellow more advanced programmers:
Please forgive me if this seems like the tired Python 32-bit/64-bit ODBC/OLEDB Windows issue but I tried searching the forums and can't quite find the reason to m...
3
Solved
3
After several hours (~6 hours Win7 64bit, ~24hours WinXP) of running multi-threaded (.NET Framework 3.5 SP1 WinForms) desktop application using .mdb files as backend I'm getting the following runti...
Leiker asked 29/10, 2010 at 9:22
2
Solved
I am getting a "Data type mismatch in criteria expression" error when inserting a new record into an access database. The application runs fine on UK computers, but on South African computers it th...
1
I'm confused. I'm trying to add a single record into an Access 2000 database using ASP.Net.
However, when I try to add new record, I get the following error:
Exception Details: System.Data.O...
Bunting asked 17/7, 2014 at 8:30
2
Solved
is there any references/manuals on SQL syntax in EXCEL connected with Microsoft OLE DB Provider for Jet 4.0 ?
For example, how do I write constants of type date?
What keywords/functions/clauses a...
1
Solved
i have an excel with multi-sheets that i want to import
the code is fairly simple and basic and should work
but my sheetnames keep coming back as "_xlnm#_FilterDatabase" in the debugger
and is the ...
3
At first glance I have the same problem as many persons had before and I found many questions and answers about my problem but none of them helped me.
I perform importing from MS excel file (file ...
1
Solved
I have a simple Excel spreadsheet document (running Office 2013) that I'm using as a database using the "Microsoft Office 15.0 Access Database Engine OLE DB Provider".
I can connect to this using ...
Putter asked 27/3, 2014 at 18:7
5
Solved
We are trying to connect to a SQL Server instance used by the ACT CRM system. They have managed to lock things down so it isn't possible to connect to the SQL back-end using ODBC (there is some spe...
Ballesteros asked 17/9, 2009 at 19:35
2
Solved
I have an SQL statement that I'm executing through OleDb, the statement is something like this:
INSERT INTO mytable (name, dept) VALUES (@name, @dept);
I'm adding parameters to the OleDbCommand ...
Garlicky asked 9/3, 2010 at 8:55
3
Solved
I need to perform a complex import in a Microsoft SQL Server 2000.
Since doing it in a DTS is too complicated, I'm trying to do it with a little C# program, but I'm having problems when I need to ...
2
Solved
Let's start by getting this out of the way: I'm stuck using an MS Access DB and I can't change it.
This works fine:
using (OleDbConnection conn = ConnectionHelper.GetConnection())
{
conn.Open();...
1
Solved
I am trying to connect to an MS Access database (.mdb) through OleDb. My query is
SELECT * FROM ListQueries
which fetches me the error
SQL Execution Error.
Executed SQL Statement: SELECT *...
5
I want to know what is the fastest way to read cells in Excel.
I have an Excel file that contains 50000 rows and I wanna know how to read it fast.
I just need to read the first column and with ole...
1
Solved
I'm using OleDbDataAdapter to extract DataSet from excel file, but I have problems with SELECT statement inside
DataSet excelDataSet = new DataSet();
using (OleDbConnection con = new System.Data.O...
Dutiful asked 16/12, 2013 at 18:30
4
In my c# application I am using OLEDB connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\test.xls;Extended Properties=\"Excel 8.0;HDR=NO;ReadOnly=true;IMEX=1\"" to read Excel files....
1
I'm working on Visual Studio 2012 using an MS Access file as Database and having a bunch of trouble with this insert:
cmd.Parameters.Add(new OleDbParameter("@codigo", cal.CodEtiq)); // Value = int...
2
Solved
Good day. I am trying to make a registration page and have the information stored in a database. I made the database using Microsoft Access. I get:
Syntax error in INSERT INTO statement
every ...
0
I am trying to connect to an iHistorian Database. This database is a product of GE and it records process control information. Anyway, this database is configured with OLE DB drivers. I am curious ...
Mechling asked 26/6, 2013 at 20:42
1
Solved
I start to use OleDB. I'm trying to extract a large range of random data from an Excel file (in C#). This my query :
SELECT * FROM NAMED_RANGE
But I have a lot of empty rows. I delete them in a ...
1
Solved
I have a simple SSIS package with a data flow task with ADO.NET source & destination:
Normally, I would just select 'table or view' on the OLEDB destination, but although the connection is c...
Term asked 17/6, 2013 at 9:32
© 2022 - 2024 — McMap. All rights reserved.