Everybody is good, now my situation is such, made a c/s projects, the need to connect to the database, but customers there do not want to install the Oracle client installed every computer, just want to install Oracle server in the server, and client and server to interact,
Want to ask next everybody have what good middleware technology is recommended, (server system is Linux). Thank you

CodePudding user response:

Ado controls must be installed the client,
A odac controls can be not to install the client, you can try

CodePudding user response:

Only need several related oracle DLL is ok, don't need to install the oracle client

Also has the oracle client lite version online

CodePudding user response:

refer to the second floor seleron response:

only need several related oracle DLL is ok, don't need to install the oracle client

Online also has the oracle client lite version

One thousand customers there is a part of the machine have been installed Oracle, it will lead to conflict,,,

CodePudding user response:

reference 1st floor ksrsoft response:

ado controls must be installed the client,
A odac controls can be not to install the client, you can try

Is currently selected using ADO, can't,

CodePudding user response:

According to your actual situation, may use three layers will be better, but will increase the workload of some coding;

CodePudding user response:

ODAD host need not?

CodePudding user response:

reference 5 floor zhuchengchuan reply:

according to your actual situation, may use three layers will be better, but will increase the workload of some coding;

With three layers? To solve the problem?

CodePudding user response:

refer to 6th floor ksrsoft response:

ODAD I don't have to?

Didn't heard of, also can't search? To know the details

CodePudding user response:

ADO, upstairs with odac can not install the client

CodePudding user response:

I'm in the installation of Oracle client, extract the configuration after several system parameters is ok,

CodePudding user response:

references 9 f lch0422 response:

ADO, upstairs with odac can not install the client

Do you have any related middleware technology can solve this problem, I now know how datasnap, but apparently just for win32, Linux in not,

CodePudding user response:

reference vincent_ling reply: 3/f

Quote: refer to the second floor seleron response:

Only need several related oracle DLL is ok, don't need to install the oracle client

Online also has the oracle client lite version

One thousand customers there is a part of the machine have been installed Oracle, it will lead to conflict,,,

Does not lead to conflict

CodePudding user response:

To connect to a remote database still use to ask?

CodePudding user response:

Oracle Java connection doesn't require that the client, but requires a JDBC driver
If it is the.net client, can be to write a server program that use webservice or other way for the client to provide database access functions

CodePudding user response:

Client is a Windows system, only in the development use odac when the control is ok, odac can need not install oracle client, directly connected to the oracle server,

CodePudding user response:

DBExpress seems to need only OCI. DLL is ok, but if you insist on using ADO as if really no way out

CodePudding user response:

11 references vincent_ling response:

Quote: references 9 f lch0422 response:

ADO, upstairs with odac can not install the client

Do you have any related middleware technology can solve this problem, I now know how datasnap, but apparently just for win32, Linux is not used, the

Linux? Then you estimate will not be able to use the DELPHI, Lazacus seems to have a version

CodePudding user response:

The Direct Oracle Access component search

CodePudding user response:

http://blog.csdn.net/pcwe2002/article/details/52527782
Can directly use satrda, modify the connection string can, do not need to install the client

CodePudding user response:

I use the odac
The need of other oci. DLL and a variety of configurations, said more are tears,

CodePudding user response:

A typical three layer structure, use DataSnap.

CodePudding user response:

reference sxper 20 floor response:

I use odac
The need of other oci. DLL and a variety of configurations, said more are tears,

I want to ask how to use odac, local database applications I get other machine can not run, without installing Oracle service client odac can solve, I now is also the Oracle of the ADO connection