Re: DAO to ADO and stored procs


We are moving an entire project from DAO (Diamond access) to ADO.

The Database is MS Access 2000 and nothing is changed from the database
side.
We encounter lots of problem on converting TDaoStoredProc to
TADOStoredProcs, with several error messages (Errors are in french, so I
don't mention them here).

The problems are mainly queries with params, complicated queries
(calculations or so), queries with linked tables.

We changed nothing in the database itself, the DAO version is running
well and is in use.

The conversion seems easy, we have the same kinds of components, I'm
sure we don't have errors in the params definition or so...so why do we
have so many problems ?

Does anybody have some tips or experience about this conversion ?

Access SQL syntax is a little different when you move from DAO to ADO

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Run action query in back-end from front-end database
    ... whatnot in the back end database. ... The queries are housed in the back end ... The reason I have the upload tables in the back end is that it will be on ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ...
    (microsoft.public.access.externaldata)
  • Desperate for help on serious TCP/IP connectivity problem
    ... MSDE either SP2 or SP3a) via TCP/IP under ADO results in queries being ... the connection to the database is made via TCP/IP ... We suspect that deep in the TCP/IP stack something is pumping messages, ...
    (microsoft.public.sqlserver)
  • Re: Knowledge Base Help Not working
    ... Database is a DAO object. ... both Access 2000 and 2002 use ADO. ... Microsoft DAO 3.6 Object Library, ... For example, to ensure that you get a DAO recordset, you'll need to ...
    (microsoft.public.access.formscoding)
  • Re: ADO and the Find method
    ... You cannot compare DAO and ADO. ... database, which has OLEDB provider. ... >>>> Opening of the whole table was not a good design anytime. ...
    (microsoft.public.vb.database.ado)
  • Re: Crosstab query error 3104
    ... Thankfully very few compile errors had to ... I have both DAO & ADO references checked but DAO is higher so it is taking ... Thanks - I inherited the original database & am gradually working through ... then perhaps you've removed the reference to ADO. ...
    (microsoft.public.access.queries)
Loading