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 pipeline breaking when using 'buildx' plugin to build image

I am looking for any input to an issue I am experiencing in my ADO pipeline. Below is an example of the first part of the Dockerfile (all that is needed for demonstration) that keeps failing: FROM harbor.xyz.biz/foo/bar/sdk:6.0-alpine AS publish ENV…
AsapHogFtw
  • 181
  • 1
  • 1
  • 8
0
votes
1 answer

Microsoft OLE DB Provider for SQL Server error '80040e14'

Stored procedure, and using ADO to connect, i'm having problems with the quotes however.. x = "text'" If instr(x,"'") then x=replace(x,"'","''") 'x = "text''" at this point Set Rs = Server.Createobject("adodb.recordset") …
Control Freak
  • 12,965
  • 30
  • 94
  • 145
0
votes
1 answer

Updating SQL Server using ADODB recordset UpdateBatch method

I am trying to populate a single column temporary table in SQL Server using ADO in Excel VBA. My code is very slow, namely 145 seconds for 1,000 rows. Is there a faster way involving maintainable elegant code that doesn't involve manipulating raw…
langbourne
  • 153
  • 9
0
votes
0 answers

Error: No database provider has been configured for this DbContext

I am working on C# and Entity Framework. I delved into the logical side of things a bit to learn the ORM logic. However, I encountered an error while working. The error occurred as follows: I used the embedded SQL used for testing in the SQL Server…
Emir Yılmaz
  • 1
  • 3
0
votes
1 answer

can we declare a public variable in asp using vb

I have a established connection to my database using adoCon.Open "Driver={SQL Server}; Server=" & host_name & "; Database=" & db_name & "; Uid=" & user_name & "; Pwd=" & password Now i want to use this connection on all the pages of my website. How…
Raj Gupta
  • 260
  • 3
  • 6
  • 18
0
votes
0 answers

How to connect Java test project with ADO Test Plans

We have Java project with cucumber tests we are trying to migrate over to ADO Test plans. this article talks about how to do it from Visual studio however Visual studio no longer supports Java, se are trying to do it from vsCode instead. After…
Joly
  • 3,218
  • 14
  • 44
  • 70
0
votes
2 answers

Connecting to SQL Server 2008 database using asp

I tried a lot but I am not able to deal with this problem. I wasted last 2 days without any significant result. Hope I will get some help here. I wanted to connect to a SQL Server 2008 database using ASP. I installed SQL Server 2008, created a…
Raj Gupta
  • 260
  • 3
  • 6
  • 18
0
votes
0 answers

Convert subsequent SQL to case insensitive in SQL Server

We are converting from ASE (Sybase) to SQL Server (yay!) Unfortunately, we have a ton of SQL built into our C# code which assumes ASE's default case insensitivity. We are using ADO for both. Is there something I can prepend in SQL to force all…
Eric Brown - Cal
  • 14,135
  • 12
  • 58
  • 97
0
votes
0 answers

windows form insert issue

I connected windowsform with sql with ado and recive data in datagridview for insert data i put textbox in my form but i tested it and put text but instead of set data into sql with sqlconnection(ado(connectionstring)) my boolean return…
Ruzbeh Nasiri
  • 1
  • 1
0
votes
1 answer

Delphi read Excel file with a column with mixed data types

We have an excel file we are trying to read into an ADOTable in Delphi. The first column contains mostly integers and sometimes it will have a char; we would like to read the whole column as type text. The problem is the char data is being read in…
user21574965
  • 11
0
votes
1 answer

EXCEL VBA ADO copy CSV and separate by semicolon not comma

What I am trying: copy all data from a closed CSV (works) paste it separated initial position: CSV data is delimited by semicolon ; the code below copies everything, but only separates by comma , (pretty bad for europeans -.-') Sub…
Pl0x_H3lp
  • 3
  • 2
0
votes
0 answers

Delphi ADO "Required" attribute always false

With the ADO components in Delphi 2007 through Delphi 11.2, I have the following problem: My DBMS is Microsoft SQL Server. The "required" attribute is always false, even if the field is "NOT NULL". The issue happens with all 3 generations of ADO…
Daniel Marschall
  • 3,739
  • 2
  • 28
  • 67
0
votes
0 answers

Inconsistent data set state during processing of OnDrawColumnCell handler

After switching to asynchronous operations for TADOStoredProc, one issue periodically arises in TDBGrid handlers, for example in OnDrawColumnCell: I check the data set for Empty, find out that it has data, and in the next line it turns out that…
Paul
  • 25,812
  • 38
  • 124
  • 247
0
votes
1 answer

VFPOledb9 - Microsoft ODBC Visual Foxpro Driver Function Name is Missing when using Delphi 7 ADO Query

Using Delphi 7/AdoQuery qry1.close; qry1.sql.clear; qry1.SQL.text:=**'UPDATE ardata SET saletodate = (SELECT sum(tot_rm_amt) from saledat where saledat.short_name=ardata.short_name )';** //qry1.SQL.text:='UPDATE ardata SET saletodate =0' ; This…
CCH4BI
  • 1
  • 1
0
votes
0 answers

Prints only the first value it finds in recordset

I am trying to make a select in firebird according to the value it has in an excel range. I use a for to go through the column, I only have a problem printing the select, it only prints the first value it finds. I appreciate your help Dim F As New…
DIEGO ALDAY
  • 13
  • 2
1 2 3
…
99 100