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 <[email protected]>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:* [email protected] [mailto:[email protected]] > *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: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to [email protected] with Subject: > unsubscribe > -- Kyley Harris Harris Software +64-21-671-821
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
