Category "oledb"

Solution add textbox in SQL as string in vb.net

What is the solution if you see the code below there is a value (2000) then I want to change it to textbox so I can custom value. Thanks jack Dim sql As String

Weird OleDbDataAdapter Fill behavior (hangs with explicit fields) on IBM i System

we're migrating our IBM i System from OS 6.0 to 7.4; we're testing all the applications which somehow connect and read/write data to it and we found a weird beh

Oracle OLEDB Memory Leak 12.2 and Greater (SSIS and C#)

I have found an issue with the Oracle OLEDB Driver “Oracle Provider for OLE DB” and MS SQL SSIS Packages. This was first found in SQL SSIS packages

C# how to call an as 400 stored procedure using oledb

Hi I am trying to call an as400 stored procedure using OleDB. Could you please post an example of how to do it cause I've been following some tutorials but not

MSSQL 2019 Installation Problem How to solve Microsoft OLE DB Driver for SQL Server

While trying to install MSSQL 2019 ON Windows-10 I got a problem. I was almost done with the installation when this pops up: If I skip it, I won't be able to a

Using OLEDB for uploading file with Excel 2016

my application basically accepts an excel file and uploads data to my database which used to work perfect with Excel 2010 with the below code. However we update

Connecting to Dynamics 365 TDS-enabled database with OLEDB Linked Server

I want to run SQL Server queries on a Dynamics 365 database. The administrators of the Dynamics database have enabled "TDS" for me - and now I can easily connec

Power BI - Data Load Error- OLE DB or ODBC error: [DataSource.Error] PostgreSQL: Exception while reading from stream

My question might look similar to some earlier posts but none of the solution has answered what is the rootcause of this behavior. I would try to explain what I

OleDb Exception was unhandled

I seem to be getting a OleDb Exception was unhandled when running this code and i really cant see why... Code attached Thanks! James Module DataAccess Pri

Why does Application close after executing a SQL Server CE update command?

My application closes after I execute an update command via oledb connection I also use DataAdapter but it closes without any error too, I can execute insert, d

Report wont run when using OLE DB connection

I have an SSRS Report it works perfectly when I use Oracle data source. However, when I tried to connect using OLEDB connection I am running into some issues. 0

Using a SELECT statement to return a row where a DateTime column = variable of type Date?

I am using OleDb, trying to do this: Dim d as Date = DateSerial(Year(rptDate), Month(rptDate), 1 - 1) Dim conn as OleDbConnection = new OleDbConnection(connSt

Is it possible to use 'Microsoft.ACE.OLEDB.12.0' provider without installation?

I have an Excel-reading library that depends on the Microsoft.ACE.OLEDB.12.0 provider - I would like a way to use it without being forced to install the Access