Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: Aaron NIH 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
-
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
-
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.
-
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