Troubleshooting

During installation, the Sybase ETL installer creates an initial set of data sources. If these repository data sources are lost for any reason, Sybase ETL does not open until you restore them. To restore the initial set of ODBC data sources of the demo repository:

1. Configure the ODBC user data source.

   1. Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).

   2. Click Add.

   3. Select Microsoft Access Driver from the list. Click Finish.

   4. In the Data Source Name field, enter DEMO_Repository.

   5. Select the IQETLDEMO_REP.MDB database from the Demodata folder of the installation directory. Click OK.

2. Set up the repository connection in the Repository Logon window:

   • Select File | Open Repository to open the Repository Logon window.

   • Select Repository from the Connection list and choose one of the these:

     • Edit

     • Add and enter a name for the connection

   • Select ODBC from the Interface list.

   • Select DEMO_Repository from the Host list.

   • Click Save.

3. Configure the additional ODBC user data sources required by the projects in the demo repository:

   • Driver – Microsoft Access

   • Name – ETLDEMO_DWH; Database – DEMO_DWH.MDB

   • Name – ETLDEMO_GER; Database – DEMO_GER.MDB

   • Name – ETLDEMO_US; Database – DEMO_US.MDB

     The database files for these user data sources are also located in the Demodata folder of the installation directory.