🚀 go-pugleaf

Hi, friends,

I am using BCB5 with SP1 and ADOExpress SP. My program works well on Windows
2000(SP3). But when softwares, which upgrade MDAC (such as SQL Server 2000,
Visual Studio .Net, and so on) installed on my computer, my program crashed.
My program can't run on Windows XP either, which has a newer MDAC too.

There is something wrong with TADOQuery when working with newer MDAC. I
found that TADOQuery component couldn��t execute a UPDATE or INSERT command
once it had been used to retrieve dataset using SELECT command. My test
codes are very simple:



ADOQuery1->SQL->Text = "SELECT * FROM SYS_USER";

ADOQuery1->Open();

ADOQuery1->Close();



ADOQuery1->SQL->Text = "UPDATE SYS_USER SET STATUS = 'A'";

ADOQuery1->ExecSQL();



An exception is raised here: Access violation at address xxxxxx in
msado15.dll.



If I never use TADOQuery component to open a dataset, but use it to update
data only, this exception will never be raised.



What's wrong in it? I've tried to install MDAC 2.6 SP1, MDAC2.6 SP2, MDAC
2.7 on my computer, but couldn't eliminate this error. Thank you very much!



Mountain