Local connection in ENSEMBLE with Oracle DSN doesn't work

[Arturo Henry Torres Zenteno]

Hello everyone

I have created a system DSN with the controler ORACLE in XE, the test
connection of windows of this DSN works ok, but the connection in
ENSEMBLE with this DSN doesn't work. Too i have test the connection
with a JAVA application and with TOAD i don't have any problem to
connect with this DB.

Anyone can help me to solve the problem??? Thank you in advanced.
Regards,
Arturo

[Neerav Verma]

What's the error you getting?

Have you specificied the credentials needed for the dsn?

Thank You,

Neerav Verma
http://www.linkedin.com/in/vneerav
------------------------------------------------------
Ted Turner  - "Sports is like a war without the killing."

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com
To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en

[Arturo Henry Torres Zenteno]

Hi Neerav,

The error is the following:

----------------------

ERROR <Ens>ErrOutConnectFailed: ODBC Conexión fallida para 'CORAL2_BD_LOCAL'/'PORTAL_ID' con error ERROR #6022: Gateway: DSN/User Connect falló.

ERROR <Ens>ErrFailureTimeout: FailureTimeout de 15 segundos superado en Operaciones.BBDDOperaciones

---------------------

Yes, we do. We specificied the credentials.  

We have two identical databases on two different servers (A and B). In B also is installed the

Ensemble server. When in Ensemble is configured to connect with database on server A, it works. 

However, when configuring the DSN for database on same server (B), it not work.

Regards,

Arturo.

[Neerav Verma]

There certainly is a configuration issue here

Did you create the dsn on same machine for the db, does that connect?

I would verify the IP address, port etc

I hope you are not trying to use localhost for local db

Thank You,

Neerav Verma
http://www.linkedin.com/in/vneerav
------------------------------------------------------

Marie von Ebner-Eschenbach  - "Even a stopped clock is right twice a day."

[Neerav Verma]

If nothing is evident than you can always ask your network guy to see if an attempt was made to connect and at what point it failed

They have the information in the network trace 

Thank You,

Neerav Verma
http://www.linkedin.com/in/vneerav
------------------------------------------------------

Mike Ditka  - "If God had wanted man to play soccer, he wouldn't have given us arms."

[Arturo Henry Torres Zenteno]

Thank you Neerav!, the problem was at tnsname, the host was changed (localhost to ip).