# Cannot have Database Connection for a project

**URL:** <https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647>\
**Category:** CloverDX Platform\
**Created:** [December 22, 2009, 12:00am UTC](https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647 "2009-12-22T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![evergreen](https://avatars.discourse-cdn.com/v4/letter/e/6de8d8/32.png) [@evergreen](https://forum.cloverdx.com/u/evergreen)\
**Post date:** [December 22, 2009, 12:00am UTC](https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647/1 "2009-12-22T00:00:00Z")

</div>

Hi,

I have several graphs used on a project.  
I need common database connections to be used for all the graphs.

This is because in case I need to change my database connections,I will have to edit in each and every graph.  
Instead I want to do this just at one place.  
Is there a way to achieve this?

Please find the attached screenshot error when I attempt to open a database connection in Navigator preview  
for the whole project.  
Thanks

- [databaseConn\_error.JPG](https://cdn.cloverdx.com/forum/10108%5F959413d480eef751511547839dbe1420/databaseConn%5Ferror.JPG)

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [December 22, 2009, 10:28am UTC](https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647/2 "2009-12-22T10:28:16Z")

</div>

Hello,  
how do you try to open the connection?  
See [External (Shared) Database Connections](http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/external-database-connections.html) part of manual for using the same connection with various graphs.

---

<div class="post-metadata">

**Author:** ![evergreen](https://avatars.discourse-cdn.com/v4/letter/e/6de8d8/32.png) [@evergreen](https://forum.cloverdx.com/u/evergreen)\
**Post date:** [December 22, 2009, 12:47pm UTC](https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647/3 "2009-12-22T12:47:39Z")

</div>

Hi ,

Creating External (Shared) Database Connections: I have followed the same steps as listed under this heading from the manual.  
This is when I am faced with the error screen I had attached previosly.  
Is there any other way I can handle this problem?

Thanks,  
Evergreen

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [December 22, 2009, 2:27pm UTC](https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647/4 "2009-12-22T14:27:51Z")

</div>

Hi,  
try to create internal connection and then externalize it. If it doesn’t help, you can create the cfg file manually an then linked such connection to your graph.

```auto
name=shirisha
threadSafeConnection=true
dbDriver=oracle.jdbc.driver.OracleDriver
dbURL=jdbc:oracle:thin:@10.253.150.225:1521:luminis
user=system
driverLibrary=file:${your_path}/ojdbc14.jar
password=test
jdbcSpecific=ORACLE

```

---

<div class="post-metadata">

**Author:** ![evergreen](https://avatars.discourse-cdn.com/v4/letter/e/6de8d8/32.png) [@evergreen](https://forum.cloverdx.com/u/evergreen)\
**Post date:** [December 23, 2009, 6:15am UTC](https://forum.cloverdx.com/t/cannot-have-database-connection-for-a-project/647/5 "2009-12-23T06:15:39Z")

</div>

Hi,

Creating a .cfg file and then linking the Externalized DB connection solved my problem.  
Thanks very much for the suggestion.  
Regards,  
Vinutha