Book a Demo

Author Topic: Database schema import fails  (Read 5848 times)

Aaron  NIH

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Database schema import fails
« on: September 16, 2009, 11:20:59 pm »
Greetings,

I am having no success importing the database schema from Oracle 10g using either Microsof ODBC for Oracle driver or Oracle ODBC driver. I get "The connection could not be made using the file data source paramaters entered...." with both. Needless to say, I fill in the same login values I use for other clients, for example, PLSQL Developer.
A baffling thing is that the sqlnet.log generated in the data sources directory has values for SID, USER etc which are totally different from those I provided.
Anyy suggestion how to deal with this? Any help would be greatly appreciated.

Regards,

Aaron

David

  • EA User
  • **
  • Posts: 30
  • Karma: +0/-0
    • View Profile
Re: Database schema import fails
« Reply #1 on: September 19, 2009, 12:04:47 am »
When I moved from .eap to an ORACLE repository I had to install the Oracle 10g Client on my local PC before I could obtain a stable connection.
I beleive you need to install the Oracle 10g Client and use the Oracle ODBC Driver 10.2.0.1.0.
Then next time you connect to your Oracle repository use this ODBC driver before begining your schema import.

Hope This Helps

David

Aaron  NIH

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Database schema import fails
« Reply #2 on: September 19, 2009, 12:15:04 am »
I did that, though I spoke to someone successfully using MS ODBC for Oracle. It seems that I got just a bit further and can connect, but the import still fails.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Database schema import fails
« Reply #3 on: September 19, 2009, 02:27:06 am »
EA can be installed on an oracle database, and there are some pages on the website that give you some more details on which drivers etc to use.
I remember that it was not as easy as it should have been.
I don't know, but maybe if you use the same drivers as suggested to run EA on you might have more success.
Otherwise you can still send in a bug report. Sparx Support is quite responsive to those, and you'll probably get a decent answer within a couple of days.
Oh, and remember to post the solution on this topic, if you find it.

Geert