Hi, folks...

I'm trying to use Delphi 4 Professional Update #2 and Intersolv ODBC 3.11

to connect to Oracle 7.3.3.6. To my knowledge, all my product versions
are certified by Inprise, but I cannot get the connection to work, and
Inprise wants to charge me $225 to fix it. I work for a small private
university, and we can't afford that kind of thing.

Here's what happens:

I use the Database Form Wizard to create a form with a grid on it, using
an ODBC-to-Oracle alias from the BDE. The wizard opens the connection
just fine, and shows me all the Oracle tables available to me. I choose
one, select a couple of columns, and tell it to place them in a grid.

I attempt to run the form, and the logon dialog box pops up. I log in
appropriately, and the new app immediately crashes with the following
message:

        access violation at 0x4be43581: read at address 0xff7d8d4
        83 3A 00 74 63 E8 36 6B FF FF 64 8B

The assembly window is stopped at:

        4BE43581     cmp dword ptr [edx],$00

I'm able to use the ODBC setup successfully from other applications (i.e.

Microsoft Access), and the Oracle setup works correctly on its own (such
as using local SQL*Plus, etc.).

Anyone have any ideas? This has been plaguing me for some time, and it
would really help me out around here to be able to work with Oracle
through Delphi rather than have to use Visual Basic (yuck...)

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Jayson T. Garrett, Mississippi College Computer Center
P.O. Box 4026, Clinton, MS 39058
601.925.3826   garr...@mc.edu   http://www.mc.edu/~garrett

The universe runs on the complex interweaving of three elements:
energy, matter, and enlightened self-interest.
        - G'Kar
          Babylon 5

If you are using NT, it could be caused by Oracle trace services.  Disable
or uninstall.  Search this newsgroup using dejanews for "oracle trace" for
more details.

V/R
Russell

Thanks, Russell!

I simultaneously got the same answer from Marco Kalter of Allround
Automations in the Netherlands.

The workaround he says Oracle suggested was to rename the Oracle Trace
Services registry key, HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OTRACE73.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Jayson T. Garrett, Mississippi College Computer Center
P.O. Box 4026, Clinton, MS 39058
601.925.3826   garr...@mc.edu   http://www.mc.edu/~garrett

The universe runs on the complex interweaving of three elements:
energy, matter, and enlightened self-interest.
        - G'Kar
          Babylon 5