I have a Delphi 2010 application using ADO to support a database that can be either SQL Server or MS Access.When sending SQL to the database using parameterized queries differences in date representat
I have two apps that need to receive notifications when data in a table changes. One .NET and the other C++ MFC. I decided to go with SQL Query Notifications.
I have to use old school ADODB (not ADO.NET) to execute a statement that contains a Common Table Expression.
UPDATE: Please see the updates below, as I\'m adding more information to the bottom as I run into it.
I\'m trying to fix an ASP Classic app and when I try to create an array from a Recordset Object.However I Can\'t get it to work correctly.
I need help understanding why my SQL does not work. Or, if i need to write it differently to get the results i need.As the title suggests, I am using Delphi 7, with ADO components, and a MS Access 200
I\'m using ADO to read and write a database from a VB6 application. Naturally, the database access may return errors. I am currently displaying an error message by a method borrowed from here http://w
I have a table in mdb with field address, which will contain street address e.t.c as string. I want to be able to search part of this record.
I\'m trying to import msado15.dll into my c++ project but I get a bunch of errors like these: error C2018: unknown character \'0x40\'
Recently I had a very strange problem. The application is written in classic ASP, but I guess it is the same case for every connection that uses ADO/OLEDB.