Open Oracle Table through TTable

Charlie Brow

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Open Oracle Table through TTable

I use a TTable component to open a table in Oracle. When
I set the TTable component to active, there's a login prompt asking user
id and password before I could open the table in Oracle. Does anyone
know how could I by-pass this login prompt (without using a TDatabase
component)?

Thanx

Steve Koters

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Open Oracle Table through TTable

On Wed, 1 Dec 1999 23:46:14 +0800, "Charlie Brown"

Quote

<charliebrown...@yahoo.com> wrote:
>I use a TTable component to open a table in Oracle. When
>I set the TTable component to active, there's a login prompt asking user
>id and password before I could open the table in Oracle. Does anyone
>know how could I by-pass this login prompt (without using a TDatabase
>component)?

The TTable component, as the name of the class implies, is designed around
access to a table. Things like database connections and logins are not
related to tables, but to databases. For handling database-related aspects
of database programming, Delphi provides the TDatabase component.

I suppose you could make a custom component derived from TTable that
handles database connections, but the intended approach is just to use a
TDatabase.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Marc Scheune

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Open Oracle Table through TTable

On Wed, 1 Dec 1999 23:46:14 +0800, "Charlie Brown"

Quote

<charliebrown...@yahoo.com> wrote:
>I use a TTable component to open a table in Oracle. When
>I set the TTable component to active, there's a login prompt asking user
>id and password before I could open the table in Oracle. Does anyone
>know how could I by-pass this login prompt (without using a TDatabase
>component)?

I'd definitely suggest using a TDatabase object of your own - makes
life a whole lot easier! It allows you to specify username, password,
and more, and to suppress the login dialog. As far as I can tell,
that's the only way to easily accomplish what you want to do.

Marc

--------------------------------------------------------------------------
Marc Scheuner Berner Versicherungen, Dept. ISV
May the Source be With You Laupenstrasse 27
marc.scheu...@berner.ch CH-3001 BERNE, Switzerland
--------------------------------------------------------------------------

Other Threads

1. TTable won't open because of BLOB field in Oracle table

2. TTable.Open to Oracle 7.1 Slooooow

3. BDE slow to open Ttable against Oracle DB

4. SLLLOOOOOWWWW TTable Open on Large Tables

5. Open SQL Table with TTable and TDatabase

6. Problem with opening visual foxpro 6 table in Delphi 6 using BDE[TTable]

7. Problem with opening visual foxpro 6 table in Delphi 6 using BDE[TTable]

8. dBase and Paradox table created with TTable cannot be opened in MS Access

9. TTable.CreateTable - can't open created dbase4 table

10. How to open and read and write foxpor table in TTable of delphi