what is Oracle 10g driver name?

[opb]

Could anyone please tell me what is the Oracle 10g driver
name? I'm using PB11.1 and Oracle10g. When I use DBMS=Oracle
in OraDb10g, I'm getting error of driver not support in
current installation, although it shows in my ODBCINST.ini -
any hint will be appreciated greatly.

[Terry Dykstra]

The native driver is O10. If you are using ODBC, then use ODB and set the
sqlca.dbparm parameters accordingly.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://case-express.sybase.com/cx/welcome.do
http://my.isug.com/index.php?mo=is&op=in
<opb> wrote in message news:48acccaf.6e3...@sybase.com...

[opb]

Thanks Terry for the hint. I'm using ODBC and I set
'DBMS=O10 Oracle 10g' with parameters in INI file. But the
client still complain Oracle 10g driver is not installed.
Could you please tell me what I may still miss here?

Thanks in advance,
Opb

[Roland Smith [TeamSybase]]

Did you install the Oracle Client software on the end user's pc?

<opb> wrote in message news:48b37b5f.662...@sybase.com...

[Terry Dykstra]

If you're using ODBC, then you must use DBMS=ODB.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/

http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<opb> wrote in message news:48b37b5f.662...@sybase.com...

[opb]

No, and the clients don't think they have to because they
didn't install Oracle9i client and are able to connect to
Oracle 9i for PB6.5 applications. Could you please provide
me with a list of PB110 DLLs required to estabilish the
connection to 10g? Or give me a hint of what we may still
missing here.

Thanks

[Paul Horan[TeamSybase]]

<opb> wrote in message news:48b41bf9.5e...@sybase.com...

> No, and the clients don't think they have to because they
> didn't install Oracle9i client and are able to connect to
> Oracle 9i for PB6.5 applications. Could you please provide
> me with a list of PB110 DLLs required to estabilish the
> connection to 10g? Or give me a hint of what we may still
> missing here.

That's exactly what the Runtime Packager will do for you...

Paul Horan[TeamSybase]

[opb]

Paul, what is the Runtime Package you mention here? Do you
mean client will have to install the entire package on each
machine?
Thanks in advance!

[Nancy]

Hi Terry, I'm not so sure if clent is using ODBC but the
application is using below ini file to connect to Oracle.
Could you please tell me how to modify this file?

[Database]
//DBMS=O73 ORACLE 7.3
DBMS=O10 Oracle10g
Database=
UserId=
DatabasePassword=
ServerName=@TNS:pbdv_qa8
DbParm=

[Terry Dykstra]

Impossible. You cannot connect to Oracle without having a Oracle client
installed. The exception being when you use a Java Lite driver. In that
case you don't need Oracle client.
You're PB 6.5 application is probably using a very old Oracle client,
possibly 7.3. If so, you will not be able to connect to Oracle 10g, since
Oracle disabled some of that functionality. You will need 8i or later
client installed.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/

http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<opb> wrote in message news:48b41bf9.5e...@sybase.com...

[Terry Dykstra]

Assuming you just replaced the O73 line with the O10 line: you are not
using ODBC but the native driver. That driver is using sqlnet 2.3
functionality (i.e. Oracle 7.3 client).
It will not work against Oracle 10g.
The O10 driver will not work with anything less than 10g client. You must
install the 10g client. You can get a 10g lite client that consists of only
a few dlls, as opposed to the regular fat 10g client.
BTW, when using any native driver after O73, you specify the servername just
as:
servername=pbdv_qa8 (leave out the @TNS: part).

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Nancy> wrote in message news:48b4280f.7c...@sybase.com...

[Chris Pollach]

Nancy / Terry;

Can you not install the OCI layer on a server and just point to it from
the various clients. That is how I install Sybase's ASE OpenClient. Then all
I have to do is change the server mapping to a different BIN folder and
everyone in the corporation uses the new version!

Just a suggestion (if its possible).

:-)

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

<Nancy> wrote in message news:48b4417b.cd...@sybase.com...
> Thanks Terry for your clear explaination and confirmation
> that Oracle10g client installation is necessary. Now we are
> facing another difficulty of installing it onto more than
> 100 users' machine. Could you please provide us with a
> better solution?
> ...Nancy

[Nancy]

Thanks Terry for your clear explaination and confirmation
that Oracle10g client installation is necessary. Now we are
facing another difficulty of installing it onto more than
100 users' machine. Could you please provide us with a
better solution?
...Nancy

> Impossible. You cannot connect to Oracle without having a

[Nancy]

Thanks Chris for your kindly suggestion. Before I can try it
out, could you please provide me with more details steps to
follow?

Nancy

[Chris Pollach]

I know what to do for ASE .. I was just wondering if anyone (DBA) had tried
this with Oracle? logically, this makes your DB Client software easier to
manage (IMHO). However, I am not an Oracle expert.

<Nancy> wrote in message news:48b44b86.f6...@sybase.com...

[fisher]

Oracle client is fairly simple installation. I remember our support team
brought it down to one folder and one registry key to be added.

Anyway being in Nancy's shoes : new version of PB (Unicode)/new Oracle
Client I'd look for response files for client installation or test
Oracle instant client. i must admit that playing with Oracle/PB for
years never used Oracle Instant Client, we just treated this
installation as fully justified part of process.

Talk to your support guys, maybe they can suggest you some solutions.
Maybe you could do this as a part of upgrade (mentioned above copying
one folder and running a .reg file sounds like a simple procedure).

Anyway good luck.

[Terry Dykstra]

It's definitely possible. That's how I have been doing it with out 9i
client. 1 registry entry and one path statement update.

However, with Oracle 10g you have the option of installing the Oracle 10g
Instant client. That requires only a few dlls, which you place in the
application fodler.

http://www.oracle.com/technology/tech/oci/instantclient/index.html

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Chris Pollach" <cpol...@travel-net.com> wrote in message
news:48b442de$1@forums-1-dub...

[Paul Horan[TeamSybase]]

Start > All Programs > Sybase > PowerBuilder 11 (or 10, or 9) > PowerBuilder
Runtime Packager.

It gathers together all the runtime DLLs that you'll need to deploy along
with your custom EXE/PBDs. It's documented in the Help files.

Paul Horan[TeamSybase]

<opb> wrote in message news:48b42351.73...@sybase.com...

[Uman]

Hi,

If Oracle 9 was installed, just use O90 to replace O10 for dbms parameter.

IE DBMS=O90...

<opb> wrote in message news:48acccaf.6e3...@sybase.com...