🚀 go-pugleaf

I am trying to create a table(dstTable) using batCopy mode with TBatchMove
component.

void TImportForm::Transfer( TTable *srcTable, TTable *dstTable, TBatchMode
mode )
{
     BatchMove->Source = srcTable;
     BatchMove->Destination = dstTable;
     BatchMove->Mode = mode;
     BatchMove->KeyViolTableName = Format( "Key_%s.db", OPENARRAY(TVarRec,
(srcTable->TableName)) );
     BatchMove->ProblemTableName = Format( "Prob_%s.db", OPENARRAY(TVarRec,
(srcTable->TableName)) );
     BatchMove->ChangedTableName = Format( "Changed_%s.db",
OPENARRAY(TVarRec, (srcTable->TableName)) );
     BatchMove->Execute();
}

The operation will fail with error
"Cannot modify the design of table 'MY_TABLE'.  It is in a read-only
database."
The ReadOnly property of the TDatabase component i am using is always set to
false.

The following are extracted from trace file provided by ODBC Data Source
Administrator. (DSMProj is my program name)

DSMProj         182-16f EXIT  SQLDriverConnectW  with return code 1
(SQL_SUCCESS_WITH_INFO)
  HDBC                032D16F8
  HWND                00000000
  WCHAR *             0x1F7D8B70 [      -3] "******\ 0"
  SWORD                       -3
  WCHAR *             0x1F7D8B70
  SWORD                        8
  SWORD *             0x00000000
  UWORD                        0 <SQL_DRIVER_NOPROMPT>

  DIAG [01S00] [Microsoft][ODBC Text Driver]Invalid connection string
attribute DATABASE (8)

  DIAG [01S00] [Microsoft][ODBC Text Driver]Invalid connection string
attribute DATABASE (8)

  DIAG [01S00] [Microsoft][ODBC Text Driver]Invalid connection string
attribute DATABASE (8)

  DIAG [01S00] [Microsoft][ODBC Text Driver]Invalid connection string
attribute DATABASE (8)
...
...
...
DSMProj         182-16f ENTER SQLGetInfoW
  HDBC                032D16F8
  UWORD                       25 <SQL_DATA_SOURCE_READ_ONLY>
  PTR                 0x032D1E28
  SWORD                      512
  SWORD *             0x0012F446

...
...
...

DSMProj         182-5e EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
  HSTMT               032D2148
  UCHAR *             0x01AED96C [      -3] " CREATE TABLE `MY_TABLE`
 `RETURN_TYPE` CHAR( 1),`DESCRIPTION` CHAR( 60) ) \ 0"
  SDWORD                    -3

  DIAG [42000] [Microsoft][ODBC Text Driver] Cannot modify the design of
table 'MY_TABLE'.  It is in a read-only database. (-1809)


--
Phua Ooi Ewe
Software Engineer
Knowledge Engineering Pte Ltd