Personal Oracle

[Marek Gazda]

Hi

Please could you help me?
I installed Personal Oracle 8.0.4 on win98.
How could I connect to local database by ODBC driver.
When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can't
configure database source, because when I click Add - do nothing.
What I need to do, which tools is require. I installed ODBC driver and JDBC
with Personal Oracle.
Please help.

Mark

[Anna C. Dent]

Marek Gazda wrote: Hi Please could you help me? I installed Personal Oracle 8.0.4 on win98. How could I connect to local database by ODBC driver. When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can't configure database source, because when I click Add - do nothing. What I need to do, which tools is require. I installed ODBC driver and JDBC with Personal Oracle. Please help.

With Personal Oracle network connections are NOT supported/included.
It is a "personal" database & meant only to be accessed via the
system upon which it is installed. Therefore no SQL*Net support is
NOT required or exists.

[Hans Forbrich]

"Anna C. Dent" wrote: Marek Gazda wrote: Hi Please could you help me? I installed Personal Oracle 8.0.4 on win98. How could I connect to local database by ODBC driver. When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can't configure database source, because when I click Add - do nothing. What I need to do, which tools is require. I installed ODBC driver and JDBC with Personal Oracle. Please help.

First off - is there any particular reason for using 8.0.4?

There have been a few enhancements, bug fixes, standards 'conformances',
and miscellaneous other adjustments in the Oracle product since 1998.
If possible I'd encourage upgrading Oracle 8i (8.1.7) or even 9i.
Oracle9i Release 1 (9.0.x) IS compatible & certified with Win98. There
is even a set of documentation available specifically for Win98. Sadly
support has officially stopped with 9.0 and it's highly unlikely that
9iR2 will install or run under Win98.
With Personal Oracle network connections are NOT supported/included. It is a "personal" database & meant only to be accessed via the system upon which it is installed. Therefore no SQL*Net support is NOT required or exists.

Personal Oracle is intended as a single user system and is licensed by
named user. There is no reason or requirement to have the
database/instance on the same system as the user. It makes perfect
sense, especially for a single person company (e.g.: an IT consultancy),
to have Personal Oracle installed on a single 'database' machine and the
one user accessing the same database from the 'development' machine, the
separate 'admin.' machine and the separate 'demo' machine. As far as I
can tell, that connectivity is permitted under the license, as long as
the 'One Named Plus User per Database' rule is maintained.

Under Win98, the listener is installed by default, but not required or
active.

As far as I can tell, it is possible (and permitted) to interact with
the database over a network. For more info - check ORACONCT in
metalink.

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]

[Dave Mausner]

"Hans Forbrich" <forbrich@yahoo.net> wrote in message
news:3FA952F5.20A7C51D@yahoo.net... "Anna C. Dent" wrote: Marek Gazda wrote: Please could you help me? I installed Personal Oracle 8.0.4 on win98. How could I connect to local database by ODBC driver. With Personal Oracle network connections are NOT supported/included. Personal Oracle is intended as a single user system and is licensed by named user. There is no reason or requirement to have the database/instance on the same system as the user. As far as I can tell, it is possible (and permitted) to interact with the database over a network. For more info - check ORACONCT in metalink.

hans is absolutely correct. you can use the Net Assistant to create the
network files, then minimally click start/run and enter "lsnrctl start". a
TCP connection to 127.0.0.1 will simulate connections you make in a
corporate production environment.
--
Dave Mausner / v.+1-708-848-2775 / f.+1-708-848-2569 / c.+1-312-wake-my-i

[Robert C]

> With Personal Oracle network connections are NOT supported/included.

Original poster did not say anything about "network connections"
SQL*Net connection IS INCLUDED/INSTALLED but not supported.


With Personal Oracle network connections are NOT supported/included. It is a "personal" database & meant only to be accessed via the system upon which it is installed. Therefore no SQL*Net support is NOT required or exists.

[Robert C]

>When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can'tconfigure database source, because when I click Add - do nothing.

Now, How is that possible ? How were you able to choose "ORACLE ODBC Driver"
FIRST ?
Make sure you provide correct info before asking for help.

With "ODBC Adminstrator" , the sequence of events is: Add... > Select a
driver > Finish....

Most likely your Windoz or ODBC installation is "corrupted" - time to
upgrade...really



"Marek Gazda" > Hi installed Personal Oracle 8.0.4 on win98. How could I connect to local database by ODBC driver. When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can't configure database source, because when I click Add - do nothing. What I need to do, which tools is require. I installed ODBC driver and
JDBC with Personal Oracle. Please help. Mark