Topic: Problems on logical driver definition for Oracle 8 and 10
|
|
mjaeger
User
Fresh Boarder
| Posts: 6 |   |
Karma: 0
|
|
Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/07 14:52 |
|
|
|
|
Hello,
in our environment two versions of Oracle DBMS are running:
V8.1.7.4
V10.1.0.3
Both clients are installed. Using the AD Tools (Explorer, Executor) I have encountered a problem accessing Oracle 8 Database through Oracle 10 Client: Ora-03113 "end of file on communication channel".
I reckon this behaviour is a problem of our special configuration using DBLinks/Synonyms/Views/Whatever... - although this is no problem using Oracle Client tools like SQLPlus.
However I have been partially successfull in creating a working environment for AnyDAC by introducing an AnyDACDrivers.ini (see end of this posting). Now AD Tools (Explorer, Executor) are working just fine without any further problems.
Alas accessing any Oracle connection (I am using the little demo mentioned in 4.1 of "AnyDAC Getting Started Guide") using Delphi 6 IDE is now impossible, because the AnyDAC environment is throwing the following exceptions:
[AnyDAC][Phys]-318: Cannot register driver in it current state
[AnyDAC][Phys]-319: Cannot register driver in it current state
On exiting Delphi IDE another exception is thrown:
[AnyDAC][Phys]-334: ADPhysManager shutdown timeout. Possible reason: application has not released all connection interfaces.
Obviously this problem occurs due to my editing of the AnyDACDrivers.ini... Any hint or suggestion solving this issue is welcome.
Regards
M.J
--------------------- cut --------------------
[Ora]
PackageD6=daADPhysOraclD6.bpl
[Ora8]
BaseDriverID=Ora
VendorHome=D:ORAWINORAnt
VendorLib=D:ORAWINORAntbinoci.dll
[Ora10]
BaseDriverID=Ora
VendorHome=D:oracleproduct10.1.0Client_1
VendorLib=D:oracleproduct10.1.0Client_1binoci.dll
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/08 01:02 |
|
|
|
|
Hi !
> Any hint or suggestion solving this issue is welcome.
Thank you for reporting !
There was few issues not allowing AnyDAC application to work with packages. I have fixed them. Next release will work well.
Regards,
Dmitry
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/08 01:12 |
|
|
|
|
Also, in case of Oracle:
- VendorHome is the name of Oracle home, but not a path to the installation of Oracle software. Run Oracle Home Selector utility, it will list all home names.
- VendorLib allows to specify alternative Oracle client library. If it is default - OCI.DLL in your Oracle home Bin directory - then no need to specify VendorLib.
And in next version will be changes:
- no need to specify PackageDx, if package name is default and DPL is in PATH.
- default driver INI files name will be ADDrivers.ini.
So, your ADDrivers.ini may be shorted to:
[Ora8]
BaseDriverID=Ora
VendorHome=<Oracle 8 home name>
[Ora10]
BaseDriverID=Ora
VendorHome=<Oracle 10 home name>
I will update documentation too.
Regards,
Dmitry
|
|
mjaeger
User
Fresh Boarder
| Posts: 6 | |
Karma: 0
|
|
RE: Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/08 18:56 |
|
|
|
|
Hello Dmitry,
thank you for your responses.
> There was few issues not allowing AnyDAC application to work with packages.
> I have fixed them. Next release will work well.
I am anxiously awaiting it.
> - VendorHome is the name of Oracle home, but not a path to the installation of Oracle software.
Ok, I changed these settings. Thanks for pointing this out.
Apart of my own (little) problems I have to say that this is a very fine framework. And an excellent job done so far.
Best regards
M.J
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/08 23:04 |
|
|
|
|
The next release will be around middle of the next week.
> I am anxiously awaiting it.
You know they to speedup things with AnyDAC <g>
Regards,
Dmitry
|
|
Diman
Admin
Admin
| Posts: 1495 | |
Karma: 19
|
|
RE: Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/08 23:04 |
|
|
|
|
|
they = the way
|
|
mjaeger
User
Fresh Boarder
| Posts: 6 | |
Karma: 0
|
|
RE: Problems on logical driver definition for Oracle 8 and 10
|
|
Posted: 2005/07/11 16:30 |
|
|
|
|
> The next release will be around middle of the next week.
Wow!
> You know they to speedup things with AnyDAC <g>
Do you mean I have to kidnap you ? ... <g,d&r>
Ok, ok, of course I know what you mean <g>
Regards
M.J
|
|
|
