Devart Forums

We are using SDAC 4.35.1.15 for Delphi 6 along with SQL Server 2005 express edition.

We are backing up data using TMSDUMP and when we try to restore the same data, it gives unhandled exception (and crashes application)
which is not even trapped by try..except delphi block. The delphi code block is as below:

try
application.ProcessMessages;

MSDump1.RestoreFromFile(FileName);

except //it never comes in this exception block
on e: Exception do
reLog.Lines.Add(e.Message);
end;


The dump file contents are as below:

--
-- Dumping data for table EXBRF
--

TRUNCATE TABLE EXBRF;
INSERT INTO EXBRF(BRFNR, BRFOMS, BRFONDERW, BRFTEKST)
VALUES ('AANM3', 'Aanmaning 30 dagen', 'EXKLO', 'TPF0 TppReportrbExbrfAutoStopDataPipelineplExkloPrinterSetup.BinNameDefaultPrinterSetup.Docu
mentNameReportPrinterSetup.PaperNameA4
(210 x 297 mm)PrinterSetup.PrinterNameDefaultPrinterSetup.
mmMarginBottomÎPrinterSetup.mmMarginLeft˜:PrinterSetup.mmMarginRightÎPrinterSetup.mmMarginTopŠ4
PrinterSetup.mmPaperHeight(ˆ PrinterSetup.mmPaperWidthP4 PrinterSetup.PaperSize &Template.DatabaseSettings.DataPipelineplExbrfTemplate.DatabaseSettings.NameAANM3#
Template.DatabaseSettings.NameFieldBRFNR''Template.DatabaseSettings.TemplateFieldBRFTEKSTTemplate
.FileName!C:\Dev\Ex100\Layout\aanmaning.rtmTemplate.SaveTo
stDatabaseUnits
utMillimetersBeforePrintrbExbrfBeforePrint
DeviceTypeScreenOutlineSettings.CreateNode OutlineSettings.CreatePageNodes OutlineSettings.EnabledOutlineSettings.Visible TextSearchSettings.DefaultStringTextSearchSettings.EnabledLefthTophVersion7.03
mmColumnWidth DataPipelineNameplExklo
TppDetailBand
ppDetailBand1mmBottomOffset mmHeight¬mmPrintPosition TppDBTextFaktuurnummer1UserName
Faktuurnummer DataFieldKLOFAKNRDataPipelineplExkloFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style ParentDataPipelineTransparent DataPipelineNameplExklommHeight›mmLeft mmTop mmWidthZgBandType TppDBText
Faktuurdatum1UserNameFaktuurdatum DataField KLOVRKDATDataPipelineplExkloFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style ParentDataPipelineTransparent DataPipelineNameplExklommHeight›mmLeftchmmTop mmWidth(€ BandType TppDBTextFaktuurbedrag1UserName
Faktuurbedrag DataFieldKLOTOTFLDataPipelineplExklo
DisplayFormat$#,0.00;-$#,0.00Font.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style ParentDataPipelineTransparent DataPipelineNameplExklommHeight›mmLeft‹è mmTop mmWidthÁsBandType TppDBTextReeds_betaald1UserName
Reeds_betaald DataFieldKLOBETFLDataPipelineplExklo
DisplayFormat$#,0.00;-$#,0.00Font.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style ParentDataPipelineTransparent DataPipelineNameplExklommHeight›mmLeft«g mmTop mmWidthýzBandType TppVariableVARCOPENSTAANDSALDO1UserNameCOPENSTAANDSALDO CalcOrder DataType
dtCurrencyFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style mmHeight£mmLeftÔç mmTop mmWidthÞ´ BandType TppGroupppGroup2 BreakNameKLTNRDataPipelineplExkloOutlineSettings.CreateNode NewPage ResetPageNo UserNameGroup2mmNewColumnThreshold mmNewPageThreshold DataPipelineNameplExklo TppGroupHeaderBandppGroupHeaderBand2mmBottomOffset mmHeightª mmPrintPosition TppLabelppLabel1UserNameLabel1CaptionNEG NijkerkFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style Transparent mmHeightƒmmLeftmmTopO(mmWidthóZBandTypeGroupNo TppLabelppLabel2UserNameLabel2CaptionGildestraat 18Font.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style Transparent mmHeightƒmmLeftmmTopá9mmWidth.hBandTypeGroupNo TppLabelppLabel3UserNameLabel3CaptionTel. (033) 525 95 31Font.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style Transparent mmHeightƒmmLeftmmTop_mmWidth› BandTypeGroupNo TppLabelppLabel4UserNameLabel4CaptionABN: 12.365.4877Font.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size

Font.Style Transparent mmHeightàmmLeftmmTop~Š mmWidthÇpBandTypeGroupNo TppLabelppLabel5UserNameLabel5Caption6904 LW NijkerkFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style Transparent mmHeightƒmmLeftmmTop{LmmWidthUBandTypeGroupNo TppDBTextAdres1UserNameAdres DataField KLTSTRAATDataPipelineplExkltFont.CharsetDEFAULT_CHARSET
Font.ColorclWindowText Font.NameArial Font.Size
Font.Style ParentDataPipelineTransparent DataPipelineNameplExkltmmHeight›mmLeft‚

I could not reproduce the problem. Try to check the latest build of SDAC (4.50.0.35). If it does not help, send me the dump file by e-mail at sdac*crlab*com. Also specify the exact version of your client. You can see it in the Info sheet of TMSConnection Editor.

Hi

I have forwarded the latest dump file as asked by you to your email id.

Secondly, you may also try another copy, which we have produced just a little while back and is also giving the same type of error.

While trying to pin point the problem, I found out that it is ultimately being comming from OLEDBAccess (TOleDBConnection.Check), which intrun is called from DBACCESS unit (TCustomDASQL.InteranalExecute0 which is called from unit MSAccess (TMSSQL.InternalExecute) and so on. The exception message is as following:

"Incorrect syntax near 'TPF0 ......................................"

The definition of the table is as follows:

CREATE TABLE [dbo].[EXBRF](
[BRFNR] [varchar](5) NULL,
[BRFOMS] [varchar](30) NULL,
[BRFONDERW] [varchar](5) NULL,
[BRFTEKST] [text] NULL,
[ROWVERSN] [timestamp] NULL
)




AND THE CONTENTS OF THEN DUMP FILE ARE AS FOLLOWING:

-- Sdac version: 4.35.1.16
-- SQL Server server version: 09.00.3054
-- SQL Server client version: 08.00.1117
-- Script date 23/06/2008 17:42:10
-- ----------------------------------------------------------------------
-- Server: DIGITIGER\SQLEXPRESS
-- Database: Exist2



--
-- Dumping data for table EXBRF
--

TRUNCATE TABLE EXBRF;
INSERT INTO EXBRF(BRFNR, BRFOMS, BRFONDERW, BRFTEKST) VALUES ('AANM3', 'Aanmaning 30 dagen', 'EXKLO', 'TPF0 TppReportrbExbrfAutoStopDataPipelineplExkloPrinterSetup.BinNameDefaultPrinterSetup.DocumentNameReportPrinterSetup.PaperNameA4 (210 x 297 mm)PrinterSetup.PrinterNameDefaultPrinterSetup.mmMarginBottomÎPrinterSetup.mmMarginLeft˜:PrinterSetup.mmMarginRightÎPrinterSetup.mmMarginTopŠ4PrinterSetup.mmPaperHeight(ˆ



Thanking you once again in anticipation.