Stack Overflow
Stack Overflow

Questions tagged [ado]

Microsoft ActiveX Data Objects (ADO) is a COM based package for accessing databases such as SQL Server or data sources such as Excel spreadsheets. ADO.NET provides improvements over ADO along with integration with the .NET Framework for .NET developers. ADO.NET tag should be used for ADO.NET specific questions.

Microsoft developed ADO as a set of COM objects providing a middleware between an application and ODBC for accessing data sources. With ADO, the programmer has a more generic interface to database engines such as SQL Server as well as to other data sources such as Excel spreadsheets.

ADO provides a set of COM objects which a programmer can instantiate and then use for particular data source accesses. Being COM objects, ADO can be used with a variety of programming languages. The ADO interface allows SQL statements to be passed to a data source that supports SQL.

ADO contains 4 collections and 12 objects.

ADO.NET is a replacement for ADO in the .NET Framework.

Links:

References:

2633 questions
0
votes
0 answers

Add Entity Framework in VS 2022

I want to add Entity Framework to my project. I click add, add new item, and then select ado.net entity data model. When I finish the progress, I get this error: Object reference not set to an instance of an object I searched a lot but I can't…
Sina
  • 1
0
votes
0 answers

ASP Classic - ADODB.Recordset Update Oracle Error - 80004005|[Oracle][ODBC]Wrong_number_of_parameters

I am supporting an ASP classic application that uses ADODB.Recordset objects to interact with an Oracle database through an ODBC connection. The application works as desired in our QA environment, but we are encountering problems using the…
jjw
  • 111
  • 7
0
votes
1 answer

Azure DevOps Pipeline Az CLI task: ERROR: 'NoneType' object is not iterable

I have an Azure DevOps pipeline that runs every month to renew an SSL certificate with Let's Encrypt via terraform. The certificate is saved to an Azure Key Vault with policy-enforced soft delete and purge protection. since terraform's idea of…
Evgenii Fedosov
  • 1
  • 5
0
votes
1 answer

Migrate from .Net Framework Ado.Net to Net Core

I was worndering... Should I upgrade a project .Net Framework that's primary based on ADO.Net with lots of procedures to .Net Core? Is there even a way to do it? Is there a way to do it without having to go into entity framework mode when…
full stack dev
  • 7
  • 2
0
votes
0 answers

ADO DevOps - Sprint Capacity Issue when parallel releases are happening. I need the dashboard to pick it separately

the sprint capacity widget in the ADO dashboard is picking up patch release as well when two releases are going parallelly. Any solution to rectify it? The result was that I am only getting sprint capacity result of one release
Kb Athira
  • 1
0
votes
2 answers

Wrong query being generated when using parameterized query in Classic Asp

I am making a database call through the following parametrized query. set recordset = Server.CReateObject("ADODB.Recordset") set cmd1 = Server.CreateObject("ADODB.Command") cmd1.CommandText = "SELECT * FROM tbl_catmaster where (catname =? or…
Gaurav Pandey
  • 2,798
  • 4
  • 28
  • 41
0
votes
0 answers

Counter for build number in Azure Build Pipeline - Classic

I am trying to get a dynamic build number based on some criteria in ADO build pipeline classic, not Yaml. I am facing an issue to have the build number incremental. Normally I used to refer $(Rev:r) under Option - build number format which…
visweswaran
  • 97
  • 8
0
votes
2 answers

MS ACCESS crashes when filling listbox with ADODB.Recordset

I populate a list box on a user form with the following code: Dim CONSTRING As String Dim SQL As String Dim RSSQL As New ADODB.Recordset CONSTRING = "xxxxxxxxxx” SQL = "SELECT [ID], [Name] FROM [Table X] WHERE Name <>'' ORDER BY [Name]…
aTuring
  • 47
  • 6
0
votes
1 answer

Delphi dbGo in Web Service

I am trying to build a SOAP server that retrieves data from a SQL Server backend. I am using Delphi 10.4 Community Edition and ADO to connect to the database. I get the following error: CoInitialize was not called. I understand that this is…
Marc Phillips
  • 21
  • 1
0
votes
1 answer

Search string in UTF-8 Text (body contain Japanese text) file with ADO stream to find match value and line number of match value

I have a folder with text files that contains Japanese data (utf-8 text file). I have to search a specific string in those files and find the match. once the match is found I have to copy complete line and its line number (single file can have…
Gaurav
  • 1
  • 3
0
votes
0 answers

Exasol via ADO: Named parameter syntax in SQL-statement

I have a project: Excel frontend, MS Access DB as backend, connecting via ADO. Now we are migrating MS Access DB to Exasol - still using ADO via {EXASolution Driver}. One issue I don't get solved are named parameters like in SELECT ProjectName FROM…
Ike
  • 9,580
  • 4
  • 13
  • 29
0
votes
0 answers

How to access templates from external repos dynamically

I am working on a solution to implement a single Azure pipeline for our wide spread micro service architecture i.e., the single big application has diverted into nearly 100+ repos where each will be having its own pipeline. So to create a pipeline…
Dhanush
  • 1
  • 1
0
votes
0 answers

ADO Delivery Plans

ADO Delivery Plans Roll Up View We are planning to use delivery plans to track our roadmap and progress in ADO. And I had a question w.r.t the roll up Card View. In the % complete for stories, bugs, features etc., I need it to count "Done" and an…
Ravina
  • 1
  • 1
0
votes
0 answers

Is there a Version Upgrade provided for Combos.IComboOptions in ADO 2022?

We have upgraded TFS from TFS2020 to ado2022. I have used: import * as Combos from “VSS/Controls/Combos”; Combos.IComboOptions inside tfs extension. It was working correctly till version TFS 2020, but after upgrading to ado 2022, on click of…
Gautami Nilpankar
  • 1
0
votes
0 answers

Xaml Combobox ItemSource Changing After Selection

This is a little difficult to describe, so bear with me. C#, WPF This combobox in a stackpanel:
Guarandingo
  • 1
  • 1
1 2 3
…
99 100