ETL and Data Integration tools - Modern ETL software for everyone

Using ELT Processor Pro. 4.2.1.1

I have tried to create a couple of new projects, and when I do so the following error appears:

You cannon add or change a record because a related record is required in table 'Object Types'.

the project shows up blank.

If I close ELT and then reopen, the SMTP and POP are not available under Connections.

Delete the projects you have just created

That run following SQL against the repository

INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (348,'SQLite')
GO
INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (349,'SQLite Connection')
GO
Insert into OBJECTS_TREE
(OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select
-OBJECTS_TREE.OBJECT_ID as OBJECT_ID,
OBJECTS_TREE.OBJECT_ID as PARENT_ID,
'SQLite' as NAME,
348 as OBJECT_TYPE
From
OBJECTS_TREE
Where
OBJECTS_TREE.OBJECT_TYPE = 300

Peter

How do I run the SQL against the repository?

Also, I have a number of projects already in the repository. Is this going to create a problem with the existing projects?

Make a backup of the repository

Create new connection and point it to the repository.
Open SQL editor. (view =>SQL)
Select connection
Run the script

Peter

I need more inforamtion about this.

1) I tried to use ODBC, selected the access database option, and selected the repository.

After that is all done, An error message appears "Data Provider or other service returned an E_FAIL status.

That is as far as I can get.

Also, I have tried to create a new project on another entirely seperate machine running another version of ELT PRocessor Pro, and the same bug appears when creating a new project so I think this is a bug introduced in your latest version.

Is there a chance that you placed the standard version in the PRO directory for download, and that is why SMTP, FTP, and POP weren't included when I upgraded to the latest version?