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
