Что мне нужно зделать чтобы законектится на remote oracle server ?
На локальный примерно так .. :
if (OCIEnvCreate(&env, OCI_DEFAULT, NULL, NULL, NULL, NULL, 0, NULL) ||
OCIHandleAlloc((dvoid *)env, (dvoid **)&err, OCI_HTYPE_ERROR, 0, NULL))
{
ecode = 0;
strncpy(ebuf, "Can't initialize OCI environment/handlers.", sizeof(ebuf));
return false;
}
if (OCIHandleAlloc((dvoid *)env, (dvoid **)&stmt, OCI_HTYPE_STMT, 0, NULL) ||
OCIHandleAlloc((dvoid *)env, (dvoid **)&serv, OCI_HTYPE_SERVER, 0, NULL) ||
OCIHandleAlloc((dvoid *)env, (dvoid **)&conn, OCI_HTYPE_SVCCTX, 0, NULL))
{
iae: InitError();
return false;
}
if (OCIServerAttach(serv, err, (OraText *)db.data(), db.size(), OCI_DEFAULT))
goto iae;
OCIAttrSet((dvoid *)conn, OCI_HTYPE_SVCCTX, (dvoid *)serv, 0, OCI_ATTR_SERVER, err);
OCIHandleAlloc((dvoid *)env, (dvoid **)&session, OCI_HTYPE_SESSION, 0, NULL);
OCIAttrSet((dvoid *)session, OCI_HTYPE_SESSION,
(dvoid *)login.data(), login.size(), OCI_ATTR_USERNAME, err);
OCIAttrSet((dvoid *)session, OCI_HTYPE_SESSION,
(dvoid *)passwd.data(), passwd.size(), OCI_ATTR_PASSWORD, err);
if (OCISessionBegin(conn, err, session, OCI_CRED_RDBMS, OCI_DEFAULT) != OCI_SUCCESS)
goto iae;