[DUG] MSSQL with D2007

[David Brennan]

We use TAdoConnection and TAdoStoredProc to retrieve and save data to/from
the database and it works fine. We use ClientDatasets for editing the
database at the front end though (ie we populate from TAdoStoredProc, the
user edits the client dataset, then we put back via TAdoStoredProcs).

 

David.

 

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz] On
Behalf Of John Bird
Sent: Tuesday, 19 January 2010 8:05 p.m.
To: NZ Borland Developers Group - Delphi List
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100119/b290090b/attachment-0001.html