Devart Forums

I'm being told that with the address, port and service name, I should be able to get UniDAC to get to an Oracle 11G database. Is this the case? If so, how is this done? I don't see a property for the service name, and trying a server syntax such as "address:port/service" does not work either.

Is there a way to do this? Thanks.

Hello,

To connect in direct mode you should use the following syntax: : Server := Host:Port:SID

Thank you. Yes, I realize this is the way to do it if one has the SID. I'm asking if you don't have the SID but do have the serivce name.

Thanks.

Hello,

You can connect to Oracle using Service Name only if Service Name is the same as SID.
Now we don't support the possibility to connect using Service Name if it differs from the SID.
We plan to add this feature in one of the next versions.

Thank you. I look forward to that.

Hello

We added a connection in the Direct mode with using Service Name. It will be available in the next ODAC and UniDAC builds.