[DUG] MSSQL with D2007

[Dennis Chuah]

John,

Hi.  If you do not use data aware controls, or otherwise need TDataset, then 
I would recommend that you use ADO directly.  Fast, simple, and does not 
have the overhead of TADOConnection, etc.  I normally import the type 
library into Delphi, but you can also use the one that comes with Delphi.

Regards,
Dennis.

--------------------------------------------------
From: "John Bird" <johnkbird at paradise.net.nz>
Sent: Tuesday, January 19, 2010 8:04 PM
To: "NZ Borland Developers Group - Delphi List" <delphi at delphi.org.nz>
Subject: [DUG]  MSSQL with D2007

> 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