> 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"
> 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

> 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"
> 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

> 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"
> > 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

> 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"
> 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

> you may want to consider placing all of you database access code into an
ActiveX
> component, and installing that client either on the database server or
some
> server machine that has Oracle Client software installed (i.e. Sql*Net or
Net8).
> Then it's a rather straight forward process to register the component
during
> normal application deployment.

> Please note that doing such does not relax any of the Oracle Client
License
> requirements.

> Also, you may want to consider switching to a native oledb provider.  Both
> MSDAORA and OraOLEDB.Oracle are noticeably more efficient than the ODBC
wrapper.

> best regards,
> roy fine

> > 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"
> > 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

> "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

> > > 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

> >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"
> > > > 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

> It sounds more complicated than I tought....
> Do you have any idea to deploy easily to the user's PC with least user
> interaction (bundling Oracle Client into the Application Package)

> Thanks in advance mike...

> joshua

> > > 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.

> > >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"
> > > > > 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