Re: Anyone tried this with a remote database?

On Thu, Sep 06, 2001 at 01:07:38PM -0500, John Gorkos wrote:
> 
> > Has anyone tried to build Oracle-OCI with a remote database? I'm running
> > out of ideas; I keep getting this error on test 13, which doesn't make
> > any sense:
> 
> Here's a connect line that works for me:
> 
> my @server_buf_len = oci_buf_len($sid);
> $status = OCIServerAttach($svrhp, $errhp, @server_buf_len, OCI_DEFAULT );
> warn get_oci_error($errhp, $status) unless $status == OCI_SUCCESS;
> 
> $sid is straight from my tnsnames.ora

The OCI docs say:

: Specifies the database (server) to use. This parameter points to a
: character string which specifies a connect string or a service point.
: If the connect string is NULL, then this call attaches to the default
: host.

So that change seems reasonable.

(Please remember to tell me ASAP about any changes you need to make so I
can work them into future versions.)

Thanks.

Tim.