Access violations after D2007 Update 3

[Dave]

Hi All,

I am seeing Access Violations now when my program attempts to change the SQL
text of a query.

I have a simple bit of code like this:
qry400.Close;
qry400.SQL.Clear;
qry400.SQL.Text := Format('select DESC01 from CELS.RPT001 where
REP#01=%d', [i]);
qry400.Open;

When the app tries to execute this code a second time I get an AV:
Access violation at address 00404718 in module 'RepliGoPrint.exe'. Read of
address FFFFFFDD.

Anyone else experiencing similar problems?

Dave

[Chris Paskins]

I was getting that as well, A/V when adding to SQL property. I found that I
had to call the same bit of code a few times before it would convince Delphi
not to trip up on perfectly good lines.

I use CoreLab Oracle and MSSQL drivers and I had other dbexpress related
issues which I raised with them after applying Update 3. They replied:

"There are many incompatible changes for dbExpress in Update 3 for Delphi
2007. So, our drivers have to be modified correspondingly to support these
changes in dbExpess. We do not recommend using the current version of DbxSda
with Delphi 2007 Update 3"

I also use the Borland Interbase driver but I've found that Interbase Stored
Procedures with input AND output parameters are unusable as well ("Incorrect
values within SQLDA structure") with D2007 with Update 3.

In summary, for me Update 3 has been pure poison and I've rolled back my
machine to Update 2 now everything suddenly works properly again. I don't
understand why only a few of us seem to be suffering; I don't care so much
now I've got something that works though.

I think I'll wait for Update 4. dbexpress might work by then.

Regards
Chris

Post by Dave
Hi All,
I am seeing Access Violations now when my program attempts to change the
SQL text of a query.
qry400.Close;
qry400.SQL.Clear;
qry400.SQL.Text := Format('select DESC01 from CELS.RPT001 where
REP#01=%d', [i]);
qry400.Open;
Access violation at address 00404718 in module 'RepliGoPrint.exe'. Read of
address FFFFFFDD.
Anyone else experiencing similar problems?
Dave

[Dave]

Post by Chris Paskins
In summary, for me Update 3 has been pure poison and I've rolled back my
machine to Update 2 now everything suddenly works properly again.

By 'rolled back', I assume you mean System Restore? I do not see any easy
way to uninstall Update 3, and System Restore is not running on my
development PC.

Hopefully there will be some quick patches, or I may be forced to reinstall
my PC :(

[Steve Shaughnessy]

Hi,

Is it possible for you to provide a reproducible test case for the problem
you are having?

Thanks,

-Steve

Post by Chris Paskins
I was getting that as well, A/V when adding to SQL property. I found that I
had to call the same bit of code a few times before it would convince
Delphi not to trip up on perfectly good lines.
I use CoreLab Oracle and MSSQL drivers and I had other dbexpress related
"There are many incompatible changes for dbExpress in Update 3 for Delphi
2007. So, our drivers have to be modified correspondingly to support these
changes in dbExpess. We do not recommend using the current version of
DbxSda with Delphi 2007 Update 3"
I also use the Borland Interbase driver but I've found that Interbase
Stored Procedures with input AND output parameters are unusable as well
("Incorrect values within SQLDA structure") with D2007 with Update 3.
In summary, for me Update 3 has been pure poison and I've rolled back my
machine to Update 2 now everything suddenly works properly again. I don't
understand why only a few of us seem to be suffering; I don't care so much
now I've got something that works though.
I think I'll wait for Update 4. dbexpress might work by then.
Regards
Chris

Post by Dave
Hi All,
I am seeing Access Violations now when my program attempts to change the
SQL text of a query.
qry400.Close;
qry400.SQL.Clear;
qry400.SQL.Text := Format('select DESC01 from CELS.RPT001 where
REP#01=%d', [i]);
qry400.Open;
Access violation at address 00404718 in module 'RepliGoPrint.exe'. Read
of address FFFFFFDD.
Anyone else experiencing similar problems?
Dave

[Chris Paskins]

I've removed Update 3 now so I'm afraid I can't make up a nice little
reproducible test case for you. It's an interesting problem because the A/V
would happen in exactly the same place each time in quite a large database
application. I never worked out what was causing it but I needed to get back
to producing product that worked asap - hence restored Update 2.

Post by Steve Shaughnessy
Hi,
Is it possible for you to provide a reproducible test case for the problem
you are having?
Thanks,
-Steve

Post by Chris Paskins
I was getting that as well, A/V when adding to SQL property. I found that
I had to call the same bit of code a few times before it would convince
Delphi not to trip up on perfectly good lines.
I use CoreLab Oracle and MSSQL drivers and I had other dbexpress related
"There are many incompatible changes for dbExpress in Update 3 for Delphi
2007. So, our drivers have to be modified correspondingly to support
these changes in dbExpess. We do not recommend using the current version
of DbxSda with Delphi 2007 Update 3"
I also use the Borland Interbase driver but I've found that Interbase
Stored Procedures with input AND output parameters are unusable as well
("Incorrect values within SQLDA structure") with D2007 with Update 3.
In summary, for me Update 3 has been pure poison and I've rolled back my
machine to Update 2 now everything suddenly works properly again. I don't
understand why only a few of us seem to be suffering; I don't care so
much now I've got something that works though.
I think I'll wait for Update 4. dbexpress might work by then.
Regards
Chris

Post by Dave
Hi All,
I am seeing Access Violations now when my program attempts to change the
SQL text of a query.
qry400.Close;
qry400.SQL.Clear;
qry400.SQL.Text := Format('select DESC01 from CELS.RPT001 where
REP#01=%d', [i]);
qry400.Open;
Access violation at address 00404718 in module 'RepliGoPrint.exe'. Read
of address FFFFFFDD.
Anyone else experiencing similar problems?
Dave