John If ADO is slow check the type of dataset that it is opening, it may be a dynamic cursor where as for TCLientDataSet you onlu need a quick pass thru, remember ADO has its own client data management built in
HTH Neven > Been trying to connect to MSSQL 2005 with DB Express (TSQLConnection > and TSQLQuery), but cannot get it to work, we are getting an access > violation at address 017E0913 in DBXMSS30.DLL read of address 01820000 > > Using instead ADO (TADOConnection and TADOQuery) works fine, but is > slow - 7000 records takes 30-40 seconds to load. > > The rest of the components the same (ie TDatasetProvider, > TCLientDataSet, TDatasource) ie have been pointing the > Datasetprovider at either the TADOQuery or the TSQLQuery > > Also tried the TSimpleDataSet, has the same error as the first sentence. > All the queries allow me at design time to set active to true > successfully, but still crash when the dataset is set to open.... > > Does anyone have any idea what could be going wrong? > > And any recommendations of best combinations you prefer for MSSQL with > D2007. I am new to connecting D2007 to MSSQL so willing to do it > whichever way works best. > > John > ------------------------------------------------------------------------ > > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: delphi@delphi.org.nz > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: > unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
