<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18865">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2 face=Arial>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</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#000000 size=2 face=Arial>Using instead ADO (TADOConnection and
TADOQuery) works fine, but is slow - 7000 records takes 30-40 seconds to
load.</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#000000 size=2 face=Arial>The rest of the components the
same (ie TDatasetProvider, TCLientDataSet, TDatasource) ie have been
pointing the Datasetprovider at either the TADOQuery or the
TSQLQuery</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#000000 size=2 face=Arial>Also tried the TSimpleDataSet, has
the same error as the first sentence.</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial>All the queries allow me at design
time to set active to true successfully, but still crash when the dataset is set
to open....</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#000000 size=2 face=Arial>Does anyone have any idea what
could be going wrong?</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV><FONT color=#000000 size=2 face=Arial>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.</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV>John</DIV></BODY></HTML>