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
2 answers

Delphi ADOQuery is not using parsed parameter values. Getting "Syntax error in FROM clause"

Trying to run a select statement using the below code. I'm parsing a SQL table name parameter whose value is determined by a case statement. This then assigns the dataset to a global datasource used in another form. However, the app is returning a…
Harrebow
  • 3
  • 2
0
votes
0 answers

Pass dateTime to Stored Procedure in ASP.Net Core

'public void OnPost() { DateTime dt = DateTime.Parse("2022-10-22"); execProc(newDate.Name, newDate.Age, dt); } public void execProc(string name,int age,DateTime birthDate) …
Abdullah Abu Hantash
  • 1
  • 1
0
votes
0 answers

Migrating from SQLOLEDB to MSOLEDBSQL problem with recordset update

During migration from SQLOLEDB to MSOLEDBSQL i am facing some issues with ADO update operation on Recordset. In our system we use old ADO with SQLOLEDB provider and during migration to MSOLEDBSQL it occures that there are some differences during…
Bbb Tttt
  • 1
0
votes
1 answer

Database Connection Fails when using ADO.NET Repository but works well when querying directly on EF Core

I am connecting to a Database using following connection string. Server=tcp:mydbserverURL,1433;Initial Catalog=mydb;Persist Security Info=False;User…
DL Narasimhan
  • 731
  • 9
  • 25
0
votes
1 answer

Trouble With VBA ADO Call

I am relatively new to VBA and need some assistance. I have been piecing together this application from other bits and samples. This was working on Friday but now it isn't and I don't understand what may be causing the issue. I have a master…
notionDesign
  • 17
  • 8
0
votes
1 answer

convert boolean value to SortOrder enum value

i am reading boolean value (value would either 1 or 0) using data reader in ADO.NET from a table and want to type cast value to SortOrder (http://msdn.microsoft.com/en-us/library/dscy145f.aspx). I am getting error if i use Enum.TryParse method to…
user936405
  • 59
  • 1
  • 1
  • 5
0
votes
0 answers

Reusing ADO objects across multiple CoInitializeEx/CoUninitialize cycles

Currently I'm writing a REST server using a framework of a well-known Delphi component developing company. This framework provides the ability to simply write a class whose methods are named like the REST API endpoints. The REST server fetches data…
DinkumOil
  • 21
  • 5
0
votes
0 answers

Error trying to add connection string in Core 3.1,'IServiceCollection' does not contain a definition for 'AddDbContext'

I have a .net Core 3.1 project, which uses a class library for DAL and a Class library for the BLL layer and a Core 3.1 MVC project. The DAL project registers the BLL interface with the the DAL class as the implementation type. It uses ADO and not…
Neal Rogers
  • 498
  • 9
  • 27
0
votes
1 answer

Set Access form record source based on SQL Server temporary table

I use MS Access with SQL Server 2019. The application can process deliveries - meaning that I scan barcodes with serial numbers, which get saved into a SQL Server temporary table. After the process is finished and validated, the data from the…
ThomassoCZ
  • 73
  • 6
0
votes
3 answers

SELECT * INTO Access FROM csv ; running VBA ADO from Excel

upd.: Here is a Syntax that finaly solved the issue: 'createSQL = "SELECT * INTO newlyСreatedTableName FROM [fileName.csv] IN 'folderPath' [""Text;HDR=YES;FMT=Delimited""]" Struggling with data transferring. I have a .csv with a 6 mln rows and…
Mik
  • 2,099
  • 1
  • 5
  • 19
0
votes
0 answers

How do I "Check each OLE DB status value" as instructed by the error message?

I am troubleshooting a very old web site that uses Classic ASP written in Visual Basic. I've narrowed the problem down to a failure when attempting to open an ADO connection. The code looks like this: On Error Goto 0 Set myConnection =…
John Wu
  • 50,556
  • 8
  • 44
  • 80
0
votes
0 answers

Single Result from recordset returning w/o being transposed

I am working on a project where I'm using SQL to return records from a database into a listbox using userinput. Things are fine when there's more than one result, the listbox reads properly. However, when there's only one record, it doesn't…
Ace_Q
  • 41
  • 6
0
votes
0 answers

How to begin new transaction using ADO

I've tried CurrentProject.Connection.BeginTrans ' This acts as if you didn't begin a transaction. ' Changes are posted real time then gets an error on Commit that you are not in a transaction Private conn As ADODB.Connection Set conn =…
BWhite
  • 713
  • 1
  • 7
  • 24
0
votes
1 answer

How to get affected record count from ConnectionObject.Execute() Method in vb.net

I am deleting entries in table using Connection object Execute() function. I am unable to get numbers of rows affected. Could someone help? Dim db As ADODB.Connection db = OpenDatabase(ConnectionString) deleteExams = "delete from [Table2] where …
Karthik Karnam
  • 170
  • 11
0
votes
2 answers

Delphi ADO query - how to search for AD users with specific bits in userAccountControl

I am using delphi 10.4 and using TADOConnection and TADOCommand component to access Active Directory data. I need to search for user accounts with a specific bit set in userAccountControl filed (i.e. "must change password on next logon" or…
Vlad
  • 3
  • 3
1 2 3
…
99
100