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" <johnkb...@paradise.net.nz> Sent: Tuesday, January 19, 2010 8:04 PM To: "NZ Borland Developers Group - Delphi List" <delphi@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@delphi.org.nz > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: > unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe