oledbconnection Questions
6
Solved
I know this topic is done to death but I am at wits end.
I need to parse a csv. It's a pretty average CSV and the parsing logic has been written using OleDB by another developer who swore that it ...
Hornback asked 25/7, 2011 at 8:48
4
Solved
I have a table with "SEMESTER, SUBJECT, OFFER, RESULT" where "SEMESTER" & "SUBJECT" is PRIMARY KEY. When i use the query
"DELETE FROM Course_Information WHERE Semester = 1 AND Subject = 'CSE-4...
Lightface asked 7/8, 2013 at 19:35
4
Solved
I am using an OleDbConnection, OldDbCommand, and OleDbReader against an Access database.
I have a named query in the database which I am calling from the code.
The query works correctly when it i...
Heinous asked 20/3, 2013 at 20:41
6
I' m using a Windows Forms application to export data to excel.
Application is built both x64 and x86.
So both version of Microsoft Access Databse Engine must be installed to work the application...
Animation asked 29/2, 2016 at 14:3
3
I've been fighting with OleDbConnection for a while now trying to get it to not cache. Basically I am accessing a shared Access database, which is being written to from another application, and the...
Suttles asked 28/6, 2012 at 10:45
3
I am getting error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." on my testing servers. So My Question is :
i) Can i add reference for "'Microsoft.ACE.Oledb.12....
Arbil asked 22/8, 2013 at 12:26
2
Solved
i trying to run query using C#, i am getting the following problem
An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;
my code
string strCon...
Columbus asked 21/4, 2014 at 7:29
2
Solved
I am using visual studio community 2017
Access 2010 - 2016
I can import an access file I created
File sent from client contains(tables, queries, forms, macros, and modules)
Provider=Microsoft.ACE....
Hickerson asked 10/11, 2017 at 18:43
1
Which one is more efficient than others in Python. My requirement is to have one connection until we close the application.
I have two classes one is to make and get connection/cursor and using w...
Wiesbaden asked 16/9, 2017 at 11:27
4
Solved
In my current project, the database name keeps changing and I do not want to modify my OLE DB Sources each time. Thus I want to set it as a variable. That is, in each OLE DB Source, I could use it ...
Jazzy asked 8/5, 2012 at 21:41
4
Solved
I am using an OleDbConnection to query an Excel 2007 Spreadsheet. I want force the OleDbDataReader to use only string as the column datatype.
The system is looking at the first 8 rows of data and i...
Overleap asked 2/4, 2010 at 16:4
3
Solved
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...
Porett asked 9/12, 2014 at 15:45
1
Solved
I currently have a handler which takes the filepath and tabname for an excel file, processes the file into a datatable and then serializes the table into a json string to return.
This is working un...
Sympetalous asked 20/11, 2015 at 20:42
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
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
2
Solved
I have a package that I developed in VS2012 (using the SQL Data Tools component) which collects data from a DBF file using the VFPOLEDB provider, and puts it into a database on a SQL Server 2012 X6...
Clerihew asked 4/2, 2015 at 1:26
2
I have a try-catch for oledbconnection like this:
try
{
OleDbConnection Connection;
using (Connection = new OleDbConnection("Provider=MSDAORA.1;Data Source=DATABASE:1521/orcl//orcl1;Persist Secu...
Julieannjulien asked 29/7, 2015 at 6:38
3
Solved
I have developed a c# application which connects to many types of database servers like Sql,Oracle,Mysql etc..Connection was established using ODBC.
I need to find the server type (DBMS type) for ...
Mcwherter asked 20/5, 2015 at 7:41
4
Solved
I am getting an error while inserting data into a database.
The error is:
"Number of query values and destination fields are not the same".
Insert code:
OleDbConnection vconn = new OleDbConn...
Prevision asked 8/11, 2011 at 5:15
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
4
Solved
I want to make a simple application for an exercise, so it could be nice to connect to a simple database like Access (.accdb)
My program looks like this:
using System;
using System.Collections.Ge...
Kos asked 28/11, 2011 at 21:10
2
Solved
I have to work with a Project made by another developer. A project Win-Form with Visual-Basic code, with MS-Access as db and some OleDbConnections. There is a bug: sometimes the application can't o...
Excitability asked 15/6, 2011 at 17:44
1
Solved
I have a DBF file which I am trying to import and then write that to a SQL table. The issue I am running into is if I use SqlBulkCopy, it requires me to create the table in advance but that is not ...
Mozellamozelle asked 4/6, 2014 at 20:10
5
I have one problem. I need to get the excel sheet name in a work book, which looks on the very left sheets tab -the first one from my point of view.
I am using this code:
public static string Get...
Lonilonier asked 20/8, 2009 at 14:39
0
I am reading a excel file using OLEDBConnection.
I can import xls, xlsx, and xlsm.
I have just a little problem with to read a merged cell.
For example, i have cell A2, A3 and A4 which is merged. B...
Mongrel asked 29/7, 2013 at 14:41
1 Next >
© 2022 - 2024 — McMap. All rights reserved.