Hi.

I'm building a console application using my D3 c/s. The application is
trying to connect to local Oracle 8 server this way:

var aSQL : tQuery
begin
a SQL:=TQuery.Create(nil);
aSQL.DatabaseName:=odbc_alias;
aSQL.SQL.Add('SELECT * FROM cispop');

writeln('Trying to connect ODBC');
try
        aSQL.Open;
except
        writeln('Connection failed');
        aSQL.Free;
        Exit;
end;
writeln('Connected');
......
but result is:
"Trying to connect ODBC" and here the application terminates without
"Connection failed" or exception violation message. The same
application works normaly with ODBC alias to Access7 database.
I'm using original Oracle ODBC driver and I successfuly tested the
alias on Oracle ODBC Test.
Please, do you know, what is wrong with it?

I'm also experiencing problems using D3 C/S NT4-sp3 and Oracle8 on an NT4
Server. In simple terms, I create a new form with a DB and a Table
component.
I point the DB comp. to my Oracle8 datasource, set the DB parameters to
default, and fill in the user name and password.
    I can then connect the DB component at design time OK. When I link the
TTable to the DB, still at design time, and click the property inspector
item TABLE - to select the oracle table I require, my entire Delphi 3 IDE is
terminated without any indication what is wrong. Intermittently I've seen an
Access Violation in one or the OR8...DLLs. This problem is ONLY occurring
when the datasource is Oracle8!

I have traced the ODBC calls to the point where the driver has obtained the
definition of the result set and at the point after the first
SQLExtentedFetch - the log ends.

I have patched D3 to 3.02 and NT4 is at Service Pack3. Please help...

Stew

Hi Georg,

I also had "special effects" using Oracle 8 ODBC drivers supplied with
Oracle 8 with both Delphi and the Database explorer. Upgrading the ODBC
driver to 8.0.4.4.0 seemed to solve my problems.