oledbconnection Questions
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
There's a similar question here In Memory OleDbConnection to Excel File but, this question was answered by avoiding it completely by doing it another way.
Here's some example code which uses an Ol...
Singles asked 2/2, 2012 at 13:34
4
Solved
I am reading the contents of an excel sheet in my application using:
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=E...
Saari asked 8/9, 2010 at 22:55
5
Possible Duplicate:
Is there any need to close a DbConnection if a using clause is used?
Does OledbConnection.Dispose() close the connection?
I am aware that SqlConnection does but w...
Soneson asked 20/8, 2012 at 8:10
1
Can anyone tell me OleDB Connection string to be used for just reading an Excel file exclusively opened by other user?
I tried following connection string which did not work for me:-
"Provider=Mi...
Chessboard asked 2/5, 2011 at 5:38
2
Solved
I'm using OleDB and I want to export my objects into excel table. Each row in the sheet will be one of my objects. The problem is that I don't know how to insert data when there's no column headers...
Veinlet asked 19/4, 2012 at 7:51
1
This code does not save any data in the dbf file. What is wrong here? Here is the code with the recommended changes. Thank you.
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data So...
Igloo asked 10/3, 2012 at 0:54
2
Solved
What is the difference between the SQL Connection and OLEDB Connection? Is that OLEDB is common to all (also SQL Server)? To which are all Servers, OLEDB is using?
Farnsworth asked 20/8, 2011 at 7:6
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 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
1
Solved
The problem i'm having is that the data adapter is looking at only the first row in each column to determine the data type. In my case the first column "SKU" is numbers for the first 500 rows then ...
Publican asked 29/12, 2010 at 3:12
3
Solved
First, I want to say that I'm out on deep water here, since I'm just doing some changes to code that is written by someone else in the company, using OleDbDataAdapter to "talk" to Excel and I'm not...
Takao asked 28/9, 2010 at 22:6
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
5
In a C# application, should a OleDBConnection be created once, or every time a SQL statement is executed?
I am looking at C# code written by someone else. Every SQL statement is preceded with the ...
Santana asked 11/8, 2010 at 13:21
1
Solved
Apparently (MSDN) sometimes OleDbConnection.ResetState() does nothing, so even if the connection fails OleDbConnection.State will still be set to Open. I am looking for best workaround for this, so...
Rudiger asked 9/3, 2009 at 16:26
4
Solved
My project that I am working on is almost finished. I am loading a .MDB file, displaying the contents on a DataGrid and attempting to get those changes on the DataGrid and save them back into the ....
Bidet asked 5/2, 2009 at 22:19
© 2022 - 2025 — McMap. All rights reserved.