Quote:> If we want to DEPLOY our installation package into another who does not
has
> Oracle Client installet on it, How do we package the oracle client
Sorry, I don't know how to include the Oracle client in a distribution disk.
I have only ever used it in-house.
Quote:>or any
> other thing to make the computer able to comunicate with Oracle Server?
The other option to client side installs is to use something like RDS. This
requires a web server installed on the network hosting Oracle. The web
server RDS service will handle calls between oracle and the remote ADO
clients. This would require you to redesign your application since ADO and
RDS force you to use Client-Side cursors and Batch-Optimistic locking, you
also lose the ADO Connection Object (and transaction method). If these
features do not suit you, then continue with your current plan of
distributing the Oracle client. If on the other hand you are using client
side cursors and batch optimistic locking, your application will be able to
use RDS. This is just another option, and I would only pursue it if
distributing the client installation was something you had to really avoid.
--
Michael Collier
www.adoanywhere.com
ADO Inspection Tools
--
> I use string:
> "Driver={Microsoft ODBC for Oracle};
> Server=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
> SERV1)(PORT = 1524))) (CONNECT_DATA = (SID = MYSID)));
> UID=myuser;
> PWD=mypass"
> Its running (only on the server with Oracle Client installed).
> If we want to DEPLOY our installation package into another who does not
has
> Oracle Client installet on it, How do we package the oracle client, or any
> other thing to make the computer able to comunicate with Oracle Server?
> thanks in adv.
> reg.
> josh
> > It is probably too late now... if you need to connect to servers without
> the
> > client side installations, and you don't mind using client side cursor
> > locations, you can use remote services such as RDS which require the
extra
> > installation on the server instead.
> > This is handy if you are deploying an application that needs a small
> > download size (or whatever your reason may be).
> > Hope this helps in the future.
> > --
> > Michael Collier
> > www.adoanywhere.com
> > ADO Inspection Tools
> > --
> > > He, please help...
> > > I create an application to access Oracle Database:
> > > Host: MYORADB1
> > > IP: 10.10.10.5
> > > Port: 1524, instead the default 1521
> > > User: myuser
> > > Pass: mypass
> > > I have Oracle Client on my PC and the server configuration already
added
> > to
> > > my Service Name: SERV1,
> > > so I create connection string:
> > > "Driver={Microsoft ODBC for
Oracle};SERVER=SERV1;UID=myuser;PWD=mypass"
Quote:> > > The connection was sucess.
> > > I want to deploye my application to another PC without Oracle Client,
> how
> > to
> > > write the connection string, so it will describe host, port, user and
> > pass.
> > > Thanks in advance.
> > > joshua
by