Re: OCI - Connecting to Database

From: <arivlin_at_my-deja.com>
Date: Thu, 06 Jan 2000 23:25:19 GMT
Message-ID: <85388i$kdu$1@nnrp1.deja.com>

Hi,
Here is my Connect function. It sets acServiceName passed as a parameter ( the one matching tnsnames.ora)

//--------------------------------------------------------
//
// NAME : TQueryClass::Connect
//
// DESCRIPTION : Establishes connection to the database
//

// arivlin

//----------------------------------------------------------
int TQueryClass::Connect ( const char * acUserName,
                  const char * acPassword,
                  const char * acServiceName )

{

char acSQLFootPrint [ 256];

sprintf ( acSQLFootPrint,

              "/* Program started.\r\n\r\n User %s is connecting
*/\r\n\r\n     ",
              acUserName );

    m_prSQLQueryFile->Write ( acSQLFootPrint,
        strlen ( acSQLFootPrint ) - 4 );

Initalize environment */ OCIInitialize ((ub4)OCI_THREADED | OCI_OBJECT, (dvoid *) 0, (dvoid * (*) (dvoid *, UINT)) 0, (dvoid * (*) (dvoid *, dvoid *, UINT)) 0, (void (*) (dvoid *, dvoid *)) 0);

OCIEnvInit (&or8EnvHandle, OCI_DEFAULT, 0, (dvoid **) 0);

Initalize Connection */ if (oci8Error ( OCIHandleAlloc ( (dvoid *) or8EnvHandle, (dvoid **) &or8SrvrHandle, (ub4)OCI_HTYPE_SERVER, 0, (PDV *)0) )) return OCI8_INITIALIZED;

	if (oci8Error (OCIHandleAlloc ((dvoid *) or8EnvHandle,
				(dvoid * *) &or8SrcHandle,
OCI_HTYPE_SVCCTX,
				0, (dvoid * *) 0)))
		return OCI8_INITIALIZED;

	if (oci8Error (OCIHandleAlloc ((dvoid *) or8EnvHandle,
				(dvoid * *) &or8ErrorHandle,
OCI_HTYPE_ERROR,
				0, (dvoid * *) 0)))
		return OCI8_INITIALIZED;

Make Connection */ if (oci8Error (OCIServerAttach (or8SrvrHandle, or8ErrorHandle, (unsigned char *) acServiceName, strlen (acServiceName), OCI_DEFAULT))) return OCI8_INITIALIZED;

if (oci8Error (OCIAttrSet ((dvoid *) or8SrcHandle, OCI_HTYPE_SVCCTX,
(dvoid *) or8SrvrHandle, (ub4) 0,
OCI_ATTR_SERVER,

				or8ErrorHandle)))
		return OCI8_SERVER_ATTACHED;

Set up user session */ if (oci8Error (OCIHandleAlloc ((dvoid *) or8EnvHandle, (dvoid * *) &or8UsrHandle, OCI_HTYPE_SESSION, 0, (dvoid * *) 0))) return OCI8_SERVER_ATTACHED;

if (oci8Error (OCIAttrSet ((dvoid *) or8UsrHandle, OCI_HTYPE_SESSION,
(dvoid *) acUserName, (ub4) strlen
(acUserName),

				OCI_ATTR_USERNAME, or8ErrorHandle)))
		return OCI8_SERVER_ATTACHED;

	if (oci8Error (OCIAttrSet ((dvoid *) or8UsrHandle,
OCI_HTYPE_SESSION,
				(dvoid *) acPassword, (ub4) strlen
(acPassword),
				OCI_ATTR_PASSWORD, or8ErrorHandle)))
		return OCI8_SERVER_ATTACHED;

	if (oci8Error (OCISessionBegin (or8SrcHandle, or8ErrorHandle,
				or8UsrHandle, OCI_CRED_RDBMS,
OCI_DEFAULT)))
		return OCI8_SERVER_ATTACHED;

	if (oci8Error (OCIAttrSet ((dvoid *) or8SrcHandle,
OCI_HTYPE_SVCCTX,
				(dvoid *) or8UsrHandle, (ub4) 0,
OCI_ATTR_SESSION,
				or8ErrorHandle)))
		return OCI8_SESSION_BEGAN;

Successful connect */ return true; }

In article <17599f0b.0f3d7f99_at_usw-ex0107-042.remarq.com>, Harish <hdeshpandeNOhdSPAM_at_carlson.com.invalid> wrote:

> Hi,
>
>    I have developed a client/server application using OCI on NT 4.0.
> When I converted this application to an NT service I found that it is
> connecting to a different database.  I do not know how it is

connecting

> to a different database as the connect string is the same.  One way to
> overcome this problem is to supply the connect description in the
> connect call it is possible.  Can one any of you please provide me

with

> a sample for this.  Oracle documentation does not have a sample for
> this.
>
>    My current connect string is as follows: uname/passwd_at_dbname
>
>    I want to know if this can be changed to: uname/passwd@(x) where x
> is similar to an entry in 'tnsname.ora'.
>
>    Thanks in advance for your time and help.
>
> Harish
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion

Network *
> The fastest and easiest way to search and participate in Usenet - Free!
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 17:25:19 CST