[DUG] MSSQL with D2007

[Kyley Harris]

It would also help to know where the database is in relation to the actual
client. Are you on a gigabit network, 100mbit, or a VPN running over the
internet. all these things can play a role.

I am using the SDAC component suite.. Fast, Reliable. no issues so far.

On Tue, Jan 19, 2010 at 9:19 PM, David Brennan
<dugdavid at dbsolutions.co.nz>wrote:

>  I should say there is something wrong with your ADO setup if it is taking
> that long for 7000 records, unless they are VERY big records.
>
>
>
> 7000 records of 2-4000 bytes each should be only a second or so (don’t want
> to be more accurate in my estimate without testing, been a while since I
> paid much attention to data transfer times be honest!)
>
>
>
> 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
>
> _______________________________________________
> 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
>



-- 
Kyley Harris
Harris Software
+64-21-671-821
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100119/17b3fa69/attachment.html