[DUG] MSSQL with D2007

[Neven MacEwan]

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 at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe