UDS connection for Oracle DB

[Former Member]

Hello,

In UDS (4.0.310), I need to create Oracle database connection which I will be using in xmii to extract data. I tried creating UDS instance with following params:

1. Instance name -

---

> TEST

2. Server type -

---

>xMII OLE DB UDS

3. POR -

---

> 1531 (any port number ?)

I suppose after this It required a connection string and I am not sure what is to be given, please help.

Thanks,

John

[Former Member]

You set up your Oracle DB connection by following the path 'xMII Menu -> Data Services -> Data Servers -> New'.

Regards,

Chanti.

[Former Member]

thanks Chanti, but i want to connect xMII via UDS.

[Former Member]

Whats the advantage of doing so?

[jcgood25]

You should be connecting to Oracle via JDBC. Using a UDS through OleDB adds unecessary layers when the native JDBC driver is readily available.