|
| Iniciado por guest, 20,nov. 2017 16:16 - 6 respuestas |
| |
| | | |
|
| |
| Publicado el 20,noviembre 2017 - 16:16 |
Hi friends,
I have a customer who wants to have Direct Access for Oracle. But this is a cluster, not a single server. How is Direct Access to be installed there? PC Soft says, that each and every physical or virtual server is to be equipped with Direct Access. How do the servers of a cluster talk to each other then? Via Direct Access? If you know how that should be done then please, shed some light on it! Thank you! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,noviembre 2017 - 16:35 |
Hi Guenter,
it seems to me that :
- the direct access is installed with the client program, not the server, and therefore has nothing to do with the cluster/no cluster problem
- a cluster is a system designed to SHOW each client ONE server, while in fact a cluster is working in the background, so the direct access would only talk to one server, and all the servers of the cluster would talk to each other as they usually do, without any link to the direct access
So, if I'm not mistaken, and except if pcsoft has a direct access for oracle cluster edition in their price list, there shouldn't be any difference for you
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,noviembre 2017 - 16:55 |
Hi Fabrice,
the description of the D/A for Oracle says:
WINDEV is linked to ORACLE by ODBC, by OLE DB, but also and above all via «Native Connectors» which is fast, powerful and highly efficient. All the functions of the environment are available. Installation is extremely simple.
=> You need one license per server.
=> An unlimited number of stations can access a server.
Suspiciously, there's no word about clusters, it's just about "servers". |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,noviembre 2017 - 20:48 |
Guenter
Yeap, I used to have native oracle driver but now have native sqlServer64/32 and progress (32-bit only) native and they run fast. Native driver is not pcSoft product and it's expensive.
It should come with 64/32 bit native latest version + all previous windev version.
Give it a shot.
HTH
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,noviembre 2017 - 07:23 |
Hi kingdr,
thank you for your tipps! We cannot change their database system, it's a big-big German bank. The most pressing problem is: can we use Native Access to access their Server clusters or do we have to use OLE DB instead? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,noviembre 2017 - 10:55 |
You can use native access.
Native access is installed at the client level, just set your TNSNAMES.ORA as you normally do to access your cluster and you can connect.
You need to have oracle .net or oracle instantclient installed on your client machine to connect to the oracle database.
The only problem with the cluster option is commercial, as far as I know you should buy a license for each phisical server, you don't need to install anything at the server level. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,noviembre 2017 - 12:43 |
| Hi Paulo, thanks a lot for this information!! |
| |
| |
| | | |
|
| | | | |
| | |
|