Problem with connection to repository

[JarekWarsaw72]

Hi,
I have got a problem with connection to Oracle repository.
I have installed OLEDB Oracle driver in Win32(XP) but I can not see this driver on the EA database driver list.

I have got the Oracle OLE DB 9.0.1.0.1 and EA 7.0.815

Do you know how to solve this problem.

[«Midnight»]

I think it really should show up. Check that you installed the driver for use by all accounts, not just administrators or the account from which you did the installation.

If that checks out, try creating a machine data source from outside of EA using either the Windows dialogs or any Oracle (or third party) tools. Just point this to any Oracle database you can normally connect to. Then try to use this data source as a destination for EA.

[For the above, I suggest you try to connect to the data source for ODBC import of DDL. EA might react strangely if you point to a 'random' schema as a repository. The important thing here is to determine if EA can use the driver at all, not to start a project (yet).]

If any of the above work, you should have more information on what to tweak.

David

[hd]

One way to test your connection to Oracle outside of ea is to create an empty text file and give it the extension .udl.

Double-clicking this file will bring up Microsoft's Data Link Properties dialog, from which you can check your connection.

If this connection is OK, there should be no reason why EA will not connect.

Make sure you have EA's schema in the Oracle repository, and transfer an eap file to it before you connect. Performing the project transfer will, in any case, verify your connection.

[«Midnight»]

And make sure you have permissions for the schema. I don't know exactly what you'd need to read a schema (to reverse engineer it for example), but for a repository you'd need write permissions at the very least.

[hd]

In addition to the usual CRUD permissions, you will also need permission to CREATE SEQUENCE when transferring a project to Oracle. Once the project is transferred, the CREATE SEQUENCE permission is not needed.