fisheromacse
IS-IT--Management
Hello all, and thanks in advance,
I am attempting to run an update to a MSSQL database using a 3rd party update tool.
It appears to go as desired, until the schema gets updated, then I receive the following error: "Could not update schema. EAccess Violation error raised, with message: Acces violation at address 4C6217B3 in module 'idsql32.dll'. Write of address 047CF000"
I did a google search and found the following links that seem to describe my problem as being related to Borland BDE:
and this one that has a potential solution: Solution:
Assign a CustomConstraint on the DataSet that you want a DefaultExpression in and this will fix the problem. Make the CustomConstraint global for the entire DataSet and not just for the field(s) you want to set a DefaultExpression to since the local CustomConstraint for the specific field will only fix the DefaultExpression for the field alone and still give you the AV for any other DefaultExpressions. I normally use a CustomConstraint like "FIELD IS NOT NULL" to fix the problem.
...But i don't have control over the script being run, although i likely can rewrite portions if necessary... any suggestions?
I am attempting to run an update to a MSSQL database using a 3rd party update tool.
It appears to go as desired, until the schema gets updated, then I receive the following error: "Could not update schema. EAccess Violation error raised, with message: Acces violation at address 4C6217B3 in module 'idsql32.dll'. Write of address 047CF000"
I did a google search and found the following links that seem to describe my problem as being related to Borland BDE:
and this one that has a potential solution: Solution:
Assign a CustomConstraint on the DataSet that you want a DefaultExpression in and this will fix the problem. Make the CustomConstraint global for the entire DataSet and not just for the field(s) you want to set a DefaultExpression to since the local CustomConstraint for the specific field will only fix the DefaultExpression for the field alone and still give you the AV for any other DefaultExpressions. I normally use a CustomConstraint like "FIELD IS NOT NULL" to fix the problem.
...But i don't have control over the script being run, although i likely can rewrite portions if necessary... any suggestions?
