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

ADO .NET Entity Framework edmx losing the connection string

I'm using VisualStudio 2019 as IDE. I used ADO .NET Entity Framework for MySQL 5.6. The solution is arranged in several project. I moved MySQL database from 5.6 to 8.0.31. To update the edmx model, I deleted the edmx file created with MySQL 5.6 and…
Edward Cohen
  • 31
  • 3
0
votes
0 answers

ADO in VBA to read XLS (Web Archive) file

I am writing VBA in Excel (Office 365) to retrieve data from external sources via the ActiveX Data Objects (ADO) 6.1 library Code works blisteringly fast to retrieve data data from XLS(X) and CSV files, but I have now encountered what appears to be…
emjaySX
  • 149
  • 11
0
votes
0 answers

rs.Open SQL not opening file?

Don't you hate it when a program worked last month and now it fails. I have an Access procedure that executes this (counts rows in the table with the matching date): StrSearchCriteria = "SELECT Ticker " _ & "FROM FundMonthlyDetailAllHistory " _ …
LEBoyd
  • 151
  • 12
0
votes
0 answers

How to interpret the result of ADO's NextRecordset on compound/concatenated non-row-returning stored procedures?

I have concatenated several stored procedures that do not return any result. After executing the compound command using ADO's Execute command, I need to check if each of the queries where executed successfully. This can be done on compound sql…
A.Agan
  • 103
  • 6
0
votes
0 answers

Multiple operations on a result set in asynchronous ADO

Following code: class function TDB.FlagSet(ADataSet: TDataSet; AFieldName: string): Boolean; var f: TField; begin Result := (ADataSet <> nil) and (not ADataSet.IsEmpty()) and (not ADataSet.Eof); if Result then begin f :=…
Paul
  • 25,812
  • 38
  • 124
  • 247
0
votes
1 answer

Updating DBGrids in Master-Detail views when updating Cells in Delphi

I am using TADOConn and TADODataSet units pulling data and connected to TDataSources and TDBGrids. I have my DBGrids displaying information properly and editing information in the detail view accurately reflects in the backing database. What I…
dpsthree
  • 2,225
  • 4
  • 21
  • 23
0
votes
0 answers

VBA ADO adDecimal Error - Precision not set

I'm attempting to pass data into a Stored Procedure in a SQL Server database, however I get an error which states 'The Precision is Invalid' Here's the code for for setting the variables Set oDatabase =…
SND69
  • 27
  • 4
0
votes
2 answers

Passing Optional Arguments in Classic ASP for Stored Procedure

I'm trying to run some stored queries in an Access database from an ASP page. I'd like to use an ADO Command object to run the procedure instead of simply sending a string to the database to execute. My trouble is occurring when I try to create the…
David Edwards
  • 85
  • 1
  • 10
0
votes
0 answers

Using SQL Server spatial with ADO, char set failure

I'm working with Delphi 10.4, ADO, SQL Server, using spatial features (SQL Server spatial ). Reading the text from the database is based on this code: type TDatabaserecord = record ... NameStr : String; …
Franz
  • 1,883
  • 26
  • 47
0
votes
0 answers

VBA having column name and value down the left of the worksheet

rather than have all my column names across the top of the worksheet, I'm looking to have them down the left hand side eg in Column A. The value of that will then be in Column B. I have used a record set which loops through and pulls the first…
ChrisR
  • 81
  • 9
0
votes
0 answers

What is the ADO Table equivalent of Delphi/Paradox TTable.SetRange

I am converting a large Delphi 2007 program from Paradox to SQL Server but the Ttable.Setrange function is not available in ADO. I've tried the ADO Filter property but I can't get the results I want. This is the code I want to change to use an ADO…
Patrick Fleck
  • 1
0
votes
0 answers

Problem with MS Access: ADO Configuration

Dim miConexion As New Connection Set miConexion = CurrentProject.Connection Dim sql As String sql = "SELECT tbl_forms.int_frmid, tbl_forms.str_frmnom From tbl_forms WHERE (((tbl_forms.str_frmnom)=[frm_nom]))" Dim miRecordset As Recordset. LIbrarys:…
eposswald
  • 1
0
votes
1 answer

INSERT stored procedure does not return the recordset with ADO

I have an INSERT stored procedure that works just fine when executing inside SQL Server, but when I run the same stored procedure using ADO, it does not return the recordset as it is supposed to. I tried for the rows affected and the result is the…
Ibo
  • 4,081
  • 6
  • 45
  • 65
0
votes
1 answer

App cannot gather column names from the db

I have the following construction Delphi Form > ADO Connection > Otero ODBC Driver > RBase database (ignore please exotic names) From the user's logic side, it's all classic: ADO Connection > ADO Query > DataSource > DBGrid This construction works…
Mariusz Stefaniak
  • 164
  • 3
  • 11
0
votes
0 answers

SQL Job failed with Connection Error (SSIS)

I have a SSIS project deployed in SQL Server SSIS 2015. I also have a scheduled job which runs the project in SQL Server 2016 (SQL Server Agent JOB). When I run the project in the SQL Server Agent Job, I get this error (ADO NET Source has failed to…
dodo
  • 13
  • 1
  • 1
  • 7
1 2 3
…
99 100