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

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...

DBF SQL standard to escape column names?

4 Nov 2023 by ramderf.0326

SQLInsertCommand = "INSERT INTO " & strFileName2 & "_ (TRANDATE,[HOUR],SALES,TRANCNT,TENTNAME,TERMNUM) " & _ " VALUES('" & Format(CDate(dr("dateid")), "Short Date").ToString & _ "','" & "" & dr("dhour") & "'," & _ Format(dr("amt"),...

DBF SQL standard to escape column names?

1 Nov 2023 by M Imran Ansari

The error message is clear that tha column name 'HOUR' is not being recognized in the table or not spelled correctly, you are trying to insert data into. The INSERT INTO statement contains the following unknown field name: 'HOUR'. Make sure you...

How to search A DataTable in c#

22 Mar 2023 by Member 9430088

When i execute this nothing happens the datagridview does not update public void Search() { OleDbCommand ocm = new OleDbCommand("SELECT Firstname FROM students WHERE Firstname LIKE '% Hello %' ", conn); conn.Open(); ocm.ExecuteNonQuery(); conn.Close(); }

How to search A DataTable in c#

22 Mar 2023 by hisham elmsry

LINQ-To-DataSet (which i prefer): var filtered = tb.AsEnumerable() .Where(r => r.Field("CREATOR").Contains(searchstring)); ADO.NET(DataTable.Select): DataRow[] filteredRows = tb.Select("CREATOR LIKE '%" + searchstring + "%'");...

Sql string in an access database

11 Jan 2023 by John Ertle Jr

This is not executing the SQL String: conn.execute "SELECT * FROM VSOP87-0; I have the Table in "VSOP87-J2000.accdb" called "VSOP87-0". How do I write the correct SQL string for this configuration. Dim conn As Object Dim rs As Object...

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...

Sql string in an access database

10 Jan 2023 by Sandeep Mewara

You can refer the following to know the correct format of connection string: Connection String[^]! For Access DB, following is the format: Standard security Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Persist...

I got error on cmd.executenonquery()

25 Nov 2022 by MikelDavao

i have code in vb.net (visual Studio 2015 + AccessDatabaseEngine.exe) Dim xSQL As New System.Text.StringBuilder xSQL.AppendLine("INSERT INTO tblR") xSQL.AppendLine("(dbIc, ") xSQL.AppendLine("dbTn, ") ...

I got error on cmd.executenonquery()

25 Nov 2022 by Richard MacCutchan

You did not close the field names set properly, and you forgot to add the VALUES clause to your insert statement. The final statement that you send to access should look like: INSERT INTO tblR (dbIc, dbTn, dbQ, dbD, dbU, dbP, dbA) VALUES (?, ?,...

Openfiledialog() problem with oledbconnection() not clearing

6 Oct 2022 by Paramu1973

Iam using VS2015. WinForms. First time when I execute, Once I click() the Form opens and simply it's working good. When I re-click() the button OpenFileDialog appears and it's get disappear immediately and the form get closed. Since I assumed...

Openfiledialog() problem with oledbconnection() not clearing

6 Oct 2022 by OriginalGriff

It's probably unrelated to the OleDbConnection itself, but we can't tell - none of that code would cause your form to close. And we can't test it, because we have no access to your sytem, data, or other code in your app. So, it's going to be up...

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...

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...

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

Vb.net help me convert oledb connection to mysql connection

19 Jun 2022 by OriginalGriff

Basically, you've been lucky up to now - that's some very dangerous code you have there. Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire...

MySQL-Connector

Sql server oledb irowsetfastload .NET

19 May 2022 by PIEBALDconsult

The stupid widget keeps messing with the capitalization! SQL Server OleDb IRowsetFastLoad .net I am working on developing a simple ETL tool. Performance isn't really very important overall, but at the moment I'm testing it with a large CSV file...

Error: 3706 . Provider cannot be found. It may not be properly installed.

26 Apr 2022 by semicolonerror

I have recently upgraded my excel from 2007 to 2019. I was using this "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ExcelPath & ";Extended Properties=""Excel 12.0 Xml;HDR=Yes;"";" as a connection string. It was working fine before. Now,...

connectionstring

Error: 3706 . Provider cannot be found. It may not be properly installed.

26 Apr 2022 by OriginalGriff

Simple: one machine has both Excel engines installed, the other only has the latest version. Chances are you uninstalled 2007 before you installed 2019. Your connection string should be in a configuration file anyway, so it is set per machine...

connectionstring

How to add a text file into dtatatable column as first column

8 Dec 2021 by Manidas Payyoli

Hi, I have a data table having multiple column which is coming from DB.Now I need to add one column from a text file as the first column.Below format is my text file ID ---- val1 val3 val5 below is my table creation code and...

How to add a text file into dtatatable column as first column

8 Dec 2021 by OriginalGriff

Try this: string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("MyDatabase"); using (SqlConnection con = new SqlConnection(strConnect)) { try { ...

Adapter.update(dataset) does not alter data base, VB.NET

25 Oct 2021 by Member 14168791

Using an ms-access-2007 database and trying to edit a certain row/column without success. I can add new rows to the same data base with code without problems. Trying to reduce my original code to a simplest possible test-code and running it shows...

How do I retrieve a autonumber value from a ms-access database table

24 Aug 2021 by Kaise karen?

I want to retrieve an auto number value from the ms-access database table from column name "id" using c# is asp.net and then I want to convert that auto number value to "ToInt64" as a string value. I have tried this but these queries are not...

How do I retrieve a autonumber value from a ms-access database table

24 Aug 2021 by OriginalGriff

And autonumber column is the same as any other column, except you can't write to it yourself. So a normal SELECT will retrieve it. If you are trying to INSERT a new row and then get the number that was assigned, then SELECT @@Identity...

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

17 Aug 2021 by sameer_dev

My code is work fine on local server when i upload on server then error message is shown : " The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. " while i have upload a .xlsx file. kindly give me solution... What I...

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

17 Aug 2021 by OriginalGriff

The error is pretty explicit and self explanatory: the ACE 12.0 database engine is not installed on the web server. Start here: Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^]

Trying to make a oledbcommand query from a table named group

18 Jul 2021 by Member 14176647

Really dump question here so I am really sorry in advance. I'm trying to get the data from an mdb file with multiple tables. The data I want are inside a table named Group. When I try to query using: OleDbCommand myAccessCommand = new...

Trying to make a oledbcommand query from a table named group

18 Jul 2021 by Member 14176647

Never mind. The solution is to put the name inside square brackets like this: SELECT * FROM [Group]

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...

How do I write an OLEDB driver?

30 May 2021 by KarstenK

Your starting point should be OLE DB Providers Overview from Microsoft. But I think that your efforts to "ride a dead horse" arent the best investment of time and money. Consider changing the data connection of VFP to the database. My best guess...

Ho to solve syntax error in insert into statment when I try to insert data in database in ASP.NET

16 Apr 2021 by Member 15148158

I am trying to insert a data using oledbCommand in my database in asp.net.I am taking the input through textboxes and inserting them using the insert statement.The insert code is writtern on button click event.But when i click on the button its...

Ho to solve syntax error in insert into statment when I try to insert data in database in ASP.NET

16 Apr 2021 by OriginalGriff

To explain what Patrice is saying: Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead. When...

Ho to solve syntax error in insert into statment when I try to insert data in database in ASP.NET

16 Apr 2021 by Patrice T

Quote: Ho to solve syntax error in insert into statment when I try to insert data in database in ASP.NET This is SQL injection, we can help you because the syntax of your INSERT depend on the values of textboxes which we don't know. Never build...

How do I solve the error no given value for one or required parameter at oledbreader in ASP.NET

12 Apr 2021 by Member 15148158

I have a webpage called blogwebsite and in that I have a textbox and search button. I am passing the value of textbox on button click to another webform called blogseacrh through session. I also have a database bound through these webforms. In...

How do I solve the error no given value for one or required parameter at oledbreader in ASP.NET

12 Apr 2021 by Richard MacCutchan

txt2_bnm.Text = Session["name"].ToString(); cmd = new OleDbCommand("select user from tbl_blogs where book_name='" + txt2_bnm.text + "',con); ` The spelling of text is incorrect, it should be Text with a leading capital.

How do I solve the error no given value for one or required parameter at oledbreader in ASP.NET

12 Apr 2021 by Patrice T

Compare those 2 lines cmd = new OleDbCommand("select user from tbl_blogs where book_name='" + txt2_bnm.text + "' ,con); ` // here is missing a double quote ^ ... ...

How to apply template on excel file exported using oledb ?

23 Mar 2021 by Rash24Agg

Hi, I have exported data into excel file using oledb since I cannot use interop or any third party library. Here is my code : ''' ''' Export datagridview's data contained in an datatable to excel file ''' '''

Multiple-step OLE DB operation generated errors

16 Mar 2021 by Member 15102758

hello, i getthis error Multiple-step OLE DB operation generated errors when i use distinct or group by in my query. i dont know how to risolve. i tride to chenge connection string but nothing here is my code ( i am using VS 2019 - mfc c++) ...

Failed to load database information error in crystal reports viewer

23 Aug 2020 by shivanand3291

Hi, I am currently working with visual studio 2010 and MS access DB. i ahve installed crystal reports 2008. I use windows forms and a crystal reports viewer control in it. On a button click i want to show a report from database in a crystal reports viewer. But i encounter the following...

Failed to load database information error in crystal reports viewer

23 Aug 2020 by Member 14851467

I once encountered this error on my Windows 7 machine and it was resolved after I installed .Net Framework 4.5 on the machine.

How to retrieve data from ms access 365 in VB.NET

4 Aug 2020 by yash1507

Hi, I have created a windows form application in which am displaying data in datagridview from ms access 365 in vb.net using oledb connection. Please suggest me code in vb.net to get data from ms access 365. Thanks & Regards, Saurav Sinha ...

How to retrieve data from ms access 365 in VB.NET

4 Aug 2020 by OriginalGriff

Start by checking your message box: what does it say? If that isn't helpful, use the debugger to check the InnerException property whiuch may have more info. If that isn't helpful wither, check you have the right redistributable engine...

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) { ...

Vb.net mysql.data vs. System.data

7 Jul 2020 by evry1falls

I'm beginning a new project in Visual Studio 2015, .Net FrameWork 4.8, Win10 32bit, WinForm. I used to use System.Data.OleDB to work with Microsoft Access Database (mdb and accdb) and it was gr8 also when using Crystal Reports. Now, I'm supposed...

Vb.net mysql.data vs. System.data

7 Jul 2020 by Garth J Lancaster

You could start following this MySQL Connection In Windows Application Using VB.NET[^] with references to MySQL :: MySQL Connector/NET Developer Guide :: 4.1 Creating a Connector/NET Connection String[^] As for Quote: What is the best practice...

External table is not in the expected format.

29 Jun 2020 by sagarjainhr

I am having the code as follows in vb.netDim connectionString As String =[String].Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", filepath) Using oleDbConn As New OleDbConnection(connectionString) ...

External table is not in the expected format.

29 Jun 2020 by Member 14876352

You may have more than one excel/database sheet open in the background.... so make sure you have the right sheet open/closed. I closed all sheet the reconnected to database.

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

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

1 Jun 2020 by rohitsies

Helps migrate your Microsoft Access database to Excel

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

8 Apr 2020 by Member 14796688

Dear sir/Madam I had tried to execute the app many times but still not work it shows the message the syntax error (missing operator) please help me how to resolve this problem Thanks very much!! private void btnSave_Click(object sender,...

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

8 Apr 2020 by Member 10632254

hey guys, i'm new to programming and i have started a Loging system using access database but im getting syntex error. i searched a lot in internet but not getting how to solve plz help... my code is using System;using System.Collections.Generic;using System.ComponentModel;using...

How do I connect to an access database whereby the path requires password

5 Jan 2020 by Member 10271543

Hi, I need to store my database on a NAS drive and the shared volume requires a username and password. I am not in charge of the storage drive so I cannot change it. Is there a way to add the username and password in the connection string in c#. thanks What I have tried: I tried placing the...

How do I connect to an access database whereby the path requires password

5 Jan 2020 by OriginalGriff

No, you can't add a set of credentials to a file path - which is what you'd need to connect to the share and specify the path in an DB connection string. You can do this: Connect to a UNC Path with Credentials[^] - but I'd go with establishing a mapped drive letter to the share in Windows, and...

How to update whole datatable with for loop in C#

11 Dec 2019 by F-ES Sitecore

Try; OleDbCommand1.Parameters.Clear(); OleDbCommand1.Parameters.AddWithValue("@pivot", pivotValueString); OleDbCommand1.Parameters.AddWithValue("@id", int.Parse(dt.Rows[i]["ID"].ToString()));

How to update whole datatable with for loop in C#

11 Dec 2019 by sepidehGandom

I want to update whole datatable in c# connected to access(oledb) using for loop, datatable is ok, connection is ok, the problem is, update just runs on first row and other rows are unchanged. here is my code: OleDbCommand1.CommandText = "UPDATE data Set [pivot] =@pivot WHERE [ID] = @id"; ...

How to select next rows from database in C#?

28 Nov 2019 by Prachi92

I want to select rows after first 10 rows, any help? What I have tried: con.Open(); String sql = "SELECT * from bills order by sr_no OFFSET 10 ROWS ONLY "; cmd = new OleDbCommand(sql, con); dr1 = cmd.ExecuteReader(CommandBehavior.CloseConnection); ...

How to select next rows from database in C#?

28 Nov 2019 by Richard Deeming

It depends on the database you're querying. For SQL Server 2012 or later: SELECT * from bills order by sr_no OFFSET 10 ROWS NB: Don't add "only" to the query. ORDER BY Clause (Transact-SQL) - SQL Server | Microsoft Docs[^]

C# print goes infinitely while printing database value on multiple pages

26 Nov 2019 by OriginalGriff

Well ... you read the same data from the DB each time that method is executed - so as long as the DB contains 30 or more items, you will print the first page, tell the system there are more pages to print, and exit. The system will then call you again to print the next page, you will read the...

C# print goes infinitely while printing database value on multiple pages

26 Nov 2019 by Prachi92

I want to print database value on multiple pages (30 values on one page). By using while(dr.Read()) loops goes infinitely and the same data is displaying on each page, How to solve it? What I have tried: private void test2_Load(object sender, EventArgs e) { itemperpage =...

Failed to load database information error in crystal reports viewer

24 Nov 2019 by KumarGautam

Add the code below code under the element in your app.config

How to fetch data from databse based on checkedlistbox items selection?

17 Nov 2019 by Richard MacCutchan

Loop through your checkboxes and for each one that is set add the appropriate part of your OLEDB statement.

How to fetch data from databse based on checkedlistbox items selection?

17 Nov 2019 by Member 13132705

I want to fetch data from MS-Access database in window form datagridview based on item selected in checkedlistbox. I am using OLEDB command to connect databse Not using SQl or Sql connection. Data in database in string format. What I have tried: Label1.Text = ""; for (int c = 0; c

External table is not in the expected format.

14 Oct 2019 by Member 14622077

i was also facing an same issue in which while reading data from an excel i was getting external table error. basically the excel file i was trying to read was code generated. code generated excel files do not have a [Program Name] property under Details tab. Due to which the driver mis...

External table is not in the expected format.

2 Oct 2019 by Yusuf.br

I tried all suggested here but none worked..and finally i found out that a particular cell was having more than 12k characters. so look out for length as well.

Vb.net getting system.data error

27 Aug 2019 by OriginalGriff

It's your connection string, according to the error message. So use the debugger and find out exactly what string the code is using and go from there.

Vb.net getting system.data error

27 Aug 2019 by Member 14145647

Hi there im having this error [^] in my app but problem seems not to be in source code since it works in another pcs. Thanks in advance. What I have tried: Checked drivers,apps etc. Something with oledb must be the problem but i cant find what im missing actually.

What is the best way to search multiple columns for same value using oledbcommand

14 Jul 2019 by Member 12674879

Hence OLE DB .NET Provider does not support named parameters, is there any better or faster way to search multiple columns? like just using single parameter? cmd = new OleDbCommand("SELECT * FROM Table1 WHERE Column1 LIKE ? OR Column2 LIKE ? OR Column3 LIKE ? OR Column4 LIKE ? OR Column5 LIKE...

What is the best way to search multiple columns for same value using oledbcommand

14 Jul 2019 by Member 12674879

using cross apply is working. // proper indentation makes for a more readable code var sql = @"SELECT * FROM Table1 CROSS APPLY ( SELECT '%'+ ? +'%' As searchParam ) As s WHERE Column1 LIKE searchParam OR Column2 LIKE searchParam OR Column3 LIKE...

What is the best way to search multiple columns for same value using oledbcommand

14 Jul 2019 by OriginalGriff

No, there is no generic "column specifier" you can use. You could do it by concatenating all the column values together and checking that: WHERE Column1 + '|' + Column2 + '|' + Column3 + '|' + Column4 + '|' + Column5 + '|' + Column6 + '|' + Column7 + '|' + Column8 + '|' + Column9 + '|' +...

How do I skip first row in excel file upload

12 Apr 2019 by Member 14183767

i have a small website where users upload excel sheet and is stored in db. the sheets uploaded have a heading in A1:D then column names and then the data. i would like to skip the heading in A1:D and start importing from there ive tried to copy what my sheet looks like: Report for March...

How do I skip first row in excel file upload

12 Apr 2019 by Gerry Schmitz

Try doing a read on the data reader before passing it to WriteToServer. If WriteToServer doesn't "reposition" (most "stream readers" don't), then bulk copy should start on the second record. OleDbDataReader dr = oledbcmd.ExecuteReader(); dr.Read(); ...

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 skip first row in excel file upload

12 Apr 2019 by Maciej Los

Try this: string myexceldataquery = "Select * FROM [Details$A2:G];";

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...

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:...

First Column not returning while reading excel sheet using oledb reader

26 Jan 2019 by sagar dindorkar

Hi,I facing problem to read excel sheet using oledb reader, first column not returning by reader and showing at last column head F14 and column has been empty. but when i open excel sheet and double click on header row border for auto adjust and auto re size save excel and again read then...

How do I select and create excel out of excel by filtering data in C#

3 Jan 2019 by Maciej Los

Quote: I am trying to filter out the data and create new excel file out of the excel files collection I have in my directory. Currently I am using OLEDB command and I am running into error data type mismatch. I would like to know if it could be done using epplus or not and if so please share the...

How do I select and create excel out of excel by filtering data in C#

3 Jan 2019 by istudent

I am trying to filter out the data and create new excel file out of the excel files collection I have in my directory. Currently I am using OLEDB command and I am running into error data type mismatch. I would like to know if it could be done using epplus or not and if so please share the code. ...

How to update a dataset with oledb VB.NET

12 Dec 2018 by Member 14087495

I'm trying to update a modified DataSet using OleDb in Vb.Net. I can get to the data and modify it, but I can't seem to be able to update the DateSet. Problem seems to be with CommandBuilder, but I can't find a solution. What I have tried: Dim i As Integer = 0 Dim strA As String = "" ...

ORA-06413: Connection not open

14 Oct 2018 by Member 14019946

I experienced the issue when i installed Oracle Workflow builder and forced it to be compatible with my Windows 10 OS. Then I started getting connection not open error. Solution: I copied the quest folder (For Toad) into my Oracle HOME folder(C:\app\user\product\11.1.0\client_1), create a...

How do I. Insert table database in oledb connection error

12 Oct 2018 by Member 14017993

provider = "provider=Microsoft.ace.OLEDB.12.0;DATA SOURCE=" datafile = "C:\Users\hp\Documents\Sports_Shop_Management_System\Sports_Shop_Management_System\Sports_Shop_Management_System11.accdb" connstring = provider & datafile myconnection.ConnectionString = connstring ...

How do I. Insert table database in oledb connection error

12 Oct 2018 by Vincent Maverick Durano

For OleDB ConnectionString, see: Microsoft OLE DB Provider for SQL Server Connection Strings - ConnectionStrings.com[^] For OleDB examples see: Parameter Queries in ASP.NET with MS Access[^]

ORA-06413: Connection not open

5 Sep 2018 by Member 13973890

Hi The reason behind that in WIndows 7 & above operating system Visual Basic installed on c:\Program Files (x86) folder, so issue with this "(" & ")". Simple Solution: 1) Go to C:\Program Files (x86) folder, find "Microsoft Visual Studio" folder then copy entire folder and paste to...

[OLE DB] system.data.oledb.oledbexception : 'syntax error in from clause.'

15 Aug 2018 by Member 13951068

Hi, I have this error text "System.Data.OleDb.OleDbException : 'Syntax error in FROM clause.'" i didn't know why that's doing this error message Please Can you help me ? Code : private void Form1_Load(object sender, EventArgs e) { using (OleDbConnection con =...

[OLE DB] system.data.oledb.oledbexception : 'syntax error in from clause.'

15 Aug 2018 by OriginalGriff

"Note" is an access keyword: Access 2007 reserved words and symbols - Access[^] - to use it as a table name it must be escaped: OleDbCommand command = new OleDbCommand("SELECT * FROM [note]", con);

[OLE DB] system.data.oledb.oledbexception : 'syntax error in from clause.'

15 Aug 2018 by F-ES Sitecore

If you use reserved words for tables you put square brackets around them to let it be known you are not referring to the reserved word but a table called that word. OleDbCommand command = new OleDbCommand("SELECT * FROM [note]", con);

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...

How do I import excel into datagridview? I have tried this follwing

28 Jul 2018 by Richard MacCutchan

See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^].

How do I import excel into datagridview? I have tried this follwing

28 Jul 2018 by Suganth Kumar

I want import Excel sheet from local drive and view in datagrid. What I have tried: public void Loadexcel() { string FileName = "PartList.xlsx"; String name = "Sheet1"; String connectionString = ""; if...

How do I import excel into datagridview? I have tried this follwing

28 Jul 2018 by RickZeeland

Maybe you can use the EPPlus library for .NET GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^]

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

25 Jun 2018 by Maciej Los

Just ignore headers. All you need to do is to change connection string from: strig sConn= string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}='Excel 12.0 Xml;HDR=YES;';", sFullFileName); to: strig sConn= string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended...

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** ...

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

25 Apr 2018 by Maciej Los

Using IMEX=1 in connection string - admittedly - avoids crashes during the process of retrieving data for mixed data columns, but it causes OledDb provider to treat data as a text. More details, you'll find here: Microsoft ACE OLEDB 12.0 Connection Strings - ConnectionStrings.com[^] I'd remove...

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() ...

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

25 Apr 2018 by Richard Deeming

Looking at your screen-shot, the CurrentMeterReading field is an integer in one table, and a floating-point number in another. The Field extension method does not attempt to change the type of the source field. It simply tries to unbox it to the requested type. If the source type doesn't...

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

24 Apr 2018 by Wendelius

At least few things to notice When you loop through the rows from Excel, you set a new data table and a new dataview on each iteration when the amount is less than what is found in the database. This causes the situation where only the last row remains. You should use a single data table and...

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 ...

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

20 Apr 2018 by Wendelius

If I understand your question correctly you don't have a column named CurrentMeterReading in your Excel sheet, that's just an alias that you give for a column when selecting the data. The column name in WHERE clause should refer the column names in the sheet. Have a try with something like...

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...

HELP! , Vb OLEDB INSERT record with table relations!

10 Mar 2018 by InfinityJoe

Ok Finally I Figure it Out Myself!!, just like i thought before, this problem should be resolved with an simple way somehow :) For those who looking the same answers here's my Working Solutions Try dim UniqeID = 6 'Let's say this number as uniqe for now DB.OpenConnection() 'Open Connection...