Top "Ado" questions

Microsoft ActiveX Data Objects (ADO) is a COM based package for accessing databases such as SQL Server or data sources such as Excel spreadsheets.

A better way of passing parameters to a TADOStoredProc (Delphi)

I am needing to convert a large amount of SQL queries into stored procedures. I have some code that updates …

sql-server delphi stored-procedures ado
Delphi: “Parameter object is improperly defined. Inconsistent or incomplete information was provided.”

This is a Function that does the following: Create a random Token with 8 length Insert that Token into the Database …

delphi parameters ado
ADO components CommandTimeout

I have a problem with settings of the query execution timeout with TADOQuery, TADOCommand or TADODataSet (I've tried it with …

delphi timeout ado tadoquery tadodataset
ADO.RecordCount equals - 1 problem

When ever I try to access the RecordCount property, I always get a return value of -1. Below is my …

asp-classic ado
ADODB open recordset fails / "Operation is not allowed when object is closed"

I have the following UDF in excel which uses ADO to connect to my MSSQL server. There it should execute …

sql-server vba ado adodb recordset
How Can I Sort an ADO Table on a Fieldname Containing a Space?

I am using Delphi, but this is a simple and general problem: I'm doing the following: var ArticlesTable: TADOTable; begin …

delphi ms-access sorting ado tadotable
SSIS Package error- SSIS Error Code DTS_E_PROCESSINPUTFAILED

SSIS job has failed and posting the below error [Product Sales [749]] Error: An exception has occurred during data insertion, the …

sql-server ssis etl ado sql-agent-job
BDE vs ADO in Delphi

Please note the Edit below for a lot more information, and a possible solution We recently modified a large Delphi …

performance oracle delphi ado bde
Auto-Recover when DBNETLIB ConnectionWrite General network error causes ADO connections to go offline in Delphi applications?

Googling this ADO error message indicates that it is commonly encountered in ASP.NET development, but I have not found …

sql-server delphi ado
How to run a database script file from Delphi?

I want to do the following. 1) Create a database. 2) Run a script when creates tables, stored procedures, etc. (this script …

sql-server delphi ado