Personal Oracle7 & Delphi

dgs...@cs.usask.ca (David George Shaw)

Delphi Developer

Sun, 18 Jan 1998 03:00:00 GMT

Personal Oracle7 & Delphi

I have recently downloaded Personal Oracle 7 and was thinking of
using Delphi for my application development. Could anyone please
send me their comments and experiences using these two products.

Any information or help would be appreciated since I am new to
these two products.

Thank You in advance,

dgs...@cs.usask.ca
David Shaw
University of Saskatchewan

Gary Samuels

Delphi Developer

Mon, 19 Jan 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

Been there, done that...

First, purchase the CD-ROM for only $15. The CD-ROM has some good doc's
on it that enabled me to better use the tools available.

I was able to get to the Oracle tables through the database desktop which
made me believe that creating a delphi front would be no problem. My main
concern is speed though. Oracle needs 32 megs, so I'm told, in order to
run the Personal ver' well. On a 16 meg machine I wouldn't consider doing
anything more than demo's or tests.

If you're lucky enough to have an extra machine I'd set up a server.
Everything is included on that $15 CD-ROM (such a deal!).

NOTE: THE CD-ROM is a demo product that works VERY well. The license
lasts for 90days.

Laurence Bare

Delphi Developer

Thu, 22 Jan 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

Quote

In article <samuelsgDCqrxx....@netcom.com>, <samue...@netcom.com> writes:
> Newsgroups: comp.lang.pascal.delphi.databases
> Path: news.demon.co.uk!dispatch.news.demon.net!demon!uknet!tank.news.pipex.net!pipex!howland.reston.ans.net!newsfeed.internetmci.com!news.uoregon.edu!news.bc.net!unixg.ubc.ca!info.ucla.edu!news.ucdavis.edu!csus.edu!netcom.com!samuelsg
> From: samue...@netcom.com (Gary Samuelson)
> Subject: Re: Personal Oracle7 & Delphi
> Message-ID: <samuelsgDCqrxx....@netcom.com>
> Sender: samue...@netcom10.netcom.com
> Organization: NETCOM On-line Communication Services (408 261-4700 guest)
> References: <3vodln$...@tribune.usask.ca>
> Date: Thu, 3 Aug 1995 15:49:09 GMT
> Lines: 17

> Been there, done that...

> First, purchase the CD-ROM for only $15. The CD-ROM has some good doc's
> on it that enabled me to better use the tools available.

> I was able to get to the Oracle tables through the database desktop which
> made me believe that creating a delphi front would be no problem. My main
> concern is speed though. Oracle needs 32 megs, so I'm told, in order to
> run the Personal ver' well. On a 16 meg machine I wouldn't consider doing
> anything more than demo's or tests.

> If you're lucky enough to have an extra machine I'd set up a server.
> Everything is included on that $15 CD-ROM (such a deal!).

> NOTE: THE CD-ROM is a demo product that works VERY well. The license
> lasts for 90days.

I'd love to know how you connected to Personal Oracle 7. I am finding that I
can connect to an NT box but not to a local PO7 installation. I am told that
in the BDE config you have to clear the network protocol and the server name,
however I have still not tried this since I uninstalled PO7 when things were
not working.

Gary Samuels

Delphi Developer

Thu, 22 Jan 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

One problem I had was that POracle7 would not start automatically on
requesting data through ODBC. I have to first start-up Oracle manually
before things worked correctly.

Also, make sure that the alias is working. I think POracle ships with a
utility for testing the ODBC connection.

And, on some commands the results were slow enough for me to think of
problems before the answers returned. As a solution I wrote to Borlands
database and then just copied the tables to Oracle7 (but even this took
forever on my computer).

Sorry I can't be of more help.

BOON-CHEANG T

Delphi Developer

Fri, 23 Jan 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

I am having problem installing Delphi with PO7 (Local).
The ODBC drivers are installed, but everytime I need to connect to the server,
it prompt for the user name and password, which I keyed in correctly,
I get the message "SQL Error, interface not found"
Something to that extend.... anyone know what I am doing wrong?

I've tried using PO7's ODBC test program, and similar error occurs.

So how I am not able to use the ODBC driver

Steve Koters

Delphi Developer

Fri, 23 Jan 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

Quote

BOON-CHEANG TEO (te...@sgp.hp.com) wrote:

: I am having problem installing Delphi with PO7 (Local).
: The ODBC drivers are installed, but everytime I need to connect to the server,
: it prompt for the user name and password, which I keyed in correctly,
: I get the message "SQL Error, interface not found"
: Something to that extend.... anyone know what I am doing wrong?

: I've tried using PO7's ODBC test program, and similar error occurs.

Sounds like the problem is not to do with Delphi, at all, but with the
installation and/or configuration of the ODBC driver or Personal Oracle.
If you cannot connect using the Personal Oracle test program, I can
virtually guarantee that Delphi would not be able to connect.

Double-check the installation of Personal Oracle and the ODBC driver. You
might also consider contacting Oracle technical support. Once you get a
working communication between Personal Oracle and the ODBC driver, you
should also be able to use the ODBC driver in Delphi (assuming that
Delphi will be able to access Personal Oracle databases through this
ODBC driver at all).

--
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
_/ Steve Koterski _/ The opinions expressed here are _/
_/ koter...@borland.com _/ exclusively my own _/
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

Michael Sande

Delphi Developer

Fri, 23 Jan 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

In article <405brb$...@druid.borland.com>, koterski@genghis (Steve Koterski) says:

Quote

>BOON-CHEANG TEO (te...@sgp.hp.com) wrote:
>: I am having problem installing Delphi with PO7 (Local).
>: The ODBC drivers are installed, but everytime I need to connect to the server,
>: it prompt for the user name and password, which I keyed in correctly,
>: I get the message "SQL Error, interface not found"
>: Something to that extend.... anyone know what I am doing wrong?

Make sure the installation updated your path to include
the orawin\bin directory. This is a known bug for the orainst.exe
also make sure the LOCAL variable is set in the ORACLE.ini file
in your windows directory. What version of the ODBC are you using?

Hope it Helped.

Houssam Hennao

Delphi Developer

Mon, 02 Feb 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

Can anybody tell me where to download PO7 from, or how can I buy that $15 CD.
Thanks in advance.

Reza Bin Raqui

Delphi Developer

Mon, 02 Feb 1998 03:00:00 GMT

Re:Personal Oracle7 & Delphi

HTTP://WWW.ORACLE.COM/

Follow instructions.

============================================
Reza Bin Raquib, RRAQ...@PANIX.COM
SYSTEMS 2000, 516-698-6391
"We will make your business look good"
============================================

Other Threads

1. Personal Oracle7.3 & Delphi

2. Delphi to Personal Oracle7?

3. Personal Oracle7

4. Using Personal Oracle7

5. Using Personal Oracle7

6. Question about Delphi&Oracle7

7. Delphi CS, Oracle7.2 & SQLNetV2.2

8. Delphi & Personal Oracle 7.3 Connection Problem

9. Delphi & Personal Oracle 7

10. Personal Oracle 7.2 & Delphi 1.02 C/S