Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: t0m4tit0 on September 25, 2018, 04:49:24 pm

Title: How to configure ODBC conection for Oracle DB
Post by: t0m4tit0 on September 25, 2018, 04:49:24 pm

Hi Experts!!

I try to connect my project to a Oracle DB but y can´t.

We have EA (Enterprise). Our DB is Oracle 11g.

The problem:
- I can´t configure the ODBC driver in windows but many reasons:
In USER DSN page:
I select "Microsoft ODBC for Oracle" and clic in "Add". I dont know how to fill the "SERVER" field...

Title: Re: How to configure ODBC conection for Oracle DB
Post by: Arshad on September 25, 2018, 08:43:54 pm

Quote from: t0m4tit0 on September 25, 2018, 04:49:24 pm

I select "Microsoft ODBC for Oracle" and clic in "Add". I dont know how to fill the "SERVER" field...

Hi t0m4tit0

You need to install oracle ODBC drivers and need to configure it by selecting the installed drivers . Please find the downloads here. (http://www.oracle.com/partners/campaign/utilsoft-086879.html)
http://www.oracle.com/partners/campaign/utilsoft-086879.html



HTH
Arshad

Title: Re: How to configure ODBC conection for Oracle DB
Post by: hd on September 26, 2018, 07:39:29 am

Use the OLE DB driver - you'll find it's quicker than the ODBC driver...
http://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_repository/oracle_data_reposity_ole_db.html (http://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_repository/oracle_data_reposity_ole_db.html)