Re: Conversion from BDE to ADO

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/25/04 

Date: Wed, 24 Mar 2004 23:01:37 -0600

>I am currently experimenting with converting a quite large app from BDE to
>ADO. It accesses a MS SQL 2000 database, and before I commit and jump
>headlong into this I wonder if there are any major issues to be aware of?
>One of the main benefits I am hoping for is better multi-user detection
>capabillity e.g. if one user changes a record another has open and then the
>other user tries to change they get an appropriate error message.
They will get an error message that the record was changed by another user

> I have
>found BDE support for this a little flakey at best. Are there any setting
>changes from the default on TAdoQuery or TAdoConnection that I should
>definitely make? Finally I have seen a fair bit of discussion around
>suggesting that ADO will slow my app down, is this true?
That depends on how you programmed your application. If you just opened Ttables
to display all records from a large table and you continue this practice in a
conversion you will get a poorer preforming application.
Ado Client side cursors load all records into memory and will be slower if you
open datasets with a lot of records. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: Return a single value from a Sybase stored procedure using ADO
    ... proper value but I get error on the ADO call. ... The error message appears at the "While Not" line ... Dim objConn As Object ... Dim objRs As Object ...
    (microsoft.public.vb.database.ado)
  • Re: Really need help! ADO not working
    ... Set cnn = CurrentProject.Connection ... I'm guessing the error message doesn't say, ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ... ' Microsoft ADO Ext. 2.8 for DDL and Security ...
    (microsoft.public.access.modulesdaovba)
  • RE: Wondering why the following ADO connection to Access isnt working
    ... When does it fail and what error message are you getting? ... Set MYdb as New ADODB.Connection)? ... Some general troubleshooting guidelines I use with ADO: ... - Make sure you have the connection string correct. ...
    (microsoft.public.excel.programming)
  • Re: Problems inserting records
    ... I am confused by the DAO vs ADO approach. ... table in design view, and make sure the field's Indexed property (lower pane ... But the error message you reported suggests you have another table where the ...
    (microsoft.public.access.modulesdaovba)
  • Re: default values for Oracle stored procedure
    ... When the parameter isn't define in the asp page, an error message ... The names used in the parameters collection in ADO are not the ...
    (microsoft.public.data.ado)