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
1 answer

How do I select a variable with a space in the name using VBA from a CSV file via ADO?

Sub GetTextFileData(strSQL As String, strFolder As String, rngTargetCell As Range) ' example: GetTextFileData "SELECT * FROM filename.txt", _ "C:\FolderName", Range("A3") ' example: GetTextFileData "SELECT * FROM filename.txt WHERE…
xiaodai
  • 14,889
  • 18
  • 76
  • 140
0
votes
0 answers

Manipulate final SQL query in C++Builder 6 with ADO

We are using C++Builder 6 for an old product, and ran into a problem with comparison of DateTime objects failing if they contain milliseconds. This problem seems to be present even in Visual Studio C#, but one of our colleagues already found the…
Benjamin
  • 1
  • 1
0
votes
0 answers

Why does OnCalcFields Trigger fire in GUI moving up or down

how can I stop 'onCalcFields' Trigger to fire when I Reach for 1st Record or Last Record while I set 'MyQuery.Prpertie' ('AutoCalcFeilds' = False)
Rami Yasin
  • 1
0
votes
3 answers

Detect when someone uses my TADOConnection after it's been freed?

A colleague came me to today with an error with code that worked on Windows XP but fails on Windows 7: User failed for login 'SalesOrdersystem' My phychic debugging told me he was running a query against a database connection that was closed, or…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
0
votes
1 answer

Copy Activity fails from ADO (Odata) Source to Azure Data lake

I need to copy data from ADO(OData) to Azure Data lake. All connections and Linked services are working good. I can preview data from ADO(OData) but getting below error and seems like data is not passed to Datalake and can't able preview data into…
Deep
  • 1
  • 1
0
votes
1 answer

Sending SQL Queries to CSV file on Excel VBA doesn't work for Date Columns

I am trying to get some data from a csv file having more than than 3 million rows. I've set an ADODB connection to my csv file and everything works fine except for querying date columns. Here is how I set the connection Dim conn As New…
Oğuzhan Orhan
  • 3
  • 1
0
votes
1 answer

Delphi ADO can't find MSSQL 2019 server

I needed to update my old 2008 MSSQL to 2019 Express. (Both accessed locally on the same computer) This works as far as I can tell since I can see my database in SQL Server Management Studio. So seems to me that is working. (The way I test is I also…
Tom
  • 3,587
  • 9
  • 69
  • 124
0
votes
1 answer

SQL request in VBA, referencing named range not working

I'm trying to import data from an excel workbook with multiple sheets that by themself contain multiple tables of data. The goal is to reference a specific table in a sheet by its name and insert it into another excel sheet. It works if I only…
UncleScrooge
  • 13
  • 5
0
votes
1 answer

Access Error With Disconnected ADO Recordset

I'm testing a datasheet form that's bound to a disconnected ADO recordset. When I edit any part of any record I get the following error message after the update has occurred: "The data was added to the database but the data won't be displayed in…
HK1
  • 11,941
  • 14
  • 64
  • 99
0
votes
1 answer

Cannot implicitly convert System.Data.SqlClient.SqlDatReader to AdoControls.SqlDataReader

I'm learning ADO.Net and have been performing SQL commands on GridView. Today I started to learn the SqlDataReader In ADO.Net and when I try to Execute my Command and pass it to the SqlDataReader Object, it shows the error > CS0029: Cannot…
Sandarbh Asthana
  • 5
  • 3
0
votes
1 answer

How to connect to MS Dataverse using ADODB Connections in VBA

I have been successful in connecting to a MS SharePoint list in VBA with the following sub-routine: Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim sConn As String Dim sSQL As String sConn =…
mf_cbn
  • 3
  • 2
0
votes
0 answers

Receiving Intermittent MS Access Error 2467 when Updating Records via Code

I have an MS Access db split FE/BE on a network file share, that holds employee "Roster" info - Name, Division, Unit, Work location etc. I recently added a simpler feature for updating "DivisionUnit" than what existed previously. I also added code…
JuniperSquared
  • 143
  • 1
  • 12
0
votes
2 answers

Recordset.AddNew ADO VBA generating Row handle referred to a deleted row or a row marked for deletion

I am adding several records to a sharepoint list programmatically using to save time over using a form on the sharepoint as I sometimes have to add up to 50 entries at any given time. It was working fine, and then the macro was shared with other…
DizturbdOne
  • 26
  • 2
0
votes
1 answer

In-line Table Value Function with Recursive CTE using ADO with OLE DB

Apologies, I cannot provide a reduced data case for the moment. But here is a general question. I have been using, since SQL Server 2005, thru an application using ADO with OLE DB, a Multi-Statements Table Value Function with Recursive CTE without…
PETZLr
  • 3
  • 2
0
votes
0 answers

ADO adLockBatchOptimistic allows updates on modified records

I'm begging for help, since I'm too stupid. What I do: Open connection to Access DB Download Table to a Recordset Disconnect the RecordSet Update a record Update the same record in DB (by another user) Connect RecordSet back to DB UpdateBatch…
Michael Mazur
  • 33
  • 3
1 2 3
…
99
100