yup, that's exactly what I'm already doing, and the problem is, I always have to inject the arguments (port, sid, host) into that string. I don't know what's the cleaner solution or whether this is an oracle "obfuscated" identifier. Does this always have to be this way when identifying the database by SID? I ask you, who has clearly more years of experience in this subject.
2015-06-17 20:39 GMT+02:00 Jeremy Evans <[email protected]>: > On Wednesday, June 17, 2015 at 11:03:31 AM UTC-7, Tiago Cardoso wrote: >> >> exactly like that, that is the first argument of the oci8 client, the >> host portion. oci8 itself has no support for the :sid parameter, I guess. >> But I thought Sequel could build it. >> > > You could try: > > Sequel.oracle(:host=>"(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = > \"0.0.0.0\")(PORT = 1521))(CONNECT_DATA = (SID = \"SID101\")))") > > If that doesn't work, please post the exact OCI8.new code you are using. > If you are currently passing only a single argument to OCI8.new, the > difference may be because the oracle adapter passes 4 args to OCI8.new. > I'm certainly willing to consider an additional option to the oracle > adapter which specifies the arguments to pass exactly, for situations where > complete control is required. > > Thanks, > Jeremy > > -- > You received this message because you are subscribed to a topic in the > Google Groups "sequel-talk" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sequel-talk/3bXsesRRdpA/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sequel-talk. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
