Click here to Skip to main content

Submit your article

OleDb

OleDb

Great Reads

Hadoop For .Net & AngularJS Developers

by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

Bidirectional Replication - in MySQL

by Sujith Karivelil

In Master - Slave replication, Changes in master will reflect in Slave. but any changes made in the slave Database will not reflect back in Master, this article will help you to implement Bidirectional Replication.

Arbitrary parameters in SSIS for OLE DB

by Ryszard Dżegan

How to get around restrictions for parameters in OLE DB connection type while working with SSIS and BIDS.

Refering dlls in SSIS Script Task

by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

Latest Articles

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

by rohitsies

Helps migrate your Microsoft Access database to Excel

Verify Oracle Client Installation

by WernfriedD

Single .exe to verify if your Oracle Client is properly installed and working. Verify supported technologies for Oracle connection.

Hadoop For .Net & AngularJS Developers

by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

All Articles

OleDb

I need correct inner join condition query build in order to delete records in two tables: please help

17 Oct 2016 by #realJSOP

If you set the appropriate foreign keys, you could delete from one table, and the database will delete related rows in the other table, and you then you won't have to use overly complex queries.

How do I skip first row in excel file upload

12 Apr 2019 by #realJSOP

Your select statment has to provide the range of rows/columns to retrieve, not just the starting cell. Something like SELECT * FROM [Details$A2:C3]

How Do I Update The Value Of Sql Database From Excel Spread Sheet Using Asp.Net And Oledb

17 Jul 2015 by Aakash Bashyal

My SQL Database Has field name [Name],[Roll No],[Score] . The Score Field is NULL. i want to select all the row of Excel sheet i.e [Roll No],[Score]. And after the selection i want to iterate to the loop and Check if the Roll No of the excel and Roll No in sql database is equal. if it is equal...

error in insert data

3 Mar 2014 by abdulrehman7621

plz help me in thismy data can't insertedit displaying error "syntax error in INSERT into Statement"try { OleDbConnection con; OleDbCommand com;string path = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\user\Documents\Visual...

The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine.

12 Sep 2017 by Abhimaan Sharma

I tried to all the possible solutions, but code is not working. Getting same error again and again. Infact, I've installed the same from below link: https://www.microsoft.com/en-us/download/details.aspx?id=13255 What I have tried: string ExcelContentType = "application/vnd.ms-excel"; ...

connectionstring

How Do I Update The Value Of Sql Database From Excel Spread Sheet Using Asp.Net And Oledb

17 Jul 2015 by Abhipal Singh

There is an easy way out. Instead of you comparing the DataTables row by row. Let your queries do it for you. What you can do is:1) Fetch all the roll numbers from SQL database's table having Score as NULLSELECT RollNo FROM [profile].applicant_profileWHERE Score IS NULL2) Convert the...

Read DBF file with OleDbConnection

16 Nov 2012 by Abhishek Pant

this may help you about error.-http://support.microsoft.com/kb/321003[^]

microsoft access 2007 connection string

6 Mar 2015 by abid zahid

Hello every onei am new to winforms and i am creating a project with ms access database 2007 (.accdb) the problem is i want to create connectionstring but without directory path so please help methanks

connectionstring

Issue reading .csv file regarding datatypes.

4 Feb 2013 by Adam R Harris

Forget OleDb and look at LINQ.There are a few great articles here regarding parsing CSV files with LINQ, after a quick search this is the best one i found: LINQ to CSV library[^]

Read and Write Excel Documents Using OLEDB

3 Jan 2014 by adriancs

Sample code for reading and writing Excel documents using OLEDB.

C# throwing exceptions throws another exception

5 Mar 2015 by Afzaal Ahmad Zeeshan

That is because you, yourself, personally are throwing this exception in your code when there is no record found in the database. if (obj != null) return obj.ToString();else throw new Exception("No records");This line of code is intended to do what you're seeing. It...

How to copy DataTable to Excel File using OLEDB?

2 Jun 2013 by Ahmed Noaman

I am writing a program send data to excel by using oledb. I used Update statement like next:OleDbConnection MyConnection = new OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + GeneralData.excelPath + "';Extended Properties=Excel 8.0;")MyConnection.Open();OleDbCommand...

Vb.net help me convert oledb connection to mysql connection

19 Jun 2022 by Ahmed Sadek 2022

can some one please help me convert my old project from using oledb connection MS access database to use MySQL database? the connection files are Module 1 here Imports System.Data.OleDb Imports System.Globalization Module Module1 Private...

MySQL-Connector

How to create excel file 31055.xlsx in application path

23 Jan 2017 by ahmed_sa

I work in windows form c# visual studio 2015 I have excel file xlsx and name is 3105.xlsx and i need to create it in application path .how to create excel file in application pathmy codepublic void CreateSheetIfNotExists() { using...

How to prevent adding item to excel 2007 if it found before C#

4 Feb 2017 by ahmed_sa

I work in c# 2015 windows form I have excel file 2007 name book 1 and sheet inside it name sheet 1sheet 1 have two column UserIDUserNameI need when insert new record from windows form c#to check if the value of User Name found before show to client message tell him that...

When update data in excel sheet to more columns not working why

31 Jan 2017 by ahmed_sa

I have excel sheet name Allprintingcontain to UserID,UserName,UserNameAR,Country,CountryAR,Member,MemberAR columnsI need to make update data in this excel sheet if client change any data in thesecolumns (UserID,UserName,UserNameAR,Country,CountryAR,Member,MemberAR)but bellow code...

How to create connection string to excel sheet 2007 by C#

27 Feb 2017 by ahmed_sa

I need to know are this connection string to excel is wrong or true public static string fileName = string.Format("{0}\\Book502", Directory.GetCurrentDirectory());string connection = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source={0};Mode=ReadWrite;Extended...

connectionstring

How to insert image in excel 2007 based on ID or NO ?

7 Mar 2017 by ahmed_sa

I work in windows form application c# vs 2015I can insert data in excel but image cannot insert when insert another data i using System.Data.OleDb.OleDbCommand excelCommand = new System.Data.OleDb.OleDbCommand("INSERT INTO [AllPrinting$](UserID,UserName,Country,Member) VALUES (?,?,?,?)",...

image-processing

How to make function update image to access 2007

7 Mar 2017 by ahmed_sa

I work in windows form c# working with access 2007i need to make function to update image in access where = UserIDBUT I need to know how to do function and how to call it public string updateimg(string UserID,string path) { string valuereturn = null; ...

How to get selected text for combox box in datagridview

10 Mar 2017 by ahmed_sa

I work in windows form c# vs 2015 i need to get text of selected value of combobox inside datagridview i can added success in datagridview but cannot get text for it . I replaced by column already exist his name Country and become Country2 this code of combobox Actually...

How to create ole object field in access 2007 to save image

15 Mar 2017 by ahmed_sa

I try to create field image in access 2007 as ole object to save qr imagebut I cannot create field programming by c# ?so that how to create ole object field in access 2007 create table(qrimage ?)what data type = to ole object ?qr image i need to save in this field 4kbWhat I have...

How to change the location of database file dynamically in another networkhow do I...

28 Mar 2017 by ahmed_sa

I work in windows form application works in c# visual studio 2015 connect to database access 2007my connection as bellow public static string fileName = @"\\192.168.1.30\data\accessqr.accdb"; public string connection = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data...

Error no value given for one or more required parameters.' select from excelsheet

20 Apr 2018 by ahmed_sa

When i try to get data from excel sheet i get error no value given for one or more required parameters.' why this happen . i work in visual studio 2010 with excelsheet 2013 my code in c# as following public DataTable ShowWrongExcelData() { string...

Datagridview show only last record although I have more rows when compare currentreading excel and invoice table

24 Apr 2018 by ahmed_sa

Problem Datagridview show only last record although I have more rows when currentreading excel is less than currentreading invoice table . wrong result in else statement of btn_import click inside for loop count I need to modify code in else to accept list not show only one record . Details ...

Specific cast is not valid in linq query when compare two tables

25 Apr 2018 by ahmed_sa

Problem Error display in linq query "specific cast is not valid" at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value) at System.Data.DataRowExtensions.Field[T](DataRow row, String columnName) LinqQuery give error var query1 = (from x in table1.AsEnumerable() ...

When selecting data from excel sheet and columns name alias different give error

4 Aug 2018 by ahmed_sa

Problem when selecting data from excel sheet and columns name different give error . so that i need to change my code to accept any alias to columns . example in my code column UnitCode represent 'رقم الاستماره' I need it if he write another name accept without exception as 'الاستماره' my...

It is the exception I got earlier for this query

13 Oct 2016 by Alfonso Gag.

The query is wrong. It should be something like:UPDATE InvoiceItems SET > FROM InvoiceItems, Products where >I guess you have to update the InvoiceItems table, remember you can update only a table at a time.Note: I think that also the DELETE command query...

I want OLEDB exception from this statement

13 Oct 2016 by Alfonso Gag.

The query is wrong. It should be something like:UPDATE InvoiceItems SET > FROM InvoiceItems, Products where >I guess you have to update the InvoiceItems table, remember you can update only a table at a time.Note: I think that also the DELETE command query...

Saving data in the database(Microsoft Access)

4 Feb 2013 by alfred sanz

I'm trying to make a project that has a database(Microsoft Access) I can read what's on the database using Windows forms application but I really can't understand how to save data in the database, Can anyone give me a sample project regarding OleDB? I really can't find a good guide in the google...

Oledb insert command

11 Feb 2013 by alfred sanz

OleDbConnection con = new OleDbConnection(@" provider=Microsoft.ace.Oledb.12.0; data source=\\sisc-erelim\4_Printing\VTDB\DB\VirginiTEADB2.accdb; Persist Security Info=False");private void button1_Click(object sender, EventArgs e){ try { OleDbCommand cmd = new...

oledb connection string ignoring alpha numeric values.

12 Dec 2013 by Ali_100

Provider=Microsoft.Jet.OLEDB.4...

connectionstring

How to change Label text in DataList

17 Jan 2016 by Amit Ben Zur

I want to change the Label text in my DataList. I want to check whether the product stock is 0 or not, if the stock is large from 0 to notify: Available in stock, if the stock is 0 to notify: Not available stock.My code is:int stock = 0; OleDbConnection con1 = new...

how to load data from multiple Excel sheets to multiple OLE db tables?

10 Jun 2014 by Amit Ghotikar

how to load data from multiple Excel sheets to multiple OLE db tables? but these sheets are having different structure.so can it possible or not?

How to I display each row from a single column into multiple textboxes in C# windows form from access database

9 May 2016 by AndreaFerro

if you use cmd.ExecuteReader() you have to use for each row of the query result reader.Read()reader.Read()defbx1.Text = dr.GetValue(1).ToString(); reader.Read()defbx2.Text = dr.GetValue(1).ToString();...

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

10 May 2013 by Andreas Gieriet

You may have a look at: social.msdn.microsoft.com: 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine[^].CheersAndi

C# Query Statement from Excel

17 Nov 2015 by anil_kumar_bhakta

Dear All,I am developing such a database application which extract data from excel and save it to SQL Database.My program is working fine at production server. But when it runs from client's PC it fails. Suppose I have a file "C:\test.xlsx". It works on Server but not working on client...

Not able to open DB connection to MS ACCESS DB from Microsoft visual C++ 6.0

7 Aug 2016 by Aravindba

Better give read and write permission for everyone to db folder,and provide full details of error that u face.Regards AravindB

Read all excel in a folder using oledbconnction C#

10 Jul 2020 by arunavachowdhury

1-I am having a strange problem. Requirement: read a list of excel files on a folder and store the content on a dataset. What I have written: **Button click:** protected void btnUploadExcelFiles_Click(object sender, EventArgs e) { ...

Adding records to Access Database in VB.NET

21 Feb 2014 by asjadathick

Hi,I have created a program to add a record to a database (to the table "Orders"). I have added an OleDB database using Visual Studio's connection wizard. The database was originally created in Microsoft Access before adding it to Visual Studio.This is the code I have used.The...

Getting ado.net query's sql injection free

5 Apr 2013 by AspDotNetDev

You can use SQL Profiler (a tool you run to see all queries executed against a database) to see the literal query and values. Though, you will find that the query may even be sent to the server parameterized, followed by some statements that pass in the values of the parameters.Yes, all...

How will my Upload Excel file display the actual data ..

19 Jun 2014 by author.ius

Okay here is my running code, I uploaded a .xlsx file,Sub UploadAndDisplayExcel() Dim FileName As String = Path.GetFileName(fu_bst.PostedFile.FileName) Dim Extension As String = Path.GetExtension(fu_bst.PostedFile.FileName) Dim FilePath As String = Server.MapPath(FolderPath +...

The connection for viewing your linked Microsoft Excel worksheet was lost

13 Apr 2015 by barneyman

Excel doesn't support[^] multi-user concurrency - which isn't surprising, it's not a Database :)

How Do I Connect Oledb Database From Com ?

24 Jul 2015 by barneyman

you'll need to use an ADODB recordset with an ADODB connectionoledb.oledbconnection is .net

How Can I Update A Record

24 Feb 2015 by Bass Alfan

Hello guys,i just want to update only one record in a table without using where statementi think i can do that by call recordsetthis my code: Dim cs As String = ("Provider=Microsoft.ace.OLEDB.12.0; Data Source=" & Application.StartupPath & "\vbdata.accdb") con = New...

External table is not in the expected format.

30 Jan 2013 by bbirajdar

You need OLEDB 12 drivers installed on your machine.Install from this linkhttp://www.microsoft.com/en-us/download/details.aspx?id=13255[^]And the code will be like this .string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFileName + ";Extended...

Hadoop For .Net & AngularJS Developers

29 Dec 2015 by Bert O Neill

Query Hadoop using Microsoft oriented technologies (C#, SSIS, SQL Server, Excel etc.)

.NET-Compiler-Platform

Error "No value given for required parameter"

23 Jan 2016 by Bikram Chhetri

When you receive this error it means that the Access Engine is unable to find find one or more of your columns names or the whole table name correctly.So make sure that the column name you have given is same as table column name. Is this really a column name MStaus?

Can not convert type object to type long

27 Dec 2017 by BillWoodruff

To exclude the possibility that you are getting an object that can't be converted to a long, test with another function that uses Int64.TryGetValue, and break on error to examine the data. I would rather use hard-coded Type specific conversion methods, which throw useful errors. Use of...

How do I delete attributes using join condition in SQL and add to oledb command

16 Oct 2016 by BrishPandey

You can use sub query that will return the list of id that satisfy the condition of your join. and in where clause of delete you should use 'in' keyword for filtering

Updating an Excel File using a Textbox

18 Jun 2013 by CAS1224

Right now I'm able to pull in data from a single cell in an excel file using the oledataadapter and a textbox. However when I change the data using the textbox the changes don't save to the excel file. Here is my code below, if anyone can figure out how I might save the changes made from the...

How to retrieve bitmap image from excel using oledbadapter in vb.net

6 Aug 2013 by CAS1224

Hello right now I have a program that uses the oledpadapter to retrieve information from an excel file and displays the data into a datagridview. I'm hoping to find a way to retrieve a bitmap image from my excel file and display it into my datagridview. Is there an easy way of doing this? I...

Is there a way to exclude blank excel cells on import using oledbadapter in a datagridview?

7 Aug 2013 by CAS1224

Hi, I'm hoping to find a way to exclude blank excel cells when I import my spreadsheet using the oledbadapter. I know it must be something like "If datagridview1.columns() = dbnull then don't include them. Here is my code below. Maybe something along the lines of this will work. It still...

How to hide datagridview rows that contain null values in vb.net

15 Jun 2017 by CAS1224

Hi I'm hoping to find a way to hide certain rows of my datagridview if they contain nothing or null. My datagridview is bound to a datasource that is an excel worksheet. I'm hoping on import that I can hide the rows that are empty and display only those that contain values. I'm thiking something...

Try catch if selected excel file is blank

14 Aug 2013 by CAS1224

Hello I have a program that imports an excel file using the oledb in vb.net. This program imports the excel spreadsheet into a datagridview. On opening the program will ask the user to choose an excel file to open, however if the user inputs nothing or presses the cancel button the program will...

How to refresh/update datagridview windows form

17 Aug 2013 by CAS1224

I'm having trouble finding a solution for refreshing my datagridview. My goal is to have a refresh button that will automatically update the database(excel worksheet) after making a change and pressing the refresh button. The way my program responds: I make a change to the datagridview and press...

How to refresh/update dataset in vb.net for windows forms

22 Aug 2013 by CAS1224

Hello I seem to be having an issue. I have a dataset (excel) sourced to a datagridview in a windows forms application. I'm hoping to find a way to refresh/update my dataset within the datagridview after making a change to a cell. Let me go through the steps I've taken to try and accomplish this....

Updating a dataset and displaying it back to datagridview

23 Aug 2013 by CAS1224

I found a way on MDSN to update a dataset and display it back to the datagridview. Almost like refreshing the datagridview. However I'm hoping to find a way to do this with an oledpdataadapter. Here is the code I found below to fill the datagridview with the updated contents, there has to be a...

How to delete all empty rows from a excel sheet using OLEDB in C# Application

22 Aug 2014 by CB Sharma

HelloWorking with MS Excel(xls / xlsx) Using MDAC and Oledb[^]Good Luck

Fail connection to csvfile in C# - Oledb adapter

5 Sep 2014 by CB Sharma

Hello follow the below linkhttp://www.connectionstrings.com/textfile/[^]http://stackoverflow.com/questions/6813607/parsing-csv-using-oledb-using-c-sharp[^]

I have an error! Please help me! The Microsoft Access database engine could not find the object 'asasas'. Make sure the object exists and that you spell its name and the path name correctly.

4 Sep 2012 by cell-in

I want to export my data in .csv file to dataGridView in C#. After this line: oda.SelectCommand.ExecuteNonQuery();I have an error:The Microsoft Access database engine could not find the object 'asasas'. Make sure the object exists and that you spell its name and the path name...

I have an error! Please help me! The Microsoft Access database engine could not find the object 'asasas'. Make sure the object exists and that you spell its name and the path name correctly.

4 Sep 2012 by cell-in

I solved my problem. The problem is about my file name.My file name include a lot of "." character. When i choose the file, i change the file name.fileName.Replace(".", "_")

How work with class that generated by ATL OLE DB wizard?

11 Oct 2012 by chaau

I have a Notes table with the structure CREATE TABLE Notes (ProviderNo CHAR(9), Note CHAR(29))The wizard has created an Accessor class and probably an additional class that is derived from the accessor class. So you should have something like this.class...

How insert, get, update and delete data by generated class of ATL OLE DB Consumer Wizard?

17 Oct 2012 by chaau

you need to initialise the variable for m_ProductId with the status, like this:class CProduct:{public: int m_ProductId; DBSTATUS m_IdStatus; //.. your other columns, like m_Price, m_Quantity, etc BEGIN_COLUMN_MAP(CProduct) COLUMN_ENTRY_STATUS(1, m_ProductId,...

How insert, get, update and delete data by generated class of ATL OLE DB Consumer Wizard?

18 Oct 2012 by chaau

use this function to retrieve the errors (pass the HRESULT returned after you called Insert() method) and post it here:CString GetDatabaseError( HRESULT hrErr ){ CDBErrorInfo ErrorInfo; ULONG cRecords; HRESULT hr; ULONG i; CComBSTR bstrDesc,...

Create table using OLE DB Destination in SSIS package

3 Dec 2014 by Chandra Mohan N

Refer this linkshttps://www.simple-talk.com/sql/ssis/ssis-basics-using-the-merge-join-transformation/[^]http://msdn.microsoft.com/en-IN/library/ms141237(v=sql.105).aspx[^]

How do I load a combo box with data from one column in an access database?

27 Apr 2016 by chants

I have very little experience with programming but I have to create a windows form application with multiple forms. On one of the forms I need to make use of information from an access database. I have an access database with two tables. One table is called Student.The student table...

dbf file insertion Take a long Time

18 Mar 2013 by CHill60

Try changing the way you are setting up your command to use prepared sqlsee http://msdn.microsoft.com/en-GB/library/system.data.oledb.oledbcommand.prepare.aspx[^]Apart from making things more performant using (fully) parameterised queries will also help protect against sql...

Please help me to solve oracle database error

23 Jul 2013 by CHill60

I don't think that OLEDb supports named parameters in the command ... try the following instead (warning - my syntax might not be perfect)string s = "insert into test3(NAME) values(?)";OleDbParameter pNamVal = New OleDbParameter("@nam", OleDbType.Varchar2, 20) pNamVal.Value = country

ADO VBNET update / addnew question

6 Mar 2019 by CHill60

I'm with the others who are suggesting biting that bullet and updating to ADO.NET - especially as you are already spending ages trying to overcome the problems caused by using out-of-date technology. However, try the following to see if it gets you over your hump.. 1. I'm pretty sure it's the...

Msaccess database OLEDB connection with username and password - problem c#.net

7 Jul 2022 by CHill60

Have a look at the resulting connection string - which should look like this Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Mybase.mdb;Jet OLEDB:System Database=C:\MySysBase.mdw;User ID=Admin;Password=*; I.e. without the "Jet OLEDB:" bit on the...

Sql string in an access database

11 Jan 2023 by CHill60

There are several issues with your code, the connection string does not seem to be one of them. 1. You are opening a connection to your database and attempting execute some SQL - but you have not defined where the results should go 2. You are...

C# 2008 with MS Access Using OleDb Jet.4.0

6 Mar 2013 by Chiranthaka Sampath

When I am truing to insert data to MS Access Database Table using oledb 4.0 I found an errorThe statementprivate void btnPrint_Click(object sender, EventArgs e) { //Creating the Patient ID. intYear = DateTime.Now.Month; strYear =...

MS Access INSERT INTO Statement.

7 Mar 2013 by Chiranthaka Sampath

There is an error at the following statement stating that "Syntax error at INSERT INTO statement". The code is at the below. OleDbComm.CommandText = @"INSERT INTO Full_Blood_Count ([PatID],[PatName],[PatAge],[PatAddress], ...

How to import specific cells of an Excel file into datagridview using c#

18 Apr 2013 by Clifford Nelson

I would consider Excel Interopt: http://www.dotnetperls.com/excel[^]

C# oledbconnection external table is not in the expected format where XLSX contains image

25 Jun 2018 by coolNish

I have an excel file where it contains an image in the header, I don't care about that image even if it has to be removed. I get the following error message while making the connection to the file which contains the image. conn.Open(); **External table is not in the expected format** ...

Sysntax Error in Query Expression

10 Jan 2013 by CPallini

Shouldn't beFirstname LIKE '% Hello %'?

Facing error Microsoft.ACE.OLEDB.12.0 provider is not register on local machine

15 Oct 2015 by CPallini

Here some info: "Solved - The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"[^].It looks you have to somehow install it on the local machine.

microsoft access 2007 connection string

6 Mar 2015 by DamithSL

check below article Social Club: Sample application using WinForms, C#.NET, ADO.NET and MS Access[^]

connectionstring

Updating a dataset and displaying it back to datagridview

24 Aug 2013 by Dave Kreskowiak

That code does not update a DGV. It updates a DataTable, which you then have to bind to a DGV.You can find an example of using the OleDataAdapter here[^].

how to solve Syntax error (missing operator) in query expression '(Username ='aa') = (Password'aa')'.

14 Mar 2015 by Dave Kreskowiak

Because you're not using parameterized queries your result SQL statement looks like this:select count(*) from [LoginDB] where (Username ='username') = (Password'password')See anything wrong with that statement?Because of the string concatenation stuff you're not seeing the problem in...

OleDB da.Fill Command gives Type Mismatch error

18 Jan 2016 by Dave Kreskowiak

On top of what Mycroft said, Google for "C# parameterized queries" and start reading. Using string concatenation to build your SQL queries like this opens your code up to SQL Injection Attacks and the possible destruction of your database.

The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine.

12 Sep 2017 by Dave Kreskowiak

Did you install these[^]? If your app is compiled targeting x64, you have to use the 64-bit version of the runtime. If your app is compiled targeting x86, you have to use the 32-bit version. If your app is compiled targeting AnyCPU, it depends on which O/S your app is running on: 32-bit...

connectionstring

Connecting VB form application to accses database, 3 out of 4 times it works what am I doing wrong?

19 Sep 2017 by Dave Kreskowiak

Another problem I see. You're repeating the same code over and over again. This is Clue #1 (tm) that you need to put that kind of code in it's own method and call it from where you need it.

DBF SQL standard to escape column names?

4 Nov 2023 by Dave Kreskowiak

Just to reinforce the point that may have been missing, that is some horrifyingly bad code. It's near impossible for a newb to debug, isn't supportable n any environment, and would give code and security reviewers heart attacks. Google for "Sql...

Data type mismatch in criteria expression when using parameters in VB.NET

29 May 2016 by Devil7DK

I need to insert some strings, binary data and integers into database. Some of those strings contains the constants like ' (apostrophe). So i thought i can insert those using parameters. When using the code below i had "Data Type Mismatch in Criteria Expression" Error. Function...

Error on storing strings using parameters into oledb in VB.NET

30 May 2016 by Devil7DK

I have an patient report database, some of their values have database query constants like ' or " so i tried to insert these values using parameters. input was in English but when trying to retrieve the stored value it was returning a value of some kind of binary. the link for pictures and...

Importing data using Excel sheet not working in Server

18 Jan 2014 by Deviprasad Das

For reading the excel using Oledb you do not require Microsoft Excel to be installed.Instead of using DataReaderOleDbDataReader odr = ocmd.ExecuteReader();try using Datatable and check if data are getting filled in DataTable or not?

How to read a .csv file using oledb reader when name of the file is too long ?

27 May 2014 by dielkristen

oleDbConnectionStringBuilder sbConnection = new OleDbConnectionStringBuilder();sbConnection.DataSource = System.IO.Path.GetDirectoryName(txt_selectDirectory.Text);sbConnection.Provider = "Microsoft.ACE.OLEDB.12.0";String strExtendedProperties = String.Empty;strExtendedProperties =...

Msaccess database OLEDB connection with username and password - problem c#.net

7 Jul 2022 by DimA__B2

Hello everyone, I have a problem and i need your support. I need C#.net software and need connection MSAccess 2003 database "mdb" with security from "file working group"(mdw). my code is: OleDbConnectionStringBuilder csbOLE = new...

Oracle DB EDMX: Upgrade ASP.NET Project and Entity Framework to use Oracle.ManagedDataAccess.Client

14 Jun 2020 by DiponRoy

Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.

entity-framework

How to create connection string to excel sheet 2007 by C#

27 Feb 2017 by Divya-Systematix

Hello,You can refer this link, i think it's helpful for you.How to Read Microsoft Excel 2007 Using a Connection String in C#[^

connectionstring

How do I write an OLEDB driver?

30 May 2021 by Donny Hardo

A lot of people still use Visual Foxpro, even though Microsoft stopped supporting it years ago. You can download the legacy oledb driver (VFPOLEDB) but it is only 32 bit. There are lots of well documented troubles of people struggling to use it...

Importing data using Excel sheet not working in Server

18 Jan 2014 by Dusara Maulik

Please refer below link(s):Import MS Excel data to SQL Server table using C#[^]http://stackoverflow.com/questions/18006318/how-to-import-all-the-excel-sheets-to-dataset-in-c-sharp[^]

How to export data table to excel in C# using oledb?

11 Jul 2016 by Ema112

How to export data table to excel in c# using Oledb?I want to transfer data in data table to excel in c# using Oledb provider. I am able to insert few cells using below code:try { string filelocation = @"E:\Alex\Arab_Test_Oledb.xls"; ...

ADO VBNET update / addnew question

6 Mar 2019 by eramm01

I am migrating a VBNet programme from DAO to ADO. The database is an *.mdb database. In DAO I performed the following: Opened the database, created a recordset by using an SQL select command. I then could update using a recordset.edit/.update or a .addnew command. In ADO I do the folloing:...

Not able to insert value into a column in a .dbf file

24 Mar 2017 by erick manuel

BackGroundI am currently working on a project which will need me to create a local .dbf file which I must then populate with a value. I am currently able to create a .dbf file in a test dir and add a column to it, however when I try to add a value to that column it is not allowing me to do...

Not able to insert value into a column in a .dbf file

24 Mar 2017 by erick manuel

The error was purely syntax, and I was guided by a really good example which I found in the following linkhttps://social.msdn.microsoft.com/Forums/en-US/24eac4c5-3a4d-43f4-8607-ef684919c4af/command-contains-unrecognized-phrasekeyword-vbnet?forum=visualfoxprogeneralpublic static bool...

Error Reading Excel through OLEDB connection

11 Nov 2012 by Eser Atesoglu

I am reading an excel spreadsheet in C# using OleDb connection. I get an error (See below) if any of the column headers in the excel is "Domain".The error message is (raw)System.Data.OleDb.OleDbException (0x80004005): IErrorInfo.GetDescription failed with E_FAIL(0x80004005). at...

Error Reading Excel through OLEDB connection

12 Nov 2012 by Eser Atesoglu

Thanks Milind. Your solution solved the issue.

Saving data in the database(Microsoft Access)

4 Feb 2013 by Espen Harlinn

There really are no good reasons to use access anymore, as you can download Download SQL Server 2012 Express with SP1[^].Access was kind of nice about 20 years ago - when you had to part with some serious money to get a serious database server.And there are many, many articles here on...