1

Topic: Windows client for Oracle - A Visual Studio 2015

Now I select what connection to Oraklu (11 and 12) to use by operation from Windows (Server 2003 x32)
The program I write on a C ++ a Visual Studio 2015, it will be necessary to cause two procedures:
- One for obtaining blob - a file on it id
- Another - for saving blob - a file c it id
The connection type, checked up, plus, a minus
atldbcli.h, yes, works on Server 2003 x32 and any setting and adjustments it is not required, 1 - deprecated
,,,2 - I while did not understand as to work with  as with parameters of procedures
oci, no,-?,-?
occi.h, yes, procedures work with  as it is necessary, 1 - on Server 2003 x32 yet did not check
,,,2 - at me on Win7 the program suddenly "" in the end of operation - if it debug the assembly.
,,,3 - release the assembly "" already at start (I traced - at loading of one of libraries  the client and try. catch in main is does not catch)
,,,Possibly the problem will be solved at downloading of the correct version ODT (yet did not try but here write about complexities )
ocilib.h, yes, procedures work with  as it is necessary, on Server 2003 x32 yet did not check
.NET, the C ++ is not present / C# - yes, From the code on C# - is checked up - works as it is necessary on Server 2003 x32, On a C ++ yet did not check but very much it would not be desirable to anchor the program to dotnet-frejmvoku
What recommendations will be?
There can be I missed any method of connection and absolutely it did not consider?
Yes, on pure oci yet did not try, whether it is necessary to waste time?
By the current moment it is pleasant to me ocilib.h more - works stablly;
But it is not assured of correctness of this choice - what dependences or a rake lie on a way of such decision?
On direct system Server 2003 x32 now there is 11 client ;
Also it would not be desirable something to install still there in addition.

2

Re: Windows client for Oracle - A Visual Studio 2015

ART-CODE wrote:

Yes, on pure oci yet did not try, whether it is necessary to waste time?

Yes. It is the most stable variant.

3

Re: Windows client for Oracle - A Visual Studio 2015

Dimitry Sibiryakov;
Thanks, I will try.

4

Re: Windows client for Oracle - A Visual Studio 2015

ART-CODE;
Read note release on compatibility of the version of the client with the version of OS with the version of the server and with version VS
I doubt that vs2015 it is supported 11 by the client

5

Re: Windows client for Oracle - A Visual Studio 2015

Still you can try odbc and OLEDB

6

Re: Windows client for Oracle - A Visual Studio 2015

ART-CODE wrote:

By the current moment it is pleasant to me ocilib.h more - works stablly;
But it is not assured of correctness of this choice - what dependences or a rake lie on a way of such decision?
On direct system Server 2003 x32 now there is 11 client ;
Also it would not be desirable something to install still there in addition.

ocilib.h It https://vrogier.github.io/ocilib/download/?
And what there dependences? It is simple OSS library, do not want to carry with itself something -  statically, it can and without the.dll
And a rake there quickly enough (within the limits of one week normally) dares the author.
The unique minus it that it there one developer, but the code is rather competently written and as required to accompany him does not make any problems.
To work directly with OCI is a destiny of masochists, at all IMHO
By the way is still https://github.com/oracle/odpi
This library too "one author", but it already has the official status (i.e. it is supported from Oracle) and is applied in, , node.js, python and somewhere else.
To me did not approach, because in it there is no support direct path API though regarding support NUMBER it will be, than OCILIB more abruptly

7

Re: Windows client for Oracle - A Visual Studio 2015

Siemargl wrote:

Still you can try odbc and OLEDB

About yes! At once it is visible the Expert from Capital letter!

8

Re: Windows client for Oracle - A Visual Studio 2015

dbpatch;
You advise left , and I that go officially with the client

9

Re: Windows client for Oracle - A Visual Studio 2015

Siemargl wrote:

dbpatch;
You advise left , and I that go officially with the client

ODPI too the left?
What?

10

Re: Windows client for Oracle - A Visual Studio 2015

Thanks, read about ODPI - very interesting, I will try, if I will be in time.
Tested operation OCILIB on a direct system - all works.
I think that or I will peep in it how to work with OCI;
Or  it in application.
(Simply, appearance in the project of alternative library to me will be difficult for coordinating, bureaucracy.)

11

Re: Windows client for Oracle - A Visual Studio 2015

ART-CODE wrote:

Now I select what connection to Oraklu (11 and 12) to use by operation from Windows (Server 2003 x32)
The program I write on a C ++ a Visual Studio 2015, it will be necessary to cause two procedures:

Somehow it here all:

wrote:

at me on Win7 the program suddenly "" in the end of operation - if it debug the assembly.
3 - release the assembly "" already at start (I traced - at loading of one of libraries  the client and try. catch in main is does not catch)

Says about that you did not master something...
I to that you should understand at first, and then to make the decision already.

12

Re: Windows client for Oracle - A Visual Studio 2015

ART-CODE wrote:

Thanks, read about ODPI - very interesting, I will try, if I will be in time.
Tested operation OCILIB on a direct system - all works.
I think that or I will peep in it how to work with OCI;
Or  it in application.
(Simply, appearance in the project of alternative library to me will be difficult for coordinating, bureaucracy.)

OCILIB has no exterior dependences, except most OCI, it is thus real ,
Also works on any With exotic in the form of the compiler, i.e. there there is simply nothing to coordinate - the binding is not present to what.
To pick out OCI calls there it is problematic, the author widely uses the generalized programming by macroes (by the way,
Technics of a C of coding at it very good, even shining).
If it is necessary to look as to work with OCI directly - that it is necessary to look in the Oracle demos, there a separate disk examples it is delivered on otn.
Though examples very much... We tell so... The scanty.
On the other hand - in OCILIB there are also the assumptions, in a part error handling though if to work from a C ++ through OCILIB ++, problems
Just to be and should not, unlike direct calls OCI or OCILIB (where is not present and cannot be exceptions).
In general I strongly would think before to start to write on pure OCI - cost of support of this all and entrance to a subject can be too high.