Database Desktop Failure

Greg deFleron

Delphi Developer

Fri, 02 Aug 2002 03:00:00 GMT

Creating Oracle 8 Table w/ Database Desktop Failure

Hello All,

I am attempting to create a Oracle 8 table using the Database Desktop. I
am usingD5 Enterprise. The error that I get is "Vendor initialization
Failed". What does this mean? Do I have to Purchase Oracle to utilize
their table structure?

Any Help will be greatly appreciated.

<GdeF>

Team

Delphi Developer

Fri, 02 Aug 2002 03:00:00 GMT

Re:Creating Oracle 8 Table w/ Database Desktop Failure

Yes, you must hace the Oracle Client installed on your machine to be able to use
the Oracle SQL Link driver.

Quote

Greg deFleron wrote:

> Hello All,

> I am attempting to create a Oracle 8 table using the Database Desktop. I
> am usingD5 Enterprise. The error that I get is "Vendor initialization
> Failed". What does this mean? Do I have to Purchase Oracle to utilize
> their table structure?

> Any Help will be greatly appreciated.

> <GdeF>

--
Jeff Overcash (TeamB) On waves of silver I dreamed of gold
(Please do not email 'Till I lost the peace that dreaming gives
me directly unless I dreamed of the moment of my own death
asked. Thank You) That no one ever dreams and lives (Marillion)

Greg deFlero

Delphi Developer

Sat, 03 Aug 2002 03:00:00 GMT

Re:Creating Oracle 8 Table w/ Database Desktop Failure

Thanks Jeff,

I placed the ORACLE CLIENT on my machine. The client was looking for the ORACLE
SERVER and I used the default name in the setup. I was able to create a table in the
DATABASE DESKTOP, however, I could not save the structure. The error reported that
the server could not be found.

I have been using PARADOX TABLES in the past and have heard and read where the
DIRECT ORACLE ACCESS VCL speeds up programs 3 to 5 times without having to use the
BDE. So I am trying to learn how to use this technology to improve the many
applications that I have written here at work. They tend to be slow due to the
amount of data we process.

Should I purchase the ORACLE Personal Edition to accomplish this desire, or is there
another way to create Oracle tables that can be accessed directly from my D5 C/S
applications? I do not consider myself a newbee to Delphi, but I have had no
experience with Oracle. Everything I have read about Oracle tables seams to state
that they have set the standard for reliability and flexibility.

Please advise with any information that you or anyone in the newgroup has to offer.

Thanks

<GdeF>

Quote

"Jeff Overcash (TeamB)" wrote:
> Yes, you must hace the Oracle Client installed on your machine to be able to use
> the Oracle SQL Link driver.

> Greg deFleron wrote:

> > Hello All,

> > I am attempting to create a Oracle 8 table using the Database Desktop. I
> > am usingD5 Enterprise. The error that I get is "Vendor initialization
> > Failed". What does this mean? Do I have to Purchase Oracle to utilize
> > their table structure?

> > Any Help will be greatly appreciated.

> > <GdeF>

> --
> Jeff Overcash (TeamB) On waves of silver I dreamed of gold
> (Please do not email 'Till I lost the peace that dreaming gives
> me directly unless I dreamed of the moment of my own death
> asked. Thank You) That no one ever dreams and lives (Marillion)

Team

Delphi Developer

Sat, 03 Aug 2002 03:00:00 GMT

Re:Creating Oracle 8 Table w/ Database Desktop Failure

Database Desktop is designed for desktop type of DBs. I can't remember, but I
don't think it works with SQL backends like Oracle, InterBase, MS SQL etc very
well if at all. A great replacement for DD to work with Oracl is TOAD. You can
create tables, generators, etc very easily with it. You can find TOAD at
www.toadsoft.com. TOAD comes both as a freeware version and a retail version.

DOA does indeed speed up Oracle access greatly over even the BDE SQL Links
driver for Oracle. On of the speed features is to remember to set the
ReadBuffer. That more than anything gives the impression to the user of faster
performance since you can have it pull data over in smaller chunks giving
quicker response time to when the end user has control again.

As for pDox vs Personal Oracle w/ DOA if this is a saingle user situtation, pDox
will beat PO fairly regularly. DOA access to Oracle will be faster than BDE
access to Oracle, but when you are throwing in a file based DB into the mix in a
single user environment it is totally different. PO has a great deal of
overhead that a file base DB does not have and therefore will perform slower
than pDox. Oracle will scale much better as you add users. IOW you don't see
as much a performance hit as you add users.

Oracle may have set the standard in flexibility and reliability, but they have
also set the standard for over complicating things also. Oracle takes more
effort not only to learn, but also to maintain over time. Personally I would
suggest you look at InterBase also. InterBase gives you the same SQL backend
power as Oracle but is much easier to maintain after deployment. With IB 6
being Opensourced it looks as if IB 6 will also be free to distribute (something
you won't have with Oracle).

Quote

Greg deFleron wrote:

> Thanks Jeff,

> I placed the ORACLE CLIENT on my machine. The client was looking for the ORACLE
> SERVER and I used the default name in the setup. I was able to create a table in the
> DATABASE DESKTOP, however, I could not save the structure. The error reported that
> the server could not be found.

> I have been using PARADOX TABLES in the past and have heard and read where the
> DIRECT ORACLE ACCESS VCL speeds up programs 3 to 5 times without having to use the
> BDE. So I am trying to learn how to use this technology to improve the many
> applications that I have written here at work. They tend to be slow due to the
> amount of data we process.

> Should I purchase the ORACLE Personal Edition to accomplish this desire, or is there
> another way to create Oracle tables that can be accessed directly from my D5 C/S
> applications? I do not consider myself a newbee to Delphi, but I have had no
> experience with Oracle. Everything I have read about Oracle tables seams to state
> that they have set the standard for reliability and flexibility.

> Please advise with any information that you or anyone in the newgroup has to offer.

> Thanks

> <GdeF>

> "Jeff Overcash (TeamB)" wrote:

> > Yes, you must hace the Oracle Client installed on your machine to be able to use
> > the Oracle SQL Link driver.

> > Greg deFleron wrote:

> > > Hello All,

> > > I am attempting to create a Oracle 8 table using the Database Desktop. I
> > > am usingD5 Enterprise. The error that I get is "Vendor initialization
> > > Failed". What does this mean? Do I have to Purchase Oracle to utilize
> > > their table structure?

> > > Any Help will be greatly appreciated.

> > > <GdeF>

> > --
> > Jeff Overcash (TeamB) On waves of silver I dreamed of gold
> > (Please do not email 'Till I lost the peace that dreaming gives
> > me directly unless I dreamed of the moment of my own death
> > asked. Thank You) That no one ever dreams and lives (Marillion)

Other Threads

1. Database desktop will not create PAradox 7.0 table

2. How to create MS ACCESS table in Database Desktop

3. Newbie: Creating Interbase Tables with Database Desktop

4. Creating FoxPro Tables With Database Desktop

5. Database Desktop & Create Table based on SQL

6. Cannot create Dbase v7 table from Database Desktop.

7. Create a MSACCESS table in database desktop

8. Cannot create paradox 7 tables in database desktop

9. How I do to create a secondary index to paradox tables without the DataBase DeskTop

10. Closing the Database Desktop results in a General Protection Failure