How to connect to Oracle direct, without the SID

cbc700 · Post by **cbc700** » Wed 10 Nov 2010 00:58

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.

AlexP · Post by **AlexP** » Wed 10 Nov 2010 07:46

Hello,

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

cbc700 · Post by **cbc700** » Wed 01 Dec 2010 02:23

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.

AlexP · Post by **AlexP** » Wed 01 Dec 2010 09:15

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.

cbc700 · Post by **cbc700** » Wed 01 Dec 2010 09:51

Thank you. I look forward to that.

bork · Post by **bork** » Tue 21 Dec 2010 08:25

Hello

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