BDE to ADO conversion

rbuser

HI,

we are in the process of converting several hundred BDE reports to ADO.
We have extracted to ASCII and converted the following entries in the RTM
file

daBDEQueryDataView -> daADOQueryDataView
TppChildBDEPipeline -> TppChildDBPipeline
DatabaseType = dtInterBase -> DatabaseType = dtMSSQLServer
DatabaseName = ''dbPropertyValuation'' -> DatabaseName = ''connDB''


Now, some reports (ie. the simple ones) work fine, others simply dont
work. The problem we have now is?working out why ! If we open the
failing reports in to designer (DADE) and go to the data view we can
preview some of the data sets but not all of them. The ones we can't
preview cause an access violation as follows

Access Violation at address 0004BF0F in module 'rbDAD107.bp'.
Read of address 000000CC

This location turns out to be in TdaSQL.CreateFieldForTable but that's as
far as we can get !?

THe other strange issue is if we click on the data settings menu option
in the data tab it complains about failure to init the BDE, even with
reports that work !? Have we missed something fundamental here ?

Thanks in advance...

Mark



--- posted by geoForum on http://delphi.newswhat.com