FAQ: Deploying a Direct Oracle Access application
- Thread starter faq
- Start date
As far as Direct Oracle Access is concerned you don't need to distribute any other files than your application's executable. Your application requires a properly configured SQL*Net or Net8. If you are using any Net8 specific objects (TLOBLocator, TOracleObject and TOracleReference), your application requires Net8. You cannot distribute SQL*Net or Net8 with your application, just list it as a requirement.
russian_lord
Member
This is so ridiculous! You have a nice set of components , but how stupid are we going to look when we ask our 1000 users to install the SQL*Net ? You must be kidding. You have to include them somehow in the package or atleast have some instructions of easy deployment. I'm not sure if I'm going to use your components in the future.
Vic.
Vic.
F.Hinlopen
Member²
There is very little alternative. If you want to talk to a database (any database, not just Oracle) you need a client. This has nothing to do with DOA. This would have been true if you had used the BDE or ADO, in which case you would have had even more installation woes, and for the future, all kinds of potential versioning problems. If you don't want a client, use Java and JDBC (in which case you will have a client, but packaged into your app, and miserable performance to boot).
Allround Automations cannot package or distribute Oracle clients for the simple reason that they don't know what database version you're working with, apart from the fact that it would probably be illegal.
The install is simple enough, but depends a bit on the Oracle version you're using. Seeing the number of users you're talking about, you must have an IT-department capable of doing this. As a matter of fact, I am somewhat surprised that your IT-department has allowed a database into the organization without considering the deployment and maintenance issues involved.
Finally, a few threads back there were some posts concerning bypassing the Oracle client. This is possible, but opens up a whole new set of issues. Security is one of them, but I can think of a lot more.
You could also consider multi-tier solutions. DOA has a neat little 3-tier demo.
------------------
Frans
Allround Automations cannot package or distribute Oracle clients for the simple reason that they don't know what database version you're working with, apart from the fact that it would probably be illegal.
The install is simple enough, but depends a bit on the Oracle version you're using. Seeing the number of users you're talking about, you must have an IT-department capable of doing this. As a matter of fact, I am somewhat surprised that your IT-department has allowed a database into the organization without considering the deployment and maintenance issues involved.
Finally, a few threads back there were some posts concerning bypassing the Oracle client. This is possible, but opens up a whole new set of issues. Security is one of them, but I can think of a lot more.
You could also consider multi-tier solutions. DOA has a neat little 3-tier demo.
------------------
Frans
If you have 1000 users (in the same company I assume), then you should install SQL*Net or Net8 once on a file server. You should probably do the same with your application. Installing Net8 and your application 1000 times would indeed be ridiculous.
If these 1000 are not in the same company, then you cannot assume that you know what Net8 version you should distribute. You are probably not even entitled to distribute it.
------------------
Marco Kalter
Allround Automations
If these 1000 are not in the same company, then you cannot assume that you know what Net8 version you should distribute. You are probably not even entitled to distribute it.
------------------
Marco Kalter
Allround Automations
Similar threads
- Discussion
