problem of ODAC pro 6 direct access oracle 9i

liyf · Post by **liyf** » Sat 31 Mar 2007 00:43

i buy a single licence of odac pro6 several days ago. i download the soft and install, but i cann't use "ORASESSION.OPTION.DIRECT" set to TRUE to connect to oracle 9i. prompt me "access vialation".

User Name: dmis
Password: dmis
Server: 127.0.0.1:1521:orcl

OCI: version 9.2.0.1.0 (not loaded)
DLL: Y:\oracle\ora92\bin\oci.dll
HOME(OraHome92): Y:\oracle\ora92
Current Home: Y:\oracle\ora92
Call style: v8
Oracle:
OS: windows 2003

how to solve above problem? thanks.

Plash · Post by **Plash** » Mon 02 Apr 2007 08:17

We could not reproduce the problem. Please provide the Pascal code that results in access violation.

liyf · Post by **liyf** » Mon 02 Apr 2007 10:23

i use "odacdemo" sample code and check "direct", then prompt me access vialation. my developping tools is "delphi 5", is its version too low to cause the problem?

plash wrote:We could not reproduce the problem. Please provide the Pascal code that results in access violation.

Challenger · Post by **Challenger** » Mon 02 Apr 2007 15:20

Please specify the version of Delphi or CBuilder you use.

liyf · Post by **liyf** » Tue 03 Apr 2007 22:05

I am using "Delphi 5.0". can you send me a last version of odac 5.8? i want to try the problem is same in that version.

challenger wrote:Please specify the version of Delphi or CBuilder you use.

Challenger · Post by **Challenger** » Wed 04 Apr 2007 12:50

Please, try to create a new project and test connecting of TOraSession in Direct mode (the Direct property is set to True) at runtime. Try to connect TOraSession in design time. Please specify whether you have ODAC for C++Builder 5 installed.

liyf · Post by **liyf** » Sun 08 Apr 2007 08:43

i havn't installed ODAC for C++ Builder 5. cann't connect to oracle 9i in design time, show the same message.

challenger wrote:Please, try to create a new project and test connecting of TOraSession in Direct mode (the Direct property is set to True) at runtime. Try to connect TOraSession in design time. Please specify whether you have ODAC for C++Builder 5 installed.

Challenger · Post by **Challenger** » Tue 10 Apr 2007 12:08

Please try to install the new build of ODAC (6.00.0.5) with the force key (odac600cb5pro.exe /force).